A DBMS column is a partial policy-descriptor of a DBMS Table. The DBMS Table provides the overall policy-context within the scope of the DBMS Schema for the DBMS Columns which, in turn, acts as a data-based property descriptor for the DBMS Table.
There are four classes of data-based properties, that is, DBMS Columns, that can be assigned to DBMS Tables. The classes are:
- Uniqueness -- the value of one or more data-based properties that when used as a selector retrieves one and only one instance.
- Audit -- the data-based properties that enable knowing the metadata surrounding the Who, What, When, Where, Why, and How of a created or updated instance.
- Relationship -- the data-based property that is subsequently employed in a different Table to enable a value-based relationship between the “parent” Table and the “child” Table.
- Content -- the data-based properties that inform the policy-based content that is to be represented by an instance.
For the Operational Data Model, the DBMS Column required classes are Uniqueness, Audit, Relationship and Content.
The process to create DBMS Columns includes: