Objects in a PDM
|Previous Index Next How To Use|
The following items are available in a PDM:
See also: Objects in any Diagram.
Domains make it easier to identify the types of information in your model, assigning domains to columns help you standardize data characteristics for columns in different tables. This is the same as Domains in a CDM.
Just like a "column" of an Table, each Domain has a datatype. In addition to that, each domain can have a check constraint to create subsets of the available values for a datatype and can have a specified maximum length or precision and a scale. This makes the possible values in a "domain" a sub-set of the available values for a given datatype. Domains can be used as the "datatype" of a column instead of a raw datatype.
Domains are not visible in the diagram itself, but are visible in the Diagram Explorer.
A table is the structure that's used to physically store your data into "rows" of "records" of data. A single combined piece of information on each row. Each row should be uniquely identifiable by using the values in the primary key columns.
In the ideal case, your stored data should not contain NULLs (as this is missing information) but should only contain valid data instead.
Tables and Views can be used as the basis for Views and SQL SELECT statements to return data.
See also: Creating a Table
A view is like a virtual table. A SQL statement defines the view and it's resultset columns, it does not store the data, but offers a resultset that can be used in other views and SQL statements just like a table.
By using views, you can keep your applications SQL statement much more simple, hide data from tables or hide columns from tables before making them available to application developers.
See also: Creating a View
A "referential link", "foreign key constraint" or "referential constraint" are all the same thing. For a database systems that support them, it will create a foreign key constraint object in order to have the database system check that your referring table won't be referring to non-existing referred-to data.
For example, let's imagine the following:
A master-detail relationship between a person and his or her children, no constraints
You can create two constraints ensuring that table IS_CHILD_OF contains data that exists in table PERSON.
Two referential constraints
In a diagram, this could look like this:
The graphical version of the above foreign key constraints
See also: Creating a Foreign Key Constraint
Next: Datatypes in a PDM