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