ExtSchemaDefTable (ver7.7.0)
Defines a table in a schema extension.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ChildName | 7.7.0 | Varchar2(30) | Name of child or standalone table, used as a reference in program code. Not used for table extensions, only for child or standalone. |
CommentValue | 7.7.0 | Varchar2(256) | Descriptive comment for table. |
CoreTable | 7.7.0 | Varchar2(30) | Name of table being extended. |
CoreTablePK | 7.7.0 | Varchar2(30) | Name of primary key column in the DBTableName that this table foreign keys to |
DBTableName | 7.7.0 | Varchar2(30) | Unique database table name that will actualize this table extension, child table, or standalone table. Required. Indexed. |
ExtSchemaDef_ID | 7.7.0 | Number(10) | Internal number for the associated ExtSchemaDef record. Required. |
ForeignKey | 7.7.0 | Varchar2(30) | Name of the extension table column used as a foreign key to the core table. |
ID | 7.7.0 | Number(10) | Sequential number generated by the application, uniqueness in the table is guaranteed. Required. Indexed. |
Type | 7.7.0 | Char(1) | Type of extension table. Valid values: E = Table Extension, C = Child Table, S = Standalone Table. Required. |
VirtualTableName | 10.1.0 | Varchar2(30) | For migrated legacy virtual table contains the table_name of virtual table from Virtualtablesdef. Indexed. |
WhenCreated | 7.7.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 7.7.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 7.7.0 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 7.7.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. |