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. |