📄 database.erx
字号:
1,"IT_IF",31,15,"RT_NI","curriculum_id",28,"ET_IE",0,0,1
1,"IT_IF",9,7,"RT_NI","stu_num",28,"ET_IE",0,0,1
/*
CREATE TABLE DIAGRAM_OPTION
(OPTION_NAME CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
SUBJECT_ID INTEGER,
DISPLAY_ID INTEGER,
OPTION_VALUE VARCHAR(254)
);
*/
"DO_TD",0,0,0,"186"
"DO_DD",0,0,0,"CHAR(10)"
/*
CREATE TABLE TEXT_BLOCK
(TEXT_BLOCK_ID INTEGER NOT NULL,
TEXT_BLOCK_TYPE CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
RESERVED INTEGER NOT NULL,
TEXT_BLOCK_TEXT INTEGER
);
*/
/*
CREATE TABLE CS_VALIDATION_RULE
(CS_VAL_RULE_ID INTEGER NOT NULL,
CS_VAL_RULE_TYPE CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
RESERVED INTEGER NOT NULL,
CS_VAL_RULE_NAME CHAR(254) NOT NULL,
CLIENT_RULE INTEGER,
SERVER_RULE INTEGER,
CLIENT_TYPE INTEGER,
CLIENT_WARNING VARCHAR(254),
MINIMUM_VALUE VARCHAR(254),
MAXIMUM_VALUE VARCHAR(254),
SERVER_WARNING VARCHAR(254)
);
*/
/*
CREATE TABLE CS_VALID_VALUES
(CS_VAL_RULE_ID INTEGER NOT NULL,
CS_VAL_RULE_TYPE CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
RESERVED INTEGER NOT NULL,
CS_VALUE VARCHAR(254) NOT NULL
CS_VALUE_DEF INTEGER,
CS_VALUE_DISP VARCHAR(254),
CS_VALUE_SEQ INTEGER NOT NULL
);
*/
/*
CREATE TABLE TABLE_CONSTRAINT
(ENTITY_ID INTEGER NOT NULL,
ENTITY_TYPE CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
RESERVED INTEGER NOT NULL,
CS_VAL_RULE_ID INTEGER NOT NULL,
CS_VAL_RULE_TYPE CHAR(6) NOT NULL,
TARGET_SERVER CHAR(6) NOT NULL,
TARGET_CLIENT CHAR(6) NOT NULL
);
*/
/*
CREATE TABLE PHYSICAL_OBJECT
(PHYSICAL_OBJECT_ID INTEGER NOT NULL,
PHYSICAL_OBJECT_TYPE CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
RESERVED INTEGER NOT NULL,
TARGET_SYSTEM CHAR(6) NOT NULL,
PHYSICAL_OBJECT_NAME VARCHAR(254) NOT NULL,
);
*/
/*
CREATE TABLE PHYS_OBJ_PROP_VALUE
(PHYSICAL_OBJECT_ID INTEGER NOT NULL,
PHYSICAL_OBJECT_TYPE CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
RESERVED INTEGER NOT NULL,
PHYS_OBJ_PROP_ID CHAR(6) NOT NULL,
PHYS_OBJ_PROP_VALUE INTEGER,
PHYS_OBJ_PROP_IVAL INTEGER,
PHYS_OBJ_PROP_SVAL VARCHAR(254)
);
*/
/*
CREATE TABLE ENT_PHYSICAL_PV
(ENTITY_ID INTEGER NOT NULL,
ENTITY_TYPE CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
RESERVED INTEGER NOT NULL,
TARGET_SYSTEM CHAR(6) NOT NULL,
PHYS_PROP_ID CHAR(6) NOT NULL,
PHYS_PROP_VALUE INTEGER
);
*/
1,"ET_IE",0,0,"TD_UN","EP_TBN",949987768
3,"ET_IE",0,0,"TD_UN","EP_TBN",950023544
4,"ET_IE",0,0,"TD_UN","EP_TBN",950016312
6,"ET_IE",0,0,"TD_UN","EP_TBN",950048032
8,"ET_IE",0,0,"TD_UN","EP_TBN",949987688
12,"ET_IE",0,0,"TD_UN","EP_TBN",950007984
14,"ET_IE",0,0,"TD_UN","EP_TBN",890584560
16,"ET_IE",0,0,"TD_UN","EP_TBN",949987624
18,"ET_IE",0,0,"TD_UN","EP_TBN",890595624
20,"ET_IE",0,0,"TD_UN","EP_TBN",892107464
22,"ET_IE",0,0,"TD_UN","EP_TBN",890616512
24,"ET_IE",0,0,"TD_UN","EP_TBN",890359792
26,"ET_IE",0,0,"TD_UN","EP_TBN",833440008
28,"ET_IE",0,0,"TD_UN","EP_TBN",891938048
/*
CREATE TABLE IDX_MBR_PHYS_PV
(INDEX_ID INTEGER NOT NULL,
INDEX_TYPE CHAR(6) NOT NULL,
ATTRIBUTE_ID INTEGER NOT NULL,
RELATIONSHIP_ID INTEGER NOT NULL,
RELATIONSHIP_TYPE CHAR(6) NOT NULL,
EAU_BASENAME VARCHAR(254) NOT NULL,
ENTITY_ID INTEGER NOT NULL,
ENTITY_TYPE CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
RESERVED INTEGER NOT NULL,
TARGET_SYSTEM CHAR(6) NOT NULL,
INDEX_MBR_PVNAME VARCHAR(254) NOT NULL,
INDEX_MBR_PVVALUE INTEGER
);
*/
1,"IT_PK",1,-1,"RT_OA","id",1,"ET_IE",0,0,"TD_UN","DESC",0
1,"IT_PK",3,-1,"RT_OA","id",3,"ET_IE",0,0,"TD_UN","DESC",0
1,"IT_PK",6,-1,"RT_OA","id",4,"ET_IE",0,0,"TD_UN","DESC",0
1,"IT_PK",9,-1,"RT_OA","stu_num",6,"ET_IE",0,0,"TD_UN","DESC",0
1,"IT_PK",25,-1,"RT_OA","id",8,"ET_IE",0,0,"TD_UN","DESC",0
1,"IT_PK",29,-1,"RT_OA","id",12,"ET_IE",0,0,"TD_UN","DESC",0
1,"IT_PK",31,-1,"RT_OA","id",14,"ET_IE",0,0,"TD_UN","DESC",0
1,"IT_PK",38,-1,"RT_OA","id",16,"ET_IE",0,0,"TD_UN","DESC",0
1,"IT_PK",40,-1,"RT_OA","id",18,"ET_IE",0,0,"TD_UN","DESC",0
1,"IT_PK",43,-1,"RT_OA","id",20,"ET_IE",0,0,"TD_UN","DESC",0
1,"IT_PK",49,-1,"RT_OA","address",22,"ET_IE",0,0,"TD_UN","DESC",0
1,"IT_PK",51,-1,"RT_OA","id",24,"ET_IE",0,0,"TD_UN","DESC",0
1,"IT_PK",54,-1,"RT_OA","id",26,"ET_IE",0,0,"TD_UN","DESC",0
1,"IT_PK",56,-1,"RT_OA","id",28,"ET_IE",0,0,"TD_UN","DESC",0
/*
CREATE TABLE INDEX_PHYSICAL_PV
(INDEX_ID INTEGER NOT NULL,
INDEX_TYPE CHAR(6) NOT NULL,
ENTITY_ID INTEGER NOT NULL,
ENTITY_TYPE CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
RESERVED INTEGER NOT NULL,
TARGET_SYSTEM CHAR(6) NOT NULL,
INDEX_PV_ID CHAR(6),
INDEX_PV_PHYS_OBJ INTEGER,
INDEX_PV_VALUE INTEGER
);
*/
1,"IT_PK",1,"ET_IE",0,0,"TD_UN","IP_UNQ",-1,949988360
1,"IT_PK",1,"ET_IE",0,0,"TD_UN","IP_NAM",-1,949358712
1,"IT_PK",3,"ET_IE",0,0,"TD_UN","IP_UNQ",-1,949988360
1,"IT_PK",3,"ET_IE",0,0,"TD_UN","IP_NAM",-1,949347592
1,"IT_PK",4,"ET_IE",0,0,"TD_UN","IP_UNQ",-1,949988360
1,"IT_PK",4,"ET_IE",0,0,"TD_UN","IP_NAM",-1,949989640
1,"IT_PK",6,"ET_IE",0,0,"TD_UN","IP_UNQ",-1,949988360
1,"IT_PK",6,"ET_IE",0,0,"TD_UN","IP_NAM",-1,891888208
1,"IT_PK",8,"ET_IE",0,0,"TD_UN","IP_UNQ",-1,949988360
1,"IT_PK",8,"ET_IE",0,0,"TD_UN","IP_NAM",-1,891775008
1,"IT_PK",12,"ET_IE",0,0,"TD_UN","IP_UNQ",-1,949988360
1,"IT_PK",12,"ET_IE",0,0,"TD_UN","IP_NAM",-1,890337024
1,"IT_PK",14,"ET_IE",0,0,"TD_UN","IP_UNQ",-1,949988360
1,"IT_PK",14,"ET_IE",0,0,"TD_UN","IP_NAM",-1,949992904
1,"IT_PK",16,"ET_IE",0,0,"TD_UN","IP_UNQ",-1,949988360
1,"IT_PK",16,"ET_IE",0,0,"TD_UN","IP_NAM",-1,949986824
1,"IT_PK",18,"ET_IE",0,0,"TD_UN","IP_UNQ",-1,949988360
1,"IT_PK",18,"ET_IE",0,0,"TD_UN","IP_NAM",-1,949953664
1,"IT_PK",20,"ET_IE",0,0,"TD_UN","IP_UNQ",-1,949988360
1,"IT_PK",20,"ET_IE",0,0,"TD_UN","IP_NAM",-1,890656152
1,"IT_PK",22,"ET_IE",0,0,"TD_UN","IP_UNQ",-1,949988360
1,"IT_PK",22,"ET_IE",0,0,"TD_UN","IP_NAM",-1,949953752
1,"IT_PK",24,"ET_IE",0,0,"TD_UN","IP_UNQ",-1,949988360
1,"IT_PK",24,"ET_IE",0,0,"TD_UN","IP_NAM",-1,950029896
1,"IT_PK",26,"ET_IE",0,0,"TD_UN","IP_UNQ",-1,949988360
1,"IT_PK",26,"ET_IE",0,0,"TD_UN","IP_NAM",-1,950029224
1,"IT_PK",28,"ET_IE",0,0,"TD_UN","IP_UNQ",-1,949988360
1,"IT_PK",28,"ET_IE",0,0,"TD_UN","IP_NAM",-1,950029832
/*
CREATE TABLE ENTITY_TRIGGER
(ENTITY_ID INTEGER NOT NULL,
ENTITY_TYPE CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
RESERVED INTEGER NOT NULL,
TARGET_SYSTEM CHAR(6) NOT NULL,
TRIGGER_NAME VARCHAR(254) NOT NULL,
TRIGGER_TYPE CHAR(6),
TRIGGER_DISABLED INTEGER,
TRIGGER_FIRE CHAR(6),
TRIGGER_SCOPE CHAR(6),
TRIGGER_OLD VARCHAR(254),
TRIGGER_NEW VARCHAR(254),
TRIGGER_BODY INTEGER
);
*/
/*
CREATE TABLE ENTITY_TRIGGER_UPD
(ENTITY_ID INTEGER NOT NULL,
ENTITY_TYPE CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
RESERVED INTEGER NOT NULL,
TARGET_SYSTEM CHAR(6) NOT NULL,
TRIGGER_NAME VARCHAR(254) NOT NULL,
UPDCOLS_LOG_NAME VARCHAR(254) NOT NULL,
UPDCOLS_ORDER INTEGER,
UPDCOLS_PHYS_NAME VARCHAR(254)
);
*/
/*
CREATE TABLE DOMAIN
(CS_DOMAIN_ID INTEGER NOT NULL,
CS_DOMAIN_TYPE CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
RESERVED INTEGER NOT NULL,
CS_DOMAIN_NAME VARCHAR(254) NOT NULL,
PARENT_CS_DOMAIN_ID INTEGER,
CS_DOMAIN_DEFINITION INTEGER,
CS_DOMAIN_FLAGS INTEGER NOT NULL,
CS_DOMAIN_INTERNAL INTEGER NOT NULL
);
*/
1,"DOMAIN",0,0,"",0,0,0,4
2,"DOMAIN",0,0,"<default>",1,0,0,3
3,"DOMAIN",0,0,"",2,0,0,2
4,"DOMAIN",0,0,"",2,0,0,2
5,"DOMAIN",0,0,"",2,0,0,2
6,"DOMAIN",0,0,"",2,0,0,2
7,"DOMAIN",0,0,"",2,0,0,2
8,"DOMAIN",0,0,"",2,0,0,2
9,"DOMAIN",0,0,"",2,0,0,2
10,"DOMAIN",0,0,"",2,0,0,2
11,"DOMAIN",0,0,"",2,0,0,2
12,"DOMAIN",0,0,"",2,0,0,2
13,"DOMAIN",0,0,"",2,0,0,2
14,"DOMAIN",0,0,"",2,0,0,2
15,"DOMAIN",0,0,"",2,0,0,2
16,"DOMAIN",0,0,"",2,0,0,2
17,"DOMAIN",0,0,"",2,0,0,2
18,"DOMAIN",0,0,"",2,0,0,2
19,"DOMAIN",0,0,"",2,0,0,2
20,"DOMAIN",0,0,"",2,0,0,2
21,"DOMAIN",0,0,"",2,0,0,2
22,"DOMAIN",0,0,"",2,0,0,2
23,"DOMAIN",0,0,"",2,0,0,2
24,"DOMAIN",0,0,"",2,0,0,2
25,"DOMAIN",0,0,"",2,0,0,2
26,"DOMAIN",0,0,"",2,0,0,2
27,"DOMAIN",0,0,"",2,0,0,2
28,"DOMAIN",0,0,"",2,0,0,2
29,"DOMAIN",0,0,"",2,0,0,2
30,"DOMAIN",0,0,"",2,0,0,2
31,"DOMAIN",0,0,"",2,0,0,2
32,"DOMAIN",0,0,"",2,0,0,2
33,"DOMAIN",0,0,"",2,0,0,2
34,"DOMAIN",0,0,"",2,0,0,2
35,"DOMAIN",0,0,"",2,0,0,2
36,"DOMAIN",0,0,"",2,0,0,2
37,"DOMAIN",0,0,"",2,0,0,2
38,"DOMAIN",0,0,"",2,0,0,2
39,"DOMAIN",0,0,"",2,0,0,2
40,"DOMAIN",0,0,"",2,0,0,2
41,"DOMAIN",0,0,"",2,0,0,2
42,"DOMAIN",0,0,"",2,0,0,2
43,"DOMAIN",0,0,"",2,0,0,2
44,"DOMAIN",0,0,"",2,0,0,2
45,"DOMAIN",0,0,"",2,0,0,2
46,"DOMAIN",0,0,"",2,0,0,2
47,"DOMAIN",0,0,"",2,0,0,2
48,"DOMAIN",0,0,"",2,0,0,2
49,"DOMAIN",0,0,"",2,0,0,2
50,"DOMAIN",0,0,"",2,0,0,2
51,"DOMAIN",0,0,"",2,0,0,2
52,"DOMAIN",0,0,"",2,0,0,2
53,"DOMAIN",0,0,"",2,0,0,2
54,"DOMAIN",0,0,"",2,0,0,2
55,"DOMAIN",0,0,"",2,0,0,2
56,"DOMAIN",0,0,"",2,0,0,2
57,"DOMAIN",0,0,"",2,0,0,2
58,"DOMAIN",0,0,"",2,0,0,2
59,"DOMAIN",0,0,"",2,0,0,2
60,"DOMAIN",0,0,"",2,0,0,2
61,"DOMAIN",0,0,"",2,0,0,2
62,"DOMAIN",0,0,"",2,0,0,2
63,"DOMAIN",0,0,"",2,0,0,2
/*
CREATE TABLE DOMAIN_PROP_VALUE
(CS_DOMAIN_ID INTEGER NOT NULL,
CS_DOMAIN_TYPE CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
RESERVED INTEGER NOT NULL,
TARGET_SYSTEM CHAR(6) NOT NULL,
CS_DOMAINPV_SEQ INTEGER NOT NULL,
CS_DOMAINPV_TYPE CHAR(6) NOT NULL,
CS_DOMAINPV_TEXT_VAL INTEGER,
CS_DOMAINPV_INT_VAL INTEGER,
CS_DOMAINPV_ID_VAL INTEGER,
CS_DOMAINPV_STR_VAL VARCHAR(254),
CS_DOMAINPV_INHERIT INTEGER NOT NULL
);
*/
1,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"CHAR(10)",0
1,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
3,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
3,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
3,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"id",0
4,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(10)",0
4,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
4,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"role",0
5,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
5,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
5,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"id",0
6,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(10)",0
6,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
6,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"name",0
7,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(10)",0
7,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
7,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"password",0
8,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
8,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
8,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"level_id",0
9,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
9,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
9,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"id",0
10,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(50)",0
10,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
10,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"name",0
11,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
11,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
11,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"profession_id",0
12,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(10)",0
12,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
12,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"stu_num",0
13,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(10)",0
13,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
13,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"name",0
14,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"CHAR(2)",0
14,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -