database.erx

学生信息管理系统

14,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"sex",0
15,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(50)",0
15,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
15,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"birthday",0
16,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
16,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
16,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"nation_id",0
17,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(20)",0
17,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
17,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"native_place",0
18,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
18,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
18,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"profession_id",0
19,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(20)",0
19,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
19,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"dorm",0
20,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(20)",0
20,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
20,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"phone",0
21,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
21,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
21,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"business_id",0
22,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(50)",0
22,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
22,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"home_address",0
23,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(20)",0
23,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
23,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"home_phone",0
24,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(6)",0
24,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
24,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"postalcode",0
25,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(50)",0
25,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
25,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"email",0
26,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(20)",0
26,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
26,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"enter_date",0
27,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONGTEXT",0
27,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
27,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"intro",0
28,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
28,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
28,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"id",0
29,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(50)",0
29,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
29,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"name",0
30,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
30,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
30,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"college_id",0
31,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONGTEXT",0
31,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
31,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"intro",0
32,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
32,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
32,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"id",0
33,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(14)",0
33,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
33,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"name",0
34,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
34,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
34,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"id",0
35,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(20)",0
35,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
35,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"classroom",0
36,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
36,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
36,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"course_id",0
37,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
37,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
37,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"type_id",0
38,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
38,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
38,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"teacher_id",0
39,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"SHORT",0
39,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
39,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"stu_amount",0
40,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"DOUBLE",0
40,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
40,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"coefficient",0
41,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
41,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
41,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"time_id",0
42,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
42,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
42,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"id",0
43,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(20)",0
43,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
43,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"name",0
44,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
44,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
44,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"id",0
45,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(50)",0
45,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
45,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"name",0
46,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"DOUBLE",0
46,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
46,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"credit_hour",0
47,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
47,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
47,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"profession_id",0
48,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
48,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
48,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"id",0
49,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(50)",0
49,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
49,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"name",0
50,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(50)",0
50,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
50,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"address",0
51,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(50)",0
51,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
51,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"phone",0
52,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(10)",0
52,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
52,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"master",0
53,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONGTEXT",0
53,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
53,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"intro",0
54,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(20)",0
54,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
54,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"address",0
55,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
55,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
55,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"capacity",0
56,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
56,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
56,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"id",0
57,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(20)",0
57,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
57,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"caption",0
58,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(20)",0
58,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
58,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"during_time",0
59,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
59,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
59,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"id",0
60,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(14)",0
60,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
60,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"name",0
61,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
61,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,1,0,"",0
61,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"id",0
62,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"TEXT(10)",0
62,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
62,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"stu_num",0
63,"DOMAIN",0,0,"TD_UN",0,"CD_TYP",0,0,0,"LONG",0
63,"DOMAIN",0,0,"TD_UN",0,"CD_NUL",0,0,0,"",0
63,"DOMAIN",0,0,"TD_UN",0,"CD_NAM",0,0,0,"curriculum_id",0
/*
CREATE TABLE ERWIN_DEFAULT
      (DEFAULT_ID               INTEGER NOT NULL,
       DEFAULT_TYPE             CHAR(6) NOT NULL,
       ERWIN_DIAGRAM_ID         INTEGER NOT NULL,
       RESERVED                 INTEGER NOT NULL,
       DEFAULT_NAME             VARCHAR(254),
       CLIENT_VALUE             INTEGER,
       SERVER_VALUE             INTEGER,
       DEFAULT_FLAG             INTEGER
);
*/
/*
CREATE TABLE REL_PHYS_PROP
      (RELATIONSHIP_ID          INTEGER NOT NULL,
       RELATIONSHIP_TYPE        CHAR(6) NOT NULL,
       ERWIN_DIAGRAM_ID         INTEGER NOT NULL,
       RESERVED                 INTEGER NOT NULL,
       TARGET_SYSTEM            CHAR(6) NOT NULL,
       FOREIGN_KEY_NAME         VARCHAR(8) NOT NULL,
	   PHYSICAL_COMMENT         INTEGER
);
*/
2,"RT_NI",0,0,"TD_UN","FK_user_info_user_level",833449992
5,"RT_NI",0,0,"TD_UN","FK_curriculum_schedule_teacher",833449992
7,"RT_NI",0,0,"TD_UN","FK_achievement_student",833449992
9,"RT_NI",0,0,"TD_UN","FK_course_profession",833449992
10,"RT_NI",0,0,"TD_UN","FK_student_profession",833449992
11,"RT_NI",0,0,"TD_UN","FK_teacher_profession",833449992
13,"RT_NI",0,0,"TD_UN","FK_student_nation",833449992
15,"RT_NI",0,0,"TD_UN","FK_achievement_curriculum_schedule",833449992
17,"RT_NI",0,0,"TD_UN","FK_curriculum_schedule_course_type",833449992
19,"RT_NI",0,0,"TD_UN","FK_curriculum_schedule_course",833449992
21,"RT_NI",0,0,"TD_UN","FK_profession_college",833449992
23,"RT_NI",0,0,"TD_UN","FK_curriculum_schedule_classroom",833449992
25,"RT_NI",0,0,"TD_UN","FK_curriculum_class_time",833449992
27,"RT_NI",0,0,"TD_UN","FK_student_bussiness",833449992
/*
CREATE TABLE REL_TEMPLATE
      (RELATIONSHIP_ID          INTEGER NOT NULL,
       RELATIONSHIP_TYPE        CHAR(6) NOT NULL,
       TEMPLATE_ID              INTEGER NOT NULL,
       TEMPLATE_TYPE            CHAR(6) NOT NULL,
       ERWIN_DIAGRAM_ID         INTEGER NOT NULL,
       RESERVED                 INTEGER NOT NULL,
       TARGET_SYSTEM            CHAR(6) NOT NULL,
       REL_TMPLT_PURPOSE        CHAR(6)
);
*/
/*
CREATE TABLE TEMPLATE
      (TEMPLATE_ID              INTEGER NOT NULL,
       TEMPLATE_TYPE            CHAR(6) NOT NULL,
       ERWIN_DIAGRAM_ID         INTEGER NOT NULL,
       RESERVED                 INTEGER NOT NULL,
       TARGET_SYSTEM            CHAR(6) NOT NULL,
       TEMPLATE_NAME            VARCHAR(254) NOT NULL,
       TEMPLATE_CODE            INTEGER
);
*/
/*
CREATE TABLE GLOBAL_TEMPLATE
      (TEMPLATE_ID              INTEGER NOT NULL,
       TEMPLATE_TYPE            CHAR(6) NOT NULL,
       ERWIN_DIAGRAM_ID         INTEGER NOT NULL,
       RESERVED                 INTEGER NOT NULL,
       TARGET_SYSTEM            CHAR(6) NOT NULL,
       TEMPLATE_PURPOSE         CHAR(6) NOT NULL
);
*/
/*
CREATE TABLE ENTITY_SP_TEMPLATE
      (ENTITY_ID                INTEGER NOT NULL,
       ENTITY_TYPE              CHAR(6) NOT NULL,
       TEMPLATE_ID              INTEGER NOT NULL,
       TEMPLATE_TYPE            CHAR(6) NOT NULL,
       ERWIN_DIAGRAM_ID         INTEGER NOT NULL,
       RESERVED                 INTEGER NOT NULL,
       TARGET_SYSTEM            CHAR(6) NOT NULL
);
*/
/*
CREATE TABLE FONT
      (FONT_ID                  INTEGER NOT NULL,
       FONT_TYPE                CHAR(6) NOT NULL,
       ERWIN_DIAGRAM_ID         INTEGER NOT NULL,
       RESERVED                 INTEGER NOT NULL,
       FONT_HEIGHT              INTEGER NOT NULL,
       FONT_WIDTH               INTEGER NOT NULL,
       FONT_ESCAPEMENT          INTEGER NOT NULL,
       FONT_ORIENTATION         INTEGER NOT NULL,
       FONT_WEIGHT              INTEGER NOT NULL,
       FONT_ITALIC              BYTE NOT NULL,
       FONT_UNDERLINE           BYTE NOT NULL,
       FONT_STRIKEOUT           BYTE NOT NULL,
       FONT_CHARSET             BYTE NOT NULL,
       FONT_OUTPRECISION        BYTE NOT NULL,
       FONT_CLIPPRECISION       BYTE NOT NULL,
       FONT_QUALITY             BYTE NOT NULL,
       FONT_PITCHANDFAMILY      BYTE NOT NULL,
       FONT_NAME                VARCHAR(254) NOT NULL,
       OLDFONT_HEIGHT           INTEGER NOT NULL,
);
*/
0,"TX_FNT",0,0,10,0,0,0,400,0,0,0,0,7,2,1,34,"Arial",-13
/*
CREATE TABLE COLOR
      (COLOR_ID                 INTEGER NOT NULL,
       COLOR_TYPE               CHAR(6) NOT NULL,
       ERWIN_DIAGRAM_ID         INTEGER NOT NULL,
       RESERVED                 INTEGER NOT NULL,
       COLOR_VALUE              INTEGER NOT NULL
);
*/
0,"TX_COL",0,0,0
1,"TX_COL",0,0,16777215
/*
CREATE TABLE SUBJECT
      (ERWIN_DIAGRAM_ID         INTEGER NOT NULL,
       SUBJECT_ID               INTEGER NOT NULL,
       SUBJECT_NAME             VARCHAR(254),
       SUBJECT_DESCRIPTION      INTEGER NOT NULL,
       SUBJECT_AUTHOR           VARCHAR(254),
       SUBJECT_CREATION_DATE    INTEGER NOT NULL,
       SUBJECT_MOD_DATE         INTEGER NOT NULL
);
*/
/*
CREATE TABLE DISPLAY
      (ERWIN_DIAGRAM_ID         INTEGER NOT NULL,
       SUBJECT_ID               INTEGER NOT NULL,
       DISPLAY_ID               INTEGER NOT NULL,
       RESERVED                 INTEGER NOT NULL,
       DISPLAY_NAME             VARCHAR(254),
       DISPLAY_DESCRIPTION      INTEGER NOT NULL,
       DISPLAY_AUTHOR           VARCHAR(254),
       DISPLAY_CREATION_DATE    INTEGER NOT NULL,
       DISPLAY_MOD_DATE         INTEGER NOT NULL,
       ENTITY_FILL_COLOR        INTEGER NOT NULL,
       BACKGROUND_COLOR_ID      INTEGER NOT NULL,
       DEF_REL_FONT_ID          INTEGER NOT NULL,
       DEF_ENT_NAME_FONT_ID     INTEGER NOT NULL,
       DEF_ENT_DEF_FONT_ID      INTEGER NOT NULL,
       DEF_ELINE_COLOR_ID       INTEGER NOT NULL,
       DEF_EDEF_COLOR_ID        INTEGER NOT NULL,
       DEF_REL_NAME_COLOR_ID    INTEGER NOT NULL,
       DEF_ENT_NAME_COLOR_ID    INTEGER NOT NULL,
       FONT_TYPE                CHAR(6),
       COLOR_TYPE               CHAR(6)
);
*/
/*
CREATE TABLE ERWIN_REPORT
      (ERWIN_DIAGRAM_ID         INTEGER NOT NULL,
       ERWIN_REPORT_ID          INTEGER NOT NULL,
       ERWIN_REPORT_TYPE        CHAR(6) NOT NULL,
       ERWIN_REPORT_NAME        VARCHAR(254) NOT NULL
);
*/
/*
CREATE TABLE ERWIN_REPORT_OPTION
      (ERWIN_DIAGRAM_ID         INTEGER NOT NULL,
       ERWIN_REPORT_ID          INTEGER NOT NULL,
       REPORT_OPTION_ID         INTEGER NOT NULL,
       REPORT_OPTION_SEQ        INTEGER NOT NULL,
       REPORT_OPTION_NAME       VARCHAR(254) NOT NULL,
       REPORT_OPTION_VALUE      INTEGER NOT NULL,
       REPORT_OPTION_TYPE       INTEGER NOT NULL,
       REPORT_OPTION_MULTI      INTEGER NOT NULL
);
*/
/*
CREATE TABLE ENTITY_SYNONYM
       SYNONYM_NAME             CHAR(128) NOT NULL,
       ENTITY_ID                INTEGER NOT NULL,
       ENTITY_TYPE              CHAR(6) NOT NULL,
       ERWIN_DIAGRAM_ID         INTEGER NOT NULL,
       RESERVED                 INTEGER NOT NULL
);
*/
/*
CREATE TABLE SYNONYM_PHYSICAL_PV
      (SYNONYM_NAME             CHAR(128) 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,
       SYNONYM_PV_ID            CHAR(6),
       SYNONYM_PV_VALUE         CHAR(256)
);
*/