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