DCFTable (ver9.1.0)
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
AUIndexFK | 9.1.0 | Varchar2(30) | Generated name of the FK index on the audit table. |
AUIndexPK | 9.1.0 | Varchar2(30) | Generated name of the PK index on the audit table. |
AUSequence | 9.1.0 | Varchar2(30) | Generated name of the sequence used for the audit table. |
AUTable | 9.1.0 | Varchar2(30) | Generated name of the audit table for this core table. |
CoreTable | 9.1.0 | Varchar2(30) | Core table being audited/logged. Required. Indexed. Unique. |
DeleteTrigger | 9.1.0 | Varchar2(30) | Generated name of delete trigger on the core table. This field will be populated with a name even when no delete trigger is actually created. This occurs when only a Last Modified Audit is included in a subscription. |
DQIndexColumn | 10.0.0 | Varchar2(30) | When a data version subscription is defined against a table, this column stores the index name of the primary key column of the subscribed table. |
DQPKColumn | 10.0.0 | Varchar2(30) | When a data version subscription is defined against a table, this column stores the primary key column that the DC$[TableName].ID column will refer to as a foreign key. |
DQTable | 10.0.0 | Varchar2(30) | When a data version subscription is defined against a table, this column stores the name of the DQ$[TableName] that is created. |
InsertTrigger | 9.1.0 | Varchar2(30) | Generated name of insert trigger on the core table. |
LGIndexPK | 9.1.0 | Varchar2(30) | Generated name of the PK index on the log table |
LGSequence | 9.1.0 | Varchar2(30) | Generated name of the sequence used for the log table. |
LGTable | 9.1.0 | Varchar2(30) | Generated name of the log table for this core table. |
DCFTableID | 9.1.0 | Number(19) | Unique sequential number generated by the application. Required. Indexed. |
UpdateTrigger | 9.1.0 | Varchar2(30) | Generated name of update trigger on the core table. |
WhenCreated | 9.1.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 9.1.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 9.1.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 9.1.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |