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