aasd

Tables (6)

email

  • id — SERIAL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • body — TEXT — NOT NULL
  • sender — VARCHAR(255) — NOT NULL
  • receiver — VARCHAR(255) — NOT NULL
  • is_important — BOOLEAN
  • send_at — TIMESTAMP
  • receive_at — TIMESTAMP
  • draft — BOOLEAN
  • scheduled_at — TIMESTAMP

multifile

  • id — SERIAL
  • email_id — INT — Foreign key → email.id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_path — TEXT — NOT NULL
  • created_at — TIMESTAMP

spam_email

  • id — SERIAL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • spam_email — VARCHAR(255) — NOT NULL

token

  • id — SERIAL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • refresh_token — TEXT — NOT NULL

trash

  • id — SERIAL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • email_id — INT — Foreign key → email.id — NOT NULL
  • trash_at — TIMESTAMP

user

  • id — SERIAL
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • create_time — TIMESTAMP
  • role — VARCHAR(50) — NOT NULL