epras 表结构
| aggregate_cate_item | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
AGGREGATE_ITEM_CODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
GROUP_ITEM_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
GROUP_ITEM_NAME |
varchar(40) |
YES |
|
|
|
select,insert,update,references |
|
CAL_UNIT |
varchar(20) |
YES |
|
|
|
select,insert,update,references |
|
ROW_NO |
int(11) |
YES |
|
0 |
|
select,insert,update,references |
|
ROW_CODE |
varchar(10) |
YES |
|
|
|
select,insert,update,references |
|
C_LEVEL |
char(1) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
aggregate_cate_item |
0 |
PRIMARY |
1 |
AGGREGATE_ITEM_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
aggregate_cate_item |
0 |
PRIMARY |
2 |
GROUP_ITEM_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| aggregate_item_table | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
ITEM_CODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
AGGREGATE_ITEM_CODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
ITEM_NAME |
varchar(50) |
YES |
|
|
|
select,insert,update,references |
|
IND_CODE |
varchar(20) |
YES |
|
|
|
select,insert,update,references |
|
COL_NO |
smallint(6) |
|
|
0 |
|
select,insert,update,references |
|
COL_CODE |
varchar(10) |
YES |
|
|
|
select,insert,update,references |
|
ITEM_DATA_TYPE |
char(1) |
YES |
|
|
|
select,insert,update,references |
|
ITEM_LENGTH |
smallint(6) |
|
|
0 |
|
select,insert,update,references |
|
ITEM_SCALE |
smallint(6) |
|
|
0 |
|
select,insert,update,references |
|
CAL_UNIT |
varchar(20) |
YES |
|
|
|
select,insert,update,references |
|
C_LEVEL |
char(1) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
aggregate_item_table |
0 |
PRIMARY |
1 |
ITEM_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
aggregate_item_table |
0 |
PRIMARY |
2 |
AGGREGATE_ITEM_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| audit_err_list | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
UUID |
varchar(32) |
|
PRI |
|
|
select,insert,update,references |
|
FORMULA_CODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
ERROR_NO |
int(11) |
|
PRI |
0 |
|
select,insert,update,references |
|
CYC_CODE |
char(1) |
|
PRI |
|
|
select,insert,update,references |
|
AUDIT_LEVEL |
char(1) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
VERIFY_TEXT |
varchar(255) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ERROR_MSG |
blob |
YES |
|
(NULL) |
|
select,insert,update,references |
|
VAR_VALUE |
varchar(20) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
AEL_ITEMS |
blob |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TBL_CODE |
varchar(10) |
YES |
|
|
|
select,insert,update,references |
|
AEL_STATUS |
char(1) |
YES |
|
N |
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
audit_err_list |
0 |
PRIMARY |
1 |
UUID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
audit_err_list |
0 |
PRIMARY |
2 |
FORMULA_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
audit_err_list |
0 |
PRIMARY |
3 |
ERROR_NO |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
audit_err_list |
0 |
PRIMARY |
4 |
CYC_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| auditask_status | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
FORMULA_CODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
EXECUTE_TYPE |
char(1) |
YES |
|
|
|
select,insert,update,references |
|
AUDIT_IMP_TIMESTAMP |
bigint(20) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
USER_ID |
varchar(16) |
YES |
|
|
|
select,insert,update,references |
|
PARM_RANGE |
varchar(255) |
YES |
|
|
|
select,insert,update,references |
|
EXECUTE_FLAG |
varchar(10) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
auditask_status |
0 |
PRIMARY |
1 |
FORMULA_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| base_table | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
TBL_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
TBL_NAME |
varchar(100) |
YES |
|
|
|
select,insert,update,references |
|
BASE_INFO_FLAG |
char(1) |
|
|
|
|
select,insert,update,references |
|
ORGN_TYPE_CODE |
char(1) |
|
|
|
|
select,insert,update,references |
|
DEFAULT_INPUT_MODE |
char(1) |
|
|
0 |
|
select,insert,update,references |
|
C_LEVEL |
char(1) |
|
|
|
|
select,insert,update,references |
|
status |
char(1) |
|
|
0 |
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
base_table |
0 |
PRIMARY |
1 |
TBL_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| cate_item_level_table | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
CATE_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
CATE_ITEM_CODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
CATE_ITEM_LEVEL_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
CATE_ITEM_LEVEL_NAME |
varchar(40) |
YES |
|
|
|
select,insert,update,references |
|
CATE_ITEM_LEVEL_NO |
smallint(6) |
|
|
0 |
|
select,insert,update,references |
|
CATE_ITEM_LEVEL_LENGTH |
smallint(6) |
YES |
|
0 |
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
cate_item_level_table |
0 |
PRIMARY |
1 |
CATE_CODE |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
|
cate_item_level_table |
0 |
PRIMARY |
2 |
CATE_ITEM_CODE |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
|
cate_item_level_table |
0 |
PRIMARY |
3 |
CATE_ITEM_LEVEL_CODE |
A |
6 |
(NULL) |
(NULL) |
|
BTREE |
|
| cate_item_table | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
CATE_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
CATE_ITEM_CODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
CATE_ITEM_NAME |
varchar(50) |
|
|
|
|
select,insert,update,references |
|
CATE_ITEM_LEVEL_NUM |
smallint(6) |
|
|
0 |
|
select,insert,update,references |
|
ITEM_ENCODE_TYPE |
char(1) |
|
|
|
|
select,insert,update,references |
|
CATE_ITEM_TYPE |
char(1) |
|
|
|
|
select,insert,update,references |
|
VAR_SIZE |
char(1) |
|
|
|
|
select,insert,update,references |
|
CATE_ITEM_LENGTH |
varchar(30) |
|
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
cate_item_table |
0 |
PRIMARY |
1 |
CATE_CODE |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
|
cate_item_table |
0 |
PRIMARY |
2 |
CATE_ITEM_CODE |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
| category | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
CATE_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
CATE_NAME |
varchar(50) |
YES |
|
|
|
select,insert,update,references |
|
CATE_DESC |
varchar(255) |
YES |
|
|
|
select,insert,update,references |
|
CATE_TYPE |
char(1) |
YES |
|
|
|
select,insert,update,references |
|
CATE_LEVEL |
char(1) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
category |
0 |
PRIMARY |
1 |
CATE_CODE |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
| formula | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
FORMULA_CODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
FORMULA_NAME |
varchar(60) |
YES |
|
|
|
select,insert,update,references |
|
FORMULA_TYPE |
char(1) |
YES |
|
|
|
select,insert,update,references |
|
FORMULA_DATA |
mediumblob |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TBL_CODE |
varchar(10) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
formula |
0 |
PRIMARY |
1 |
FORMULA_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| group_base_table | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
GROUP_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
TBL_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
TABLE_SEQ |
smallint(6) |
|
|
0 |
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
group_base_table |
0 |
PRIMARY |
1 |
GROUP_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
group_base_table |
0 |
PRIMARY |
2 |
TBL_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| group_cate_entry | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
GROUP_ITEM_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
CATE_CODE |
varchar(10) |
|
|
|
|
select,insert,update,references |
|
GROUP_ITEM_NAME |
varchar(60) |
YES |
|
|
|
select,insert,update,references |
|
CAL_UNIT |
varchar(20) |
YES |
|
|
|
select,insert,update,references |
|
C_LEVEL |
char(1) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
group_cate_entry |
0 |
PRIMARY |
1 |
GROUP_ITEM_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| group_table | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
GROUP_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
GROUP_NAME |
varchar(50) |
|
|
|
|
select,insert,update,references |
|
GROUP_DESC |
varchar(255) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
group_table |
0 |
PRIMARY |
1 |
GROUP_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| indicator | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
IND_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
IND_GROUP_CODE |
varchar(10) |
YES |
|
|
|
select,insert,update,references |
|
IND_NAME |
varchar(50) |
|
|
|
|
select,insert,update,references |
|
IND_DESC |
varchar(255) |
YES |
|
|
|
select,insert,update,references |
|
IND_TYPE |
char(1) |
|
|
|
|
select,insert,update,references |
|
IND_SCALE |
smallint(6) |
|
|
0 |
|
select,insert,update,references |
|
IND_DATA_LENGTH |
smallint(6) |
|
|
0 |
|
select,insert,update,references |
|
CAL_UNIT |
varchar(10) |
YES |
|
|
|
select,insert,update,references |
|
C_LEVEL |
char(1) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
indicator |
0 |
PRIMARY |
1 |
IND_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| indicator_set | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
IND_GROUP_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
IND_GROUP_NAME |
varchar(60) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
indicator_set |
0 |
PRIMARY |
1 |
IND_GROUP_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| input_stat | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
UUID |
varchar(32) |
|
PRI |
|
|
select,insert,update,references |
|
TBL_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
CYC_CODE |
char(1) |
|
PRI |
|
|
select,insert,update,references |
|
USER_ID |
varchar(16) |
|
|
|
|
select,insert,update,references |
|
STAT_UNIT_CODE |
varchar(20) |
|
|
|
|
select,insert,update,references |
|
inputtime |
datetime |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
status |
char(1) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
input_stat |
0 |
PRIMARY |
1 |
UUID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
input_stat |
0 |
PRIMARY |
2 |
TBL_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
input_stat |
0 |
PRIMARY |
3 |
CYC_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| main_table | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
UUID |
varchar(32) |
|
PRI |
|
|
select,insert,update,references |
|
ORGN_CODE |
varchar(20) |
|
MUL |
|
|
select,insert,update,references |
|
ORGN_NAME |
varchar(60) |
|
|
|
|
select,insert,update,references |
|
ORGN_NUMBER |
varchar(40) |
|
|
|
|
select,insert,update,references |
|
SPEC_CODE |
varchar(5) |
YES |
MUL |
|
|
select,insert,update,references |
|
ORGN_TYPE_CODE |
char(1) |
|
|
|
|
select,insert,update,references |
|
PAR_ORGN_CODE |
varchar(32) |
YES |
MUL |
|
|
select,insert,update,references |
|
STAT_UNIT_CODE |
varchar(20) |
YES |
MUL |
|
|
select,insert,update,references |
|
UUID_TIMESTAMP |
bigint(20) |
|
|
0 |
|
select,insert,update,references |
|
STATUS |
char(1) |
YES |
|
0 |
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
main_table |
0 |
PRIMARY |
1 |
UUID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
main_table |
1 |
main_table_1 |
1 |
ORGN_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
main_table |
1 |
main_table_2 |
1 |
SPEC_CODE |
A |
0 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
main_table |
1 |
main_table_3 |
1 |
STAT_UNIT_CODE |
A |
0 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
main_table |
1 |
main_table_4 |
1 |
PAR_ORGN_CODE |
A |
0 |
(NULL) |
(NULL) |
YES |
BTREE |
|
| obj_tbl | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
OBJTYPECODE |
char(1) |
|
PRI |
|
|
select,insert,update,references |
|
OBJTYPENAME |
varchar(20) |
|
|
|
|
select,insert,update,references |
|
TBLNAME |
varchar(60) |
YES |
|
|
|
select,insert,update,references |
|
FIELDNAME |
varchar(20) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
obj_tbl |
0 |
PRIMARY |
1 |
OBJTYPECODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| orgn_type | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
ORGN_TYPE_CODE |
char(1) |
|
PRI |
|
|
select,insert,update,references |
|
ORGN_TYPE_NAME |
varchar(50) |
|
|
|
|
select,insert,update,references |
|
ORGN_CODE |
varchar(20) |
|
|
|
|
select,insert,update,references |
|
PAR_ORGN_TYPE_CODE |
char(1) |
YES |
|
|
|
select,insert,update,references |
|
ORGN_CODE_LENGTH |
smallint(6) |
|
|
0 |
|
select,insert,update,references |
|
ORGN_NAME |
varchar(60) |
|
|
|
|
select,insert,update,references |
|
ORGN_NAME_LENGTH |
smallint(6) |
|
|
0 |
|
select,insert,update,references |
|
FIELD_STRUCTURE |
varchar(30) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
orgn_type |
0 |
PRIMARY |
1 |
ORGN_TYPE_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| proj_cyc | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
PROJ_CYC_CODE |
char(1) |
|
PRI |
|
|
select,insert,update,references |
|
PROJ_CYC_NAME |
varchar(10) |
|
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
proj_cyc |
0 |
PRIMARY |
1 |
PROJ_CYC_CODE |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
| projargv | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
PARMCODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
PARMNAME |
varchar(50) |
|
|
|
|
select,insert,update,references |
|
PARMVALUE |
varchar(60) |
|
|
|
|
select,insert,update,references |
|
PARMDESC |
varchar(255) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
projargv |
0 |
PRIMARY |
1 |
PARMCODE |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
| query_info | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
queryID |
varchar(32) |
|
PRI |
|
|
select,insert,update,references |
|
queryName |
varchar(255) |
YES |
|
|
|
select,insert,update,references |
|
queryTarget |
varchar(20) |
|
|
|
|
select,insert,update,references |
|
pageDataCount |
int(11) |
|
|
0 |
|
select,insert,update,references |
|
currentPage |
int(11) |
|
|
0 |
|
select,insert,update,references |
|
saveDate |
varchar(20) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
query_info |
0 |
PRIMARY |
1 |
queryID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| query_info_detail | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
id |
varchar(32) |
|
PRI |
|
|
select,insert,update,references |
|
queryID |
varchar(32) |
|
|
|
|
select,insert,update,references |
|
plname |
varchar(200) |
|
|
|
|
select,insert,update,references |
|
rownumber |
int(11) |
|
|
0 |
|
select,insert,update,references |
|
dataname |
varchar(255) |
YES |
|
|
|
select,insert,update,references |
|
datavalue |
varchar(255) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
query_info_detail |
0 |
PRIMARY |
1 |
id |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| reinput_err_item_detail | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
UUID |
varchar(32) |
|
PRI |
|
|
select,insert,update,references |
|
CYC_CODE |
char(1) |
|
PRI |
|
|
select,insert,update,references |
|
TBL_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
AGGREGATE_ITEM_CODE |
varchar(20) |
|
PRI |
0 |
|
select,insert,update,references |
|
ITEM_CODE |
varchar(20) |
|
PRI |
0 |
|
select,insert,update,references |
|
CATE_ITEM_CODE |
varchar(20) |
|
PRI |
0 |
|
select,insert,update,references |
|
INPUT_VALUE |
varchar(255) |
YES |
|
|
|
select,insert,update,references |
|
RE_INPUT_VALUE |
varchar(255) |
YES |
|
|
|
select,insert,update,references |
|
MODIFY_STATUS |
char(1) |
YES |
|
0 |
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
reinput_err_item_detail |
0 |
PRIMARY |
1 |
UUID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
reinput_err_item_detail |
0 |
PRIMARY |
2 |
CYC_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
reinput_err_item_detail |
0 |
PRIMARY |
3 |
TBL_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
reinput_err_item_detail |
0 |
PRIMARY |
4 |
AGGREGATE_ITEM_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
reinput_err_item_detail |
0 |
PRIMARY |
5 |
ITEM_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
reinput_err_item_detail |
0 |
PRIMARY |
6 |
CATE_ITEM_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| reinput_tbl_info | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
UUID |
varchar(32) |
|
PRI |
|
|
select,insert,update,references |
|
TBL_CODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
CYC_CODE |
char(1) |
|
PRI |
|
|
select,insert,update,references |
|
REINPUT_COMPARE_NO |
varchar(20) |
|
|
0 |
|
select,insert,update,references |
|
ITEM_NUM |
smallint(6) |
|
|
0 |
|
select,insert,update,references |
|
ERR_ITEM_NUM |
smallint(6) |
|
|
0 |
|
select,insert,update,references |
|
USER_ID |
varchar(16) |
|
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
reinput_tbl_info |
0 |
PRIMARY |
1 |
UUID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
reinput_tbl_info |
0 |
PRIMARY |
2 |
TBL_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
reinput_tbl_info |
0 |
PRIMARY |
3 |
CYC_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| repeat_orgn | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
REPEAT_NO |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
UUID |
varchar(32) |
|
PRI |
|
|
select,insert,update,references |
|
REPEAT_FLAG |
char(1) |
|
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
repeat_orgn |
0 |
PRIMARY |
1 |
REPEAT_NO |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
repeat_orgn |
0 |
PRIMARY |
2 |
UUID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| spec_user_table | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
USER_ID |
varchar(16) |
|
PRI |
|
|
select,insert,update,references |
|
SPEC_CODE |
varchar(5) |
|
PRI |
|
|
select,insert,update,references |
|
ALL_SPEC_MANAGER |
char(1) |
|
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
spec_user_table |
0 |
PRIMARY |
1 |
USER_ID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
spec_user_table |
0 |
PRIMARY |
2 |
SPEC_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| specialty | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
SPEC_CODE |
varchar(5) |
|
PRI |
|
|
select,insert,update,references |
|
SPECIALTY |
varchar(50) |
YES |
|
|
|
select,insert,update,references |
|
SPECIALTY_DESC |
varchar(255) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
specialty |
0 |
PRIMARY |
1 |
SPEC_CODE |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
| speciaty_table | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
SPEC_CODE |
varchar(5) |
|
PRI |
|
|
select,insert,update,references |
|
TBL_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
TBL_TYPE |
char(1) |
|
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
speciaty_table |
0 |
PRIMARY |
1 |
SPEC_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
speciaty_table |
0 |
PRIMARY |
2 |
TBL_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| stat_unit | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
STAT_UNIT_CODE |
varchar(12) |
|
PRI |
|
|
select,insert,update,references |
|
STAT_UNIT_NAME |
varchar(40) |
|
|
|
|
select,insert,update,references |
|
STAT_UNIT_DESC |
varchar(255) |
|
|
|
|
select,insert,update,references |
|
ITEM_LEVEL |
smallint(6) |
|
|
1 |
|
select,insert,update,references |
|
PAR_STAT_UNIT_CODE |
varchar(12) |
YES |
|
|
|
select,insert,update,references |
|
INPUT_FLAG |
char(1) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
stat_unit |
0 |
PRIMARY |
1 |
STAT_UNIT_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| sum_audit_err_list | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
STAT_UNIT_CODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
FORMULA_CODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
ERROR_NO |
int(11) |
|
PRI |
0 |
|
select,insert,update,references |
|
CYC_CODE |
char(1) |
|
PRI |
|
|
select,insert,update,references |
|
AUDIT_LEVEL |
char(1) |
YES |
|
|
|
select,insert,update,references |
|
VERIFY_TEXT |
varchar(255) |
YES |
|
|
|
select,insert,update,references |
|
ERROR_MSG |
blob |
YES |
|
(NULL) |
|
select,insert,update,references |
|
VAR_VALUE |
varchar(20) |
YES |
|
|
|
select,insert,update,references |
|
AEL_ITEMS |
blob |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TBL_CODE |
varchar(10) |
YES |
|
|
|
select,insert,update,references |
|
AEL_STATUS |
char(1) |
YES |
|
N |
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
sum_audit_err_list |
0 |
PRIMARY |
1 |
STAT_UNIT_CODE |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
sum_audit_err_list |
0 |
PRIMARY |
2 |
FORMULA_CODE |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
sum_audit_err_list |
0 |
PRIMARY |
3 |
ERROR_NO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
sum_audit_err_list |
0 |
PRIMARY |
4 |
CYC_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| sum_base_tbl | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
SUM_TBL_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
BASE_TBL_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
sum_base_tbl |
0 |
PRIMARY |
1 |
SUM_TBL_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
sum_base_tbl |
0 |
PRIMARY |
2 |
BASE_TBL_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| sum_data_info | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
TBL_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
CYC_CODE |
char(1) |
|
PRI |
|
|
select,insert,update,references |
|
STAT_UNIT_CODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
USER_ID |
varchar(16) |
|
|
|
|
select,insert,update,references |
|
DOSUM_DATE |
datetime |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
sum_data_info |
0 |
PRIMARY |
1 |
TBL_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
sum_data_info |
0 |
PRIMARY |
2 |
CYC_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
sum_data_info |
0 |
PRIMARY |
3 |
STAT_UNIT_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| sum_table | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
TBL_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
TBL_NAME |
varchar(100) |
YES |
|
|
|
select,insert,update,references |
|
SUM_TABLE_TYPE |
char(1) |
|
|
|
|
select,insert,update,references |
|
ROW_SIZE |
smallint(6) |
|
|
0 |
|
select,insert,update,references |
|
COL_SIZE |
smallint(6) |
|
|
0 |
|
select,insert,update,references |
|
FORMULA_CODE |
varchar(20) |
|
|
|
|
select,insert,update,references |
|
DB_FLAG |
char(1) |
|
|
0 |
|
select,insert,update,references |
|
DATA_TYPE |
char(1) |
|
|
n |
|
select,insert,update,references |
|
DATA_LENGTH |
smallint(6) |
|
|
9 |
|
select,insert,update,references |
|
DATA_SCALE |
smallint(6) |
|
|
2 |
|
select,insert,update,references |
|
C_LEVEL |
char(1) |
|
|
|
|
select,insert,update,references |
|
status |
char(1) |
|
|
0 |
|
select,insert,update,references |
|
CATE_CODE |
varchar(40) |
|
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
sum_table |
0 |
PRIMARY |
1 |
TBL_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| sum_tbl_item | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
TBL_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
ROW_NO |
smallint(6) |
|
PRI |
0 |
|
select,insert,update,references |
|
COL_NO |
smallint(6) |
|
PRI |
0 |
|
select,insert,update,references |
|
BASE_ITEM_COORDINATE |
varchar(100) |
YES |
|
|
|
select,insert,update,references |
|
ITEM_LENGTH |
smallint(6) |
YES |
|
0 |
|
select,insert,update,references |
|
ITEM_DATA_TYPE |
char(1) |
YES |
|
|
|
select,insert,update,references |
|
ITEM_SCALE |
smallint(6) |
YES |
|
0 |
|
select,insert,update,references |
|
FORMULA_TEXT |
blob |
YES |
|
(NULL) |
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
sum_tbl_item |
0 |
PRIMARY |
1 |
TBL_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
sum_tbl_item |
0 |
PRIMARY |
2 |
ROW_NO |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
sum_tbl_item |
0 |
PRIMARY |
3 |
COL_NO |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| tbl_formula | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
FORMULA_CODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
TBL_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
FORMULA_TYPE |
char(1) |
|
|
|
|
select,insert,update,references |
|
RELATION |
smallint(6) |
|
|
1 |
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
tbl_formula |
0 |
PRIMARY |
1 |
FORMULA_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
tbl_formula |
0 |
PRIMARY |
2 |
TBL_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| tbl_item | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
ITEM_CODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
TBL_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
ITEM_NAME |
varchar(50) |
YES |
|
|
|
select,insert,update,references |
|
ITEM_TYPE |
char(1) |
|
|
|
|
select,insert,update,references |
|
IND_CODE |
varchar(10) |
YES |
|
|
|
select,insert,update,references |
|
COORDINATE |
smallint(6) |
|
|
0 |
|
select,insert,update,references |
|
ITEM_DATA_TYPE |
char(1) |
YES |
|
|
|
select,insert,update,references |
|
ITEM_LENGTH |
smallint(6) |
YES |
|
0 |
|
select,insert,update,references |
|
ITEM_SCALE |
smallint(6) |
YES |
|
0 |
|
select,insert,update,references |
|
CAL_UNIT |
varchar(20) |
YES |
|
|
|
select,insert,update,references |
|
C_LEVEL |
char(1) |
YES |
|
|
|
select,insert,update,references |
|
CATE_CODE |
varchar(10) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
tbl_item |
0 |
PRIMARY |
1 |
ITEM_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
tbl_item |
0 |
PRIMARY |
2 |
TBL_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| tbl_style | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
TBL_CODE |
varchar(10) |
|
PRI |
|
|
select,insert,update,references |
|
STYLE_TYPE |
char(1) |
|
PRI |
|
|
select,insert,update,references |
|
STYLE_DATA |
mediumblob |
YES |
|
(NULL) |
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
tbl_style |
0 |
PRIMARY |
1 |
TBL_CODE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
tbl_style |
0 |
PRIMARY |
2 |
STYLE_TYPE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| tree | |
| Fields |
| Field | Type | Null | Key | Default | Extra | Privileges |
|
NODECODE |
varchar(20) |
|
PRI |
|
|
select,insert,update,references |
|
OBJCODE |
varchar(20) |
|
|
|
|
select,insert,update,references |
|
OBJNAME |
varchar(255) |
|
|
|
|
select,insert,update,references |
|
OBJTYPECODE |
char(1) |
|
|
|
|
select,insert,update,references |
|
PARENTSNODE |
varchar(20) |
YES |
|
|
|
select,insert,update,references |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
|
tree |
0 |
PRIMARY |
1 |
NODECODE |
A |
6 |
(NULL) |
(NULL) |
|
BTREE |
|
浙公网安备 33010602011771号