41
M:\svn\servadmin\erd\ERD01.dez
2007-07-18
2007-07-18
ServAdmin UI
Jon Coulter
2008
M:\svn\servadmin\erd\create.sql;M:\svn\servadmin\erd\drop.sql;C:\Program Files\Datanamic\DeZign for Databases V4\logfiles\CreateDBLog_200707184.txt
mysql5
10
PK_%table%
%relname%
CC_%table%_%column%
NN_%column%
DEF_%table%_%column%
TUC_%table%_%counter%
TCC_%table%_%counter%
%parent%_%child%
IDX_%table%_%counter%
engine=innodb
1
1
1
1
1
1
1
0
1
1
1
1
1
1
M:\svn\servadmin\erd\create.sql
M:\svn\servadmin\erd\drop.sql
account
2
0
engine=innodb
9
3
1
1
PK_account
PK_%table%
1
0
2
3
2
accountid
2
0
-1
INTEGER
0
1
1
NN_%column%
1
0
1
1
5
2
username
3
0
-1
VARCHAR
100
0
1
password
4
0
-1
VARCHAR
32
0
1
ownername
5
0
-1
VARCHAR
255
0
1
email
6
0
-1
VARCHAR
255
0
1
domain
7
0
-1
VARCHAR
255
0
1
accstatus
8
0
-1
VARCHAR
100
0
1
createdatetime
9
0
-1
DATETIME
0
1
IDX_account_1
IDX_%table%_%counter%
2
0
UNIQUE
0
0
3
IDX_account_2
IDX_%table%_%counter%
3
0
0
0
3
4
server
3
0
engine=innodb
11
2
1
1
PK_server
PK_%table%
1
0
2
3
2
serverid
2
0
-1
INTEGER
0
1
1
NN_%column%
1
0
1
1
5
2
servname
3
0
-1
VARCHAR
100
0
1
servkey
4
0
-1
VARCHAR
200
0
1
servurl
5
0
-1
VARCHAR
250
0
1
ftpurl
6
0
-1
VARCHAR
200
0
1
nameserver1
7
0
-1
VARCHAR
200
0
1
nameserver2
8
0
-1
VARCHAR
200
0
1
mailservname
9
0
-1
VARCHAR
200
0
1
smtpservname
10
0
-1
VARCHAR
200
0
1
tmpurl
11
0
-1
VARCHAR
250
0
1
IDX_server_1
IDX_%table%_%counter%
2
0
0
0
4
account_server
4
0
engine=innodb
4
3
1
1
PK_account_server
PK_%table%
1
0
2
3
3
4
accountid
3
0
-1
INTEGER
0
1
1
0
1
1
5
3
serverid
4
0
-1
INTEGER
0
1
1
0
1
1
5
4
IDX_account_server_1
IDX_%table%_%counter%
2
0
5
2
3
IDX_account_server_2
IDX_%table%_%counter%
3
0
6
2
4
support_ticket
7
0
engine=innodb
11
3
1
1
PK_support_ticket
PK_%table%
1
0
2
3
2
ticketid
2
0
-1
INTEGER
0
1
1
NN_%column%
1
0
1
1
5
2
accountid
10
0
-1
INTEGER
0
1
1
0
1
1
5
10
parentticketid
11
0
-1
INTEGER
0
1
1
0
1
1
5
11
topic
5
0
-1
VARCHAR
255
0
1
content
6
0
-1
LONGTEXT
0
1
createdatetime
7
0
-1
DATETIME
0
1
ticketstatus
8
0
-1
VARCHAR
20
0
1
DEF_%table%_%column%
2
0
open
1
6
8
IDX_support_ticket_1
IDX_%table%_%counter%
2
0
9
2
10
IDX_support_ticket_2
IDX_%table%_%counter%
3
0
10
2
11
account_account_server
%parent%_%child%
5
0
2
4
0
0
1
2
2
account_account_server
%relname%
1
0
2
4
3
0
0
2
3
server_account_server
%parent%_%child%
6
0
3
4
0
0
1
2
2
server_account_server
%relname%
1
0
2
4
4
0
0
2
4
account_support_ticket
%parent%_%child%
9
0
2
7
0
1
1
2
2
account_support_ticket
%relname%
1
0
2
4
10
0
0
2
10
support_ticket_support_ticket
%parent%_%child%
10
0
7
7
0
1
1
2
2
support_ticket_support_ticket
%relname%
1
0
2
4
11
0
0
2
11
0
2
PK
FK
PF
*
0
16777215
16777215
16777215
8421504
0
0
0
0
0
0
0
0
1
1
0
0
0
0
Arial,9,B,0,clNavy,0
Arial,8,B,0,clWindowText,0
Arial,8,I,0,clWindowText,0
Arial,8,,0,clWindowText,0
Arial,8,,0,clWindowText,0
Arial,8,,0,clWindowText,0
Arial,8,,0,clWindowText,0
Arial,8,,0,clWindowText,0
1
Main Diagram
1
8421376
0
0
0
1
1
0
0
2
1
101
169
145
62
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
3
1
101
203
499
198
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
4
1
98
67
328
217
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
7
1
101
152
100
377
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
5
1
Arial,8,,0,clWindowText,0
0,1,4,0
5000
5000
5000
5000
246
146
316
146
316
251
327
251
6
1
Arial,8,,0,clWindowText,0
0,1,4,0
5000
5000
5000
5000
498
300
469
300
469
251
426
251
9
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
195
231
195
304
150
304
150
376
10
1
Arial,8,,0,clWindowText,0
1,1,4,0
7228
5000
5000
5000
173
376
173
337
241
337
241
453
201
453