|
字段名 |
中文名称 |
数据类型 |
长度 |
精度 |
是否主键 |
是否外键 |
是否非空 |
|
PK_OBJ |
PK_OBJ |
char(20) |
20 |
|
是 |
|
是 |
|
PK_CUBE |
PK_CUBE |
char(20) |
20 |
|
|
|
是 |
|
PK_ENTITY |
PK_ENTITY |
char(20) |
20 |
|
|
|
|
|
CODE_ENTITY |
CODE_ENTITY |
varchar(50) |
50 |
|
|
|
|
|
NAME_ENTITY |
NAME_ENTITY |
varchar(100) |
100 |
|
|
|
|
|
IDX_ENTITY |
IDX_ENTITY |
smallint |
|
|
|
|
|
|
CODE_DATAATTR |
CODE_DATAATTR |
varchar(50) |
50 |
|
|
|
|
|
NAME_DATAATTR |
NAME_DATAATTR |
varchar(100) |
100 |
|
|
|
|
|
IDX_DATAATTR |
IDX_DATAATTR |
smallint |
|
|
|
|
|
|
PK_DATAATTR |
PK_DATAATTR |
char(20) |
20 |
|
|
|
|
|
PK_DAYDIM |
PK_DAYDIM |
char(20) |
20 |
|
|
|
|
|
CODE_DAYDIM |
CODE_DAYDIM |
varchar(50) |
50 |
|
|
|
|
|
NAME_DAYDIM |
NAME_DAYDIM |
varchar(100) |
100 |
|
|
|
|
|
IDX_DAYDIM |
IDX_DAYDIM |
smallint |
|
|
|
|
|
|
PK_OENTITY |
PK_OENTITY |
char(20) |
20 |
|
|
|
|
|
CODE_OENTITY |
CODE_OENTITY |
varchar(50) |
50 |
|
|
|
|
|
NAME_OENTITY |
NAME_OENTITY |
varchar(100) |
100 |
|
|
|
|
|
IDX_OENTITY |
IDX_OENTITY |
smallint |
|
|
|
|
|
|
PK_VERSION |
PK_VERSION |
char(20) |
20 |
|
|
|
|
|
CODE_VERSION |
CODE_VERSION |
varchar(50) |
50 |
|
|
|
|
|
NAME_VERSION |
NAME_VERSION |
varchar(100) |
100 |
|
|
|
|
|
IDX_VERSION |
IDX_VERSION |
smallint |
|
|
|
|
|
|
PK_INVESTDATA |
PK_INVESTDATA |
char(20) |
20 |
|
|
|
|
|
CODE_INVESTDATA |
CODE_INVESTDATA |
varchar(50) |
50 |
|
|
|
|
|
NAME_INVESTDATA |
NAME_INVESTDATA |
varchar(100) |
100 |
|
|
|
|
|
IDX_INVESTDATA |
IDX_INVESTDATA |
smallint |
|
|
|
|
|
|
PK_YEAR |
PK_YEAR |
char(20) |
20 |
|
|
|
|
|
CODE_YEAR |
CODE_YEAR |
varchar(50) |
50 |
|
|
|
|
|
NAME_YEAR |
NAME_YEAR |
varchar(100) |
100 |
|
|
|
|
|
IDX_YEAR |
IDX_YEAR |
smallint |
|
|
|
|
|
|
PK_MONTH |
PK_MONTH |
char(20) |
20 |
|
|
|
|
|
CODE_MONTH |
CODE_MONTH |
varchar(50) |
50 |
|
|
|
|
|
NAME_MONTH |
NAME_MONTH |
varchar(100) |
100 |
|
|
|
|
|
IDX_MONTH |
IDX_MONTH |
smallint |
|
|
|
|
|
|
VALUE |
VALUE |
numeric(30,8) |
30 |
8 |
|
|
|
|
TEXTVALUE |
TEXTVALUE |
varchar(250) |
250 |
|
|
|
|
|
ISCUBEDEF |
ISCUBEDEF |
char(1) |
1 |
|
|
|
是 |
|
DATASTATUS |
DATASTATUS |
smallint |
|
|
|
|
|
|
DATATYPE |
DATATYPE |
char(20) |
20 |
|
|
|
|
|
INPUTMODE |
INPUTMODE |
smallint |
|
|
|
|
|
|
CREATEDBY |
CREATEDBY |
varchar(50) |
50 |
|
|
|
|
|
CREATEDDATE |
CREATEDDATE |
char(19) |
19 |
|
|
|
|
|
MODIFIEDBY |
MODIFIEDBY |
varchar(50) |
50 |
|
|
|
|
|
MODIFIEDDATE |
MODIFIEDDATE |
char(19) |
19 |
|
|
|
|
|
PK_PLAN |
PK_PLAN |
char(20) |
20 |
|
|
|
|