Category: Schema
Database: DBC
| View Column | Data Type | Format | Comment |
|---|---|---|---|
| DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | PeriodsVX.DatabaseName is the name of the database in which the table having period column. |
| Table_Name | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | PeriodsVX.Table_Name is the name of the table in which period column exists. |
| Period_Name | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | PeriodsVX.Period_Name is the name of a period column in a table. |
| Fid | SMALLINT NOT NULL | ---,--9 | PeriodsVX.Fid is the field id of a period column in a table. |
| Tid | BYTE(6) NOT NULL | X(12) | PeriodsVX.Tid is the table id of the table in which period column exists. |
| DBid | BYTE(4) NOT NULL | X(8) | PeriodsVX.DBid is the database id of the database in which the table is having period column. |
| START_COLUMN_NAME | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | PeriodsVX.START_COLUMN_NAME is the name of the begin column of a derived period, otherwise returns null. |
| END_COLUMN_NAME | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | PeriodsVX.END_COLUMN_NAME is the name of the end column of a derived period, otherwise returns null. |