dynamic_screens.pdm

国外的一套开源CRM

/BEGIN_TABLE AMCHEAD
NAME A30
VERS A8
USER A30
/BEGIN_DATA AMCHEAD
PowerDesigner/PDM
6.1.1

/END_TABLE AMCHEAD

/BEGIN_TABLE AMCMODL
@       N5
OID     N8
MODL    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
OPTS    TXT
EXOP    TXT
DBMS    A256
FILE    A256
HEAD    TXT
FOOT    TXT
POID    N8
PNAM    A80
PCOD    A80
USER    A80
VERS    A8
CDAT    N12
MDAT    N12
EDAT    N12
PART    N1
ACCS    N5
CUST    TXT
/BEGIN_DATA AMCMODL
3
3
3
Model_2
Model_2





ODBC
odbc.def


0




1005083112
1007528045
0
0
0

/END_TABLE AMCMODL

/BEGIN_TABLE AMCDOMN
@       N5
OID     N8
DOMN    N8
NAME    A80
CODE    A80
DESC    TXT
NOTE    TXT
LABL    A254
DTTP    A30
MLEN    N8
PREC    N2
IDNT    N1
WDEF    N1
MAND    N1
UNIT    A8
FRMT    A20
LVAL    A20
HVAL    A20
DVAL    A30
UPPR    N1
LOWR    N1
NMDF    N1
VALS    TXT
CRUL    TXT
GRUL    TXT
SOID    N8
ATYP    N8
PROF    N8
ROPR    N1
/BEGIN_DATA AMCDOMN
1
339
339
D_CODE_TYPE
D_CODE_TYPE



VARCHAR2(5)
5
0
0
0
1





0
0
0



0
0
0
0
1
340
340
D_SHORT_DESC
D_SHORT_DESC



VARCHAR2(40)
40
0
0
0
1





0
0
0



0
0
0
0
1
341
341
D_CODE_ID
D_CODE_ID



VARCHAR2(5)
5
0
0
0
1





0
0
0



0
0
0
0
/END_TABLE AMCDOMN

/BEGIN_TABLE AMCTABL
@       N5
OID     N8
TABL    N8
MODL    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
NBRC    N24,0
SOID    N8
TOBJ    N5
COBJ    A80
OPTS    TXT
PKOP    TXT
CRUL    TXT
SRUL    TXT
PKCN    A30
CKCN    A30
HEAD    TXT
FOOT    TXT
NGEN    N1
OWNR    N8
ATYP    N8
TSTD    N8
ROPR    N1
/BEGIN_DATA AMCTABL
1
1
1
3
ui_application
ui_application
MySQL table


0
0
0
ui_application




PRIMARY



0
0
0
0
0
3
7
7
3
ui_attribute
ui_attribute
MySQL table


0
0
0
ui_attribute




PRIMARY



0
0
0
0
0
3
24
24
3
ui_display_type
ui_display_type
MySQL table


0
0
0
ui_display_type




PRIMARY



0
0
0
0
0
3
30
30
3
ui_entity
ui_entity
MySQL table


0
0
0
ui_entity




PRIMARY



0
0
0
0
0
3
37
37
3
ui_layout_type
ui_layout_type
MySQL table


0
0
0
ui_layout_type




PRIMARY



0
0
0
0
0
1
41
41
3
ui_screen
ui_screen
MySQL table


0
0
0
ui_screen




PRIMARY



0
0
0
0
0
3
48
48
3
ui_screen_section
ui_screen_section
MySQL table


0
0
0
ui_screen_section




PRIMARY



0
0
0
0
0
3
57
57
3
ui_screen_section_info
ui_screen_section_info
MySQL table


0
0
0
ui_screen_section_info




PRIMARY



0
0
0
0
0
3
162
162
3
ui_screen_section_entity
ui_screen_section_entity



0
0
0
ui_screen_section_entity








0
0
0
0
0
3
342
342
3
CODE_TYPE
CODE_TYPE



0
0
0
CODE_TYPE




PK_CODE_TYPE



0
0
0
0
0
3
343
343
3
CODE
CODE



0
0
0
CODE




PK_CODE



0
0
0
0
0
3
623
623
3
ui_display_attrib
ui_display_attrib



0
0
0
ui_display_type_attrib








0
0
0
0
0
3
624
624
3
ui_display_object
ui_display_object



0
0
0
UI_DISPLAY_OBJECT








0
0
0
0
0
3
625
625
3
ui_display_object_attrib
ui_display_object_attrib



0
0
0
UI_DISPLAY_OBJECT_ATTRIB








0
0
0
0
0
/END_TABLE AMCTABL

/BEGIN_TABLE AMCCOLN
@       N5
OID     N8
COLN    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TABL    N8
DOMN    N8
DTTP    A30
MLEN    N8
PREC    N2
IDNT    N1
WDEF    N1
UNIT    A8
FRMT    A20
LVAL    A20
HVAL    A20
DVAL    A30
UPPR    N1
LOWR    N1
NMDF    N1
VALS    TXT
CRUL    TXT
GRUL    TXT
PRIM    N1
FORN    N1
MAND    N1
DISP    N1
SOID    N8
TOBJ    N5
COBJ    A80
CKCN    A30
NUMR    N8
PROF    N8
REDU    N8
NULV    N5
AVLN    N8
ATYP    N8
ROPR    N1
/BEGIN_DATA AMCCOLN
3
2
2
APPLICATION_ID
APPLICATION_ID



1
0
VARCHAR(20)
20
0
0
0





0
0
0



1
0
1
1
0
0
APPLICATION_ID

1
0
-100
0
0
0
0
3
3
3
APPLICATION_NAME
APPLICATION_NAME



1
0
VARCHAR(60)
60
0
0
0





0
0
0



0
0
0
1
0
0
APPLICATION_NAME

2
0
-100
0
0
0
0
3
4
4
APPLICATION_DESCRIPTION
APPLICATION_DESCRIPTION



1
0
TEXT
0
0
0
0





0
0
0



0
0
0
1
0
0
APPLICATION_DESCRIPTION

3
0
-100
0
0
0
0
3
8
8
ATTRIBUTE_ID
ATTRIBUTE_ID



7
0
VARCHAR(20)
20
0
0
0





0
0
0



1
0
1
1
0
0
ATTRIBUTE_ID

1
0
-100
0
0
0
0
3
9
9
ENTITY_ID
ENTITY_ID



7
0
VARCHAR(20)
20
0
0
0





0
0
0



0
1
0
1
0
0
ENTITY_ID

2
0
-100
0
0
0
0
3
10
10
ATTRIBUTE_NAME
ATTRIBUTE_NAME



7
0
VARCHAR(60)
60
0
0
0





0
0
0



0
0
0
1
0
0
ATTRIBUTE_NAME

3
0
-100
0
0
0
0
3
11
11
DESCRIPTION
DESCRIPTION



7
0
TEXT
0
0
0
0





0
0
0



0
0
0
1
0
0
DESCRIPTION

4
0
-100
0
0
0
0
3
12
12
COLUMN_NAME
COLUMN_NAME



7
0
VARCHAR(60)
60
0
0
0





0
0
0



0
0
0
1
0
0
COLUMN_NAME

5
0
-100
0
0
0
0
3
653
653
DISPLAY_OBJECT_ID
DISPLAY_OBJECT_ID



7
0
VARCHAR2(20)
20
0
0
0





0
0
0



0
1
0
1
0
0
DISPLAY_OBJECT_ID

6
0
-100
0
0
0
0
3
14
14
MAX_LENGTH
MAX_LENGTH



7
0
DECIMAL(18)
18
0
0
0





0
0
0



0
0
0
1
0
0
MAX_LENGTH

7
0
-100
0
0
0
0
3
15
15
EDIT_MASK
EDIT_MASK



7
0
VARCHAR(60)
60
0
0
0





0
0
0



0
0
0
1
0
0
EDIT_MASK

8
0
-100
0
0
0
0
3
16
16
DISPLAY_LOGIC
DISPLAY_LOGIC



7
0
TEXT
0
0
0
0





0
0
0



0
0
0
1
0
0
DISPLAY_LOGIC

9
0
-100
0
0
0
0
3
17
17
IS_MANDATORY
IS_MANDATORY


If IS_MANDATORY is Y in the ui_attribute table, then IS_MANDATORY must be Y in the ui_screen_section_info table wherever this attribute appears.
7
0
CHAR(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
IS_MANDATORY

10
0
-100
0
0
0
0
3
18
18
IS_READ_ONLY
IS_READ_ONLY



7
0
CHAR(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
IS_READ_ONLY

11
0
-100
0
0
0
0
3
19
19
IS_VISIBLE
IS_VISIBLE


If IS_VISIBLE is N in the ui_attribute table, then IS_VISIBLE will be N in the ui_screen_section_info table wherever this attribute appears.
7
0
CHAR(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
IS_VISIBLE

12
0
-100
0
0
0
0
3
258
258
IS_EXTENSION
IS_EXTENSION



7
0
CHAR(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
IS_EXTENSION

13
0
-100
0
0
0
0
3
20
20
DISPLAY_ORDER
DISPLAY_ORDER



7
0
DECIMAL(18)
18
0
0
0





0
0
0



0
0
0
1
0
0
DISPLAY_ORDER

14
0
-100
0
0
0
0
3
21
21
DISPLAY_LABEL
DISPLAY_LABEL



7
0
VARCHAR(60)
60
0
0
0





0
0
0



0
0
0
1
0
0
DISPLAY_LABEL

15
0
-100
0
0
0
0
3
527
527
DISPLAY_LENGTH
DISPLAY_LENGTH



7
0
DECIMAL(18)
18
0
0
0





0
0
0



0
0
0
1
0
0
DISPLAY_LENGTH

16
0
-100
0
0
0
0
3
25
25
DISPLAY_TYPE_ID
DISPLAY_TYPE_ID



24
0
VARCHAR(60)
60
0
0
0





0
0
0



1
0
1
1
0
0
DISPLAY_TYPE_ID

1
0
-100
0
0
0
0
3
26
26
NAME
NAME



24
0
VARCHAR(60)
60
0
0
0





0
0
0



0
0
0
1
0
0
DISPLAY_TYPE_NAME

2
0
-100
0
0
0
0
3
27
27
DESCRIPTION
DESCRIPTION



24
0
TEXT
0
0
0
0





0
0
0



0
0
0
1
0
0
DESCRIPTION

3
0
-100
0
0
0
0
3
31
31
ENTITY_ID
ENTITY_ID



30
0
VARCHAR(20)
20
0
0
0





0
0
0



1
0
1
1
0
0
ENTITY_ID

1
0
-100
0
0
0
0
3
32
32
ENTITY_NAME
ENTITY_NAME



30
0
VARCHAR(60)
60
0
0
0





0
0
0



0
0
1
1
0
0
ENTITY_NAME

2
0
-100
0
0
0
0
3
33
33
TABLE_NAME
TABLE_NAME



30
0
VARCHAR(60)
60
0
0
0





0
0
0



0
0
1
1
0
0
TABLE_NAME

3
0
-100
0
0
0
0
3
173
173
EXT_TABLE_NAME
EXT_TABLE_NAME



30
0
VARCHAR(60)
60
0
0
0





0
0
0



0
0
0
1
0
0
EXT_TABLE_NAME

4
0
-100
0
0
0
0
3
34
34
DESCRIPTION
DESCRIPTION



30
0
TEXT
0
0
0
0





0
0
0



0
0
1
1
0
0
DESCRIPTION

5
0
-100
0
0
0
0
3
38
38
LAYOUT_TYPE_ID
LAYOUT_TYPE_ID



37
0
VARCHAR(20)
20
0
0
0





0
0
0



1
0
1
1
0
0
LAYOUT_TYPE_ID

1
0
-100
0
0
0
0
3
98
98
DESCRIPTION
DESCRIPTION



37
0
TEXT
0
0
0
0





0
0
0



0
0
0
1
0
0
DESCRIPTION

2
0
-100
0
0
0
0
3
99
99
LAYOUT_NAME
LAYOUT_NAME



37
0
VARCHAR(60)
60
0
0
0





0
0
0



0
0
0
1
0
0
LAYOUT_NAME

3
0
-100
0
0
0
0
3
42
42
SCREEN_ID
SCREEN_ID



41
0
VARCHAR(20)
20
0
0
0





0
0
0



1
0
1
1
0
0
SCREEN_ID

1
0
-100
0
0
0
0
3
43
43
APPLICATION_ID
APPLICATION_ID



41
0
VARCHAR(20)
20
0
0
0





0
0
0



0
1
0
1
0
0
APPLICATION_ID

2
0
-100
0
0
0
0
3
44
44
SCREEN_NAME
SCREEN_NAME



41
0
VARCHAR(60)
60
0