Life_Chart

Tables (10)

chat_rooms

  • id — UUID
  • type — room_type — NOT NULL
  • name — VARCHAR(50)
  • created_by — UUID — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

email_verifications

  • id — BIGSERIAL
  • email — VARCHAR(255) — NOT NULL
  • code — VARCHAR(10) — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • verified_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

friends

  • id — BIGSERIAL
  • requester_id — UUID — Foreign key → users.id — NOT NULL
  • addressee_id — UUID — Foreign key → users.id — NOT NULL
  • status — friend_status — NOT NULL
  • requester_memo — TEXT
  • addressee_memo — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

messages

  • id — BIGSERIAL
  • room_id — UUID — Foreign key → chat_rooms.id — NOT NULL
  • sender_id — UUID — Foreign key → users.id — NOT NULL
  • content — TEXT
  • file_url — TEXT
  • file_type — file_kind
  • deleted_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

room_members

  • id — BIGSERIAL
  • room_id — UUID — Foreign key → chat_rooms.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • role — member_role — NOT NULL
  • joined_at — TIMESTAMPTZ — NOT NULL

time_sessions

  • id — BIGSERIAL
  • entry_id — UUID — Foreign key → topic_entries.id — NOT NULL
  • started_at — TIMESTAMPTZ — NOT NULL
  • ended_at — TIMESTAMPTZ
  • duration_seconds — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

todos

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • due_date — DATE — NOT NULL
  • is_done — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

topic_entries

  • id — UUID
  • topic_id — UUID — Foreign key → topics.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • memo — TEXT
  • entry_date — DATE — NOT NULL
  • is_locked — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

topics

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • color — VARCHAR(7)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

users

  • id — UUID
  • handle — VARCHAR(30) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • display_name — VARCHAR(50) — NOT NULL
  • profile_image_url — TEXT
  • is_verified — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL