This holds the mapping from attributes to column_groups.
att_col_grp_map_s (PK, M: CHAR VARYING(19))
Surrogate key of the table.
attribute_s (FSK, M: CHAR VARYING(19))
att_col_grp_map.attribute
This is the attribute that is being mapped to the column_group.
Defines a foreign key to table attribute.
column_group_s (FSK, M: CHAR VARYING(19))
att_col_grp_map.column_group
This is the coulmn_group the attribute is being mapped to.
Defines a foreign key to table column_group.
prod_versn_s (FSK, M: CHAR VARYING(19))
att_col_grp_map.prod_versn
This is the production version number of the projection run used to create this mapping.
Defines a foreign key to table prod_versn.
projected_ent_s (FSK, M: CHAR VARYING(19))
att_col_grp_map.projected_ent
This is the subtype entity that is being projected, which may or may not be the parent entity for this attribute. For example, consider the attribute "name" in the entity activity. If activity is not projected as a table, but its subtypes are, then for each subtype projected as a table there would be a mapping from the subtype entity for the attribute "name".
Defines a foreign key to table entity_def.
ref_proj_meth (FNK, M: CHAR VARYING(40))
att_col_grp_map.ref_proj_meth
This is the method used to map the attribute to the column_group.
Defines a foreign key to table ref_proj_method.