maru erd
Tables (6)
diaries (Untitled)
- diary_id (Key) — INT8 — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- title (Field4) — VARCHAR(256) — NOT NULL
- content (Field2) — TEXT — NOT NULL
- emoji (Field6) — VARCHAR(50) — NOT NULL
- created_at (Field) — TIMESTAMPZ — NOT NULL
- updated_at (Field3) — TIMESTAMPZ — NOT NULL
- deleted_at (Field5) — TIMESTAMPZ
diary_files (Untitled4)
- diary_file_id (Key) — INT8 — Primary key — NOT NULL
- diary_id (Key3) — INT8 — Foreign key → diaries.diary_id — NOT NULL
- file_id (Key2) — INT8 — Foreign key → files.file_id — NOT NULL
- created_at (Field) — TIMESTAMPZ — NOT NULL
- updated_at (Field2) — TIMESTAMPZ — NOT NULL
files (Untitled3)
- file_id (Key) — INT8 — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- path (Field) — VARCHAR — NOT NULL
- original_path (Field4) — VARCHAR — NOT NULL
- status (Field5) — VARCHAR — NOT NULL
- created_at (Field2) — TIMESTAMPZ — NOT NULL
- updated_at (Field3) — TIMESTAMPZ — NOT NULL
- deleted_at (Field6) — TIMESTAMPZ
streaks (Untitled2)
- streak_id (Key) — INT8 — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- streak (Field) — INT8 — NOT NULL
- best_streak (Field2) — INT8 — NOT NULL
- created_at (Field3) — TIMESTAMPZ — NOT NULL
- updated_at (Field4) — TIMESTAMPZ — NOT NULL
token_blacklist (Untitled5)
- token_blacklist_id (Key) — INT8 — Primary key — NOT NULL
- acess_token (Field) — VARCHAR(512) — NOT NULL
- created_at (Field2) — TIMESTAMPZ — NOT NULL
- updated_at (Field3) — TIMESTAMPZ — NOT NULL
users
- user_id — UUID — Primary key — NOT NULL
- email (Field4) — TEXT — NOT NULL
- vendor — CHAR(20) — NOT NULL
- nickname — TEXT — NOT NULL
- created_at (Field) — TIMESTAMPZ — NOT NULL
- updated_at (Field2) — TIMESTAMPZ — NOT NULL
- deleted_at (Field3) — TIMESTAMPZ