POSC Meta Model Specifications Version 2.3 |
Meta Data Relational Implementation |
A column_group defines a group of columns that together provide some logical meaning or a physical constraint. For example, if you have two columns that represent a quantity of length, one holding the numeric length value and the other holding the unit of measure that qualifies the numeric value, then these form a logical pair that is expressed with a column_group. Another example of column_group is to define those columns which are used in the construction of an index.
- column_group_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- column_def_s (FSK, M: CHAR VARYING(19))
- column_group.column_def
One of the columns that makes up this column_group,
Defines a foreign key to table column_def.
- head_col_grp_s (FSK, M: CHAR VARYING(19))
- column_group.head_col_grp
The "head" of this column_group, i.e. the column that is the first one of this group.
Defines a foreign key to table column_group.
- prod_versn_s (FSK, M: CHAR VARYING(19))
- column_group.prod_versn
The production version of the projection run that resulted in this column_group.
Defines a foreign key to table prod_versn.
- ref_column_grp_kd (FNK, M: CHAR VARYING(15))
- column_group.ref_column_grp_kd
The kind of column_group, for example an index, or a projection of a complex attribute.
Defines a foreign key to table ref_column_grp.
- column_group_nm (O: CHAR VARYING(40))
- column_group.column_group_nm
The name of this column_group.
Table is related to: att_col_grp_map, column_group
Primary Key Constraint on: COLUMN_GROUP_S
© Copyright 1997-2001 POSC. All rights reserved.