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