newbugtracker.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
4
4
Model_4
Mode__4





ORACLE Version 7.3
ORACLE73.DEF


0




946275081
1008716009
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
/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
3
2
2
4
it_Default
it_Default



0
0
0
it_Default




PK_it_DEFAULT



0
0
0
0
0
3
6
6
4
it_Project
it_Project



0
0
0
it_Project
storage\
(\
initial 1024K\
next 1024K\
)



PK_it_PROJECT



0
0
0
0
0
3
13
13
4
it_System
it_System



0
0
0
it_System
storage\
(\
initial 1024K\
next 1024K\
)



PK_it_SYSTEM



0
0
0
0
0
3
14
14
4
it_Procedure
it_Procedure



0
0
0
it_Procedure
storage\
(\
initial 1024K\
next 1024K\
)



PK_it_PROCEDURE



0
0
0
0
0
3
15
15
4
it_issue
it_issue



0
0
0
it_issue
storage\
(\
initial 5120K\
next 5120K\
)



PK_it_issue



0
0
0
0
0
3
23
23
4
it_issue_history
it_issue_history



0
0
0
it_issue_history
storage\
(\
initial 5120K\
next 10240K\
pctincrease 0\
)



PK_it_issue_HISTORY



0
0
0
0
0
3
866
866
4
large_data
large_data



0
0
0
Big_data




PK_it_DEFAULT



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
27
27
DFLT_ID
DFLT_ID



2
0
VARCHAR(60)
60
0
0
0





0
0
0



1
0
1
1
0
0
DFLT_ID

1
0
0
0
0
0
0
3
28
28
DFLT_VAL
DFLT_VAL



2
0
VARCHAR(60)
60
0
0
0





0
0
0



0
0
0
1
0
0
DFLT_VAL

2
0
0
0
0
0
0
3
40
40
Project_id
Project_id



6
0
VARCHAR(20)
20
0
0
0





0
0
0



1
0
1
1
0
0
Project_id

1
0
0
0
0
0
0
3
41
41
project_name
project_name



6
0
VARCHAR(40)
40
0
0
0





0
0
0



0
0
1
1
0
0
project_name

2
0
0
0
0
0
0
3
42
42
project_description
project_description



6
0
VARCHAR(255)
255
0
0
0





0
0
0



0
0
0
1
0
0
project_description

3
0
0
0
0
0
0
3
55
55
Project_id
Project_id



13
0
VARCHAR(20)
20
0
0
0





0
0
0



1
1
1
1
0
0
Project_id

1
0
0
0
0
0
0
3
56
56
system_id
system_id



13
0
VARCHAR(20)
10
0
0
0





0
0
0



1
0
1
1
0
0
system_id

2
0
0
0
0
0
0
3
57
57
system_name
system_name



13
0
VARCHAR(40)
40
0
0
0





0
0
0



0
0
1
1
0
0
system_name

3
0
0
0
0
0
0
3
58
58
system_description
system_description



13
0
VARCHAR(255)
255
0
0
0





0
0
0



0
0
0
1
0
0
system_description

4
0
0
0
0
0
0
3
59
59
Project_id
Project_id



14
0
VARCHAR(20)
20
0
0
0





0
0
0



1
1
1
1
0
0
Project_id

1
0
0
0
0
0
0
3
60
60
system_id
system_id



14
0
VARCHAR(20)
10
0
0
0





0
0
0



1
1
1
1
0
0
system_id

2
0
0
0
0
0
0
3
61
61
procedure_id
procedure_id



14
0
VARCHAR(20)
20
0
0
0





0
0
0



1
0
1
1
0
0
procedure_id

3
0
0
0
0
0
0
3
62
62
procedure_name
procedure_name



14
0
VARCHAR(40)
40
0
0
0





0
0
0



0
0
1
1
0
0
procedure_name

4
0
0
0
0
0
0
3
63
63
procedure_description
procedure_description



14
0
VARCHAR(255)
255
0
0
0





0
0
0



0
0
0
1
0
0
procedure_description

5
0
0
0
0
0
0
3
64
64
issue_id
issue_id



15
0
VARCHAR(20)
20
0
0
0





0
0
0



1
0
1
1
0
0
issue_id

1
0
0
0
0
0
0
3
888
888
issue_type_id
issue_type_id



15
0
VARCHAR(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
issue_type_id

2
0
-100
0
0
0
0
3
889
889
status_id
status_id



15
0
VARCHAR(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
status_id

3
0
-100
0
0
0
0
3
969
969
Project_id
Project_id



15
0
VARCHAR(20)
10
0
0
0





0
0
0



0
1
0
1
0
0
Project_id

4
0
-100
0
0
0
0
3
972
972
system_id
system_id



15
0
VARCHAR(20)
20
0
0
0





0
0
0



0
1
0
1
0
0
system_id

5
0
-100
0
0
0
0
3
975
975
procedure_id
procedure_id



15
0
VARCHAR(20)
20
0
0
0





0
0
0



0
1
0
1
0
0
procedure_id

6
0
-100
0
0
0
0
3
1018
1018
priority_id
priority_id



15
0
VARCHAR(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
priority_id

7
0
-100
0
0
0
0
3
1019
1019
level_id
level_id



15
0
VARCHAR(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
level_id

8
0
-100
0
0
0
0
3
258
258
account_id
account_id



15
0
VARCHAR(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
account_id

9
0
0
0
0
0
0
3
453
453
account_no
account_no



15
0
VARCHAR(255)
255
0
0
0





0
0
0



0
0
0
1
0
0
account_no

10
0
-100
0
0
0
0
3
65
65
short_name
short_name



15
0
VARCHAR(255)
255
0
0
0





0
0
0



0
0
0
1
0
0
short_name

11
0
0
0
0
0
0
3
1065
1065
assigned_to
assigned_to



15
0
VARCHAR(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
assigned_to

12
0
-100
0
0
0
0
3
76
76
version
version



15
0
VARCHAR(255)
255
0
0
0





0
0
0



0
0
0
1
0
0
version

13
0
0
0
0
0
0
3
78
78
due_date
due_date



15
0
DATE
0
0
0
0





0
0
0



0
0
0
1
0
0
complete_date

14
0
0
0
0
0
0
3
79
79
verified
verified



15
0
CHAR(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
verified

15
0
0
0
0
0
0
3
81
81
estimated_hours
estimated_hours



15
0
DECIMAL(4,2)
4
2
0
0





0
0
0



0
0
0
1
0
0
estimated_hours

16
0
0
0
0
0
0
3
82
82
actual_hours
actual_hours



15
0
DECIMAL(4,2)
4
2
0
0





0
0
0



0
0
0
1
0
0
actual_hours

17
0
0
0
0
0
0
3
884
884
created_by
created_by



15
0
VARCHAR(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
created_by

18
0
-100
0
0
0
0
3
885
885
created_date
created_date



15
0
DATE
0
0
0
0





0
0
0



0
0
0
1
0
0
created_date

19
0
-100
0
0
0
0
3
1020
1020
modified_by
modified_by



15
0
VARCHAR(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
modified_by

20
0
-100
0
0
0
0
3
1021
1021
modified_date
modified_date



15
0
DATE
0
0
0
0





0
0
0



0
0
0
1
0
0
modified_date

21
0
-100
0
0
0
0
3
1108
1108
history_id
history_id



23
0
VARCHAR(20)
20
0
0
0





0
0
0



1
0
1
1
0
0


1
0
-100
0
0
0
0
3
937
937
issue_id
issue_id



23
0
VARCHAR(20)
20
0
0
0





0
0
0



0
1
1
1
0
0
issue_id

2
0
-100
0
0
0
0
3
870
870
data_id
data_id



23
0
VARCHAR(40)
40
0
0
0





0
0
0



0
1
0
1
0
0
data_id

3
0
-100
0
0
0
0
3
883
883
status_id
status_id



23
0
VARCHAR(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
status_id

4
0
-100
0
0
0
0
3
139
139
short_name
short_name



23
0
VARCHAR(255)
255
0
0
0





0
0
0



0
0
0
1
0
0
short_name

5
0
0
0
0
0
0
3
886
886
assigned_to
assigned_to



23
0
VARCHAR(255)
255
0
0
0





0
0
0



0
0
0
1
0
0
assigned_to

6
0
-100
0
0
0
0
3
1022
1022
created_by
created_by



23
0
VARCHAR(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
created_by

7
0
-100
0
0
0
0
3
1023
1023
created_date
created_date



23
0
DATE
0
0
0
0





0
0
0



0
0
0
1
0
0
created_date

8
0
-100
0
0
0
0
3
836
836
modified_by
modified_by