The db_object table contains metadata of the db_object table. See column dbrep_objecttype for the types of objects supported.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| dbrep_iid | integer | not null | The unique ID of the object. |
| dbrep_parentiid | integer | not null | The parent ID of the object. |
| dbrep_name | varchar(255) | not null | The name of the object. |
| dbrep_status | smallint | not null | The status of the object. <DEV>, <TEST>, <PROD> |
| dbrep_version | integer | not null | The version of the object. |
| dbrep_objecttype | integer1 | not null | The object type of the object: SERVER_TYPE 1 DATATYPE 2 SERVER 3 SCHEMA 4 DATABASE 5 TABLE 6 COLUMN 7 INDEX 8 OPERATION 9 PARAM 10 OP_GROUP 11 APPLICATION 12 PROGRAM 13 STARSCHEMA 14 GATOR 15 WORKFLOW 16 PROGRAMINSTANCE 17 PROGRAMTYPE 18 WORKFLOWCONNECTION 19 PSAFILE 20 PROGRAMTYPEMISC 21 XML 22 XML_ELEMENT 23 XML_ATTRIBUTE 24 LAYOUT 25 FIELD 26 |
| dbrep_description | varchar(255) | with null | The description of the object. |
Product Name: Data Transformer
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| dbrep_iid | db_layout | dbrep_iid |
| dbrep_iid | db_infoblob | dbrep_iid |
| dbrep_iid | db_index | dbrep_iid |
| dbrep_iid | db_gator | dbrep_iid |
| dbrep_iid | db_field | dbrep_iid |
| dbrep_iid | db_datatype | dbrep_iid |
| dbrep_iid | db_column | dbrep_iid |
| dbrep_iid | db_application | dbrep_iid |
| dbrep_iid | db_star | dbrep_iid |
| dbrep_iid | db_servertype | dbrep_iid |
| dbrep_iid | db_psafile | dbrep_iid |
| dbrep_iid | db_programtypemisc | dbrep_iid |
| dbrep_iid | db_programtype | dbrep_iid |
| dbrep_iid | db_programinstance | dbrep_iid |
| dbrep_iid | db_program | dbrep_iid |
| dbrep_iid | db_parameter | dbrep_iid |
| dbrep_iid | db_op | dbrep_iid |
| dbrep_iid | db_object | dbrep_parentiid |
| dbrep_iid | db_wkfconnection | dbrep_iid |
| dbrep_iid | db_wkf | dbrep_iid |
| dbrep_iid | db_table | dbrep_iid |