Mail & Contact
Tables (8)
Untitled (outbox)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (mail_id) — bigint(20) — Foreign key → Untitled2.Key — NOT NULL
- Field (from_sid) — varchar(40) — NOT NULL
- Field (to_sid) — varchar(40) — NOT NULL
- Field (important) — tinyint(1) — NOT NULL
- Field (trash) — tinyint(1) — NOT NULL
- Field (mail_box_name) — varchar(200)
- Field (sent_at) — timestamp
- Field (read_at) — timestamp
- Field (created_at) — timestamp
Untitled (inbox)
- Key (id) — Primary key — NOT NULL
- Key (mail_id) — Foreign key → Untitled2.Key — NOT NULL
- Field (from_sid)
- Field2 (to_sid)
- Field (mailbox)
- Field (important)
- Field (spam)
- Field (trash)
- Field (mail_box_name)
- Field (received_at)
- Field (read_at)
Untitled (mailbox)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Field (sid) — varchar(40) — NOT NULL
- Field (name) — varchar(200) — NOT NULL
Untitled (mail_contact)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Field (my_sid)
- Field (sid)
- Field (nickname) — varchar(200) — NOT NULL
- Field (blocked_at) — timestamp
- Field (created_at) — timestamp — NOT NULL
Untitled (*users)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Field (sid) — varchar(40) — NOT NULL — unque
- Field (nickname) — varchar(200) — NOT NULL
Untitled (mail_contact_group)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Field (sid)
- Field (name) — varchar(200)
Untitled (mail_contact_group_member)
- Key (id) — Primary key — NOT NULL
- Key (mail_contact_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (mail_contact_group_name)
Untitled2 (mail)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Field (subject) — varchar(200) — NOT NULL
- Field (content) — longtext — NOT NULL