Domains to a PDM
|Previous Index Next How To Use|
If the type of DBMS associated with your PDM supports "domains", the conversion of a conceptual Domain will be direct. That is, for each conceptual domain, a physical domain object will be created and re-used in one or more Tables.
If Domains are not supported by the DBMS, a table column will use the "raw datatype", optional "check constraint" and optional "not null" constraint will be used.
Below is an example of objects created.
Table SQL statement for the InterBase DBMS, which supports Domains
In the above example, the domain "SEX_TYPE" can be re-used by multiple table columns without having to repeat it's definition.
Table SQL statement for the MySQL DBMS, which does not support Domains or Check Constraints (but uses a special ENUM datatype)
In the above example, the SEX_TYPE domain definition is copied into each table column that uses this domain.
Next: Entities to a PDM