Table Report Help
The Table Report is a fully attributed HTML document providing table and column information.
In the sample Table Report, we see all the associated attributes for a given table.
- Table Name
- The table name is at the upper left. It is followed by navigation links to the parts of that table.
- Table-level Detail
- Description and Definition: Documented descriptions of the table.
- Table Type: Table classification of ACTIVITY (transactional data) or REFERENCE (DB Build table).
- Column Detail Section
- Column Name: The columns that appear on the table.
- Type: The DBMS data type for the column.
- Null: Displays whether or not a column allows a null value.
- Definition: The documented definition of the column.
- Relationship Detail
- Parent section: If there are parents to this table as defined by a DBMS constraint, this list contains all the parent tables, the column name in those parent tables, and the name of the related column in this table.
- Child section: If there are children to this table as defined by a DBMS constraint, this contains all the child tables and the related foreign key column name in those child tables.