1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
|
propel:
role:
_attributes: { phpName: Role }
id:
name: varchar(255)
credentials: varchar(255)
user:
_attributes: { phpName: User }
id:
parent_user_id: { type: integer, default: -1, foreignTable: user, foreignReference: id, onDelete: setnull }
nickname: varchar(50)
first_name: varchar(100)
last_name: varchar(100)
email: varchar(255)
sha1_password: varchar(40)
salt: varchar(32)
role_id:
last_login: timestamp
created_at:
domain_permission:
_attributes: { phpName: DomainPermission }
user_id: { type: integer, foreignTable: user, foreignReference: id, onDelete: cascade }
domain_id: { type: integer, foreignTable: domain, foreignReference: id, onDelete: cascade }
domain:
_attributes: { phpName: Domain }
id:
name: varchar(255)
creator_id: { type: integer, foreignTable: user, foreignReference: id, onDelete: setnull }
mailbox_prefix: varchar(255)
max_mailbox_count: integer
quota: integer
default_mailbox_quota: integer
_uniques:
i2: [name]
mailbox:
_attributes: { phpName: Mailbox }
id:
domain_id: { type: integer, foreignTable: domain, foreignReference: id, onDelete: setnull }
name: varchar(30)
password: varchar(40)
max_quota: integer
max_address_count: integer
last_login: timestamp
active: { type: boolean, default: true }
address:
_attributes: { phpName: Address }
id:
mailbox_id: { type: integer, foreignTable: mailbox, foreignReference: id, onDelete: cascade }
localpart: varchar(255)
domain_id:
alias: varchar(255)
destination: longvarchar
active: { type: boolean, default: true }
save_in_mailbox: { type: boolean, default: true }
log:
_attributes: { phpName: LogEntry }
id:
user_id: { type: integer, default: null, foreignTable: user, foreignReference: id, onDelete: setnull }
created_at:
message: longvarchar
host: varchar(255)
priority: integer
|