column_def.optionality
This is TRUE (Y) if the column is optional.
part_of_si (M: CHAR(1))
column_def.part_of_si
This is TRUE (Y) if this is a column that is projected from an attribute that is part of a UNIQUE clause. The UNIQUE clause must either apply directly to the entity that is projected as the parent table for this column, or applies to a supertype of the entity projected as the parent table.
type_code (M: CHAR(1))
column_def.type_code
Type_code values: "C" for normal column "S" for surrogate key column "N" for (part of) natural key column "E" for entity type name column "T" for table type name column "F" for foreign key based on surrogate key "K" for (part of) foreign key based on natural key
parent_table_s (FSK, M: CHAR VARYING(19))
column_def.parent_table
The table in which this column is defined.
Defines a foreign key to table table_def.
prod_versn_s (FSK, M: CHAR VARYING(19))
column_def.prod_versn
The production version number of the projection run that produced this column_def.
Defines a foreign key to table prod_versn.
sql_type_nm (FNK, M: CHAR VARYING(40))
column_def.sql_type_nm
This is the underlying sql type of the column.
Defines a foreign key to table sql_type.
fixed_length (O: CHAR(1))
column_def.fixed_length
This is TRUE (Y) if the column is fixed length.
max_length (O: INTEGER)
column_def.max_length
This holds the maximum length of the column.
duplicate_thru_s (FSK, O: CHAR VARYING(19))
attribute.duplicate
The columns that are duplicated through this attribute.
Defines a foreign key to table attribute.
duplicate_from_s (FSK, O: CHAR VARYING(19))
column_def.duplicate_from
If this is a denormalized column, then this points to the source of the denormalization.
Defines a foreign key to table column_def.
related_column_s (FSK, O: CHAR VARYING(19))
column_def.related_column
If the column represents a relationship to another table, this column points to the column_def instance that is the destination of the relationship. This column will be populated only if there is a related table, i.e. not for all columns that represent a relationship. If a column represents a relationship to an entity that is projected into multiple tables, we cannot point to a single column, and this column (and the related table column) will not be populated.
Defines a foreign key to table column_def.
related_ent_s (FSK, O: CHAR VARYING(19))
column_def.related_ent
Holds the entity that the attribute that this column is a projection of points to, if it is a relationship attribute/column
Defines a foreign key to table entity_def.
related_table_s (FSK, O: CHAR VARYING(19))
column_def.related_table
This points to the table that this column points to, if it is only one (i. e. no _t column.
Defines a foreign key to table table_def.