WithME
Tables (14)
app_user
- id — BIGSERIAL — Primary key — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- email — VARCHAR(255)
- profile_img_url — VARCHAR(500)
- is_app_installed — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
attendance
- id — BIGSERIAL — Primary key — NOT NULL
- occurrence_id — BIGINT — Foreign key → event_occurrence.id — NOT NULL
- user_id — BIGINT — Foreign key → app_user.id — NOT NULL
- is_present — BOOLEAN — NOT NULL
- checked_at — TIMESTAMPTZ
device_token
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → app_user.id — NOT NULL
- platform — VARCHAR(10) — NOT NULL
- token — VARCHAR(500) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
event
- id — BIGSERIAL — Primary key — NOT NULL
- host_user_id — BIGINT — Foreign key → app_user.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- location — VARCHAR(300)
- is_recurring — BOOLEAN — NOT NULL
- rrule — VARCHAR(500)
- join_policy — VARCHAR(20) — NOT NULL
- max_participant — INT
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
event_membership
- id — BIGSERIAL — Primary key — NOT NULL
- event_id — BIGINT — Foreign key → event.id — NOT NULL
- user_id — BIGINT — Foreign key → app_user.id — NOT NULL
- role — VARCHAR(20) — NOT NULL
- join_status — VARCHAR(20) — NOT NULL
- joined_at — TIMESTAMPTZ — NOT NULL
event_occurrence
- id — BIGSERIAL — Primary key — NOT NULL
- event_id — BIGINT — Foreign key → event.id — NOT NULL
- sequence_no — INT
- start_at — TIMESTAMPTZ — NOT NULL
- end_at — TIMESTAMPTZ
- location — VARCHAR(300)
- status — VARCHAR(20) — NOT NULL
- is_exception — BOOLEAN — NOT NULL
- ics_sequence — INT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
notification
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → app_user.id — NOT NULL
- occurrence_id — BIGINT — Foreign key → event_occurrence.id
- type — VARCHAR(30) — NOT NULL
- channel — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- retry_count — INT — NOT NULL
- sent_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
outbox_event
- id — BIGSERIAL — Primary key — NOT NULL
- aggregate_type — VARCHAR(50) — NOT NULL
- aggregate_id — BIGINT — NOT NULL
- event_type — VARCHAR(50) — NOT NULL
- payload — JSONB — NOT NULL
- is_published — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- published_at — TIMESTAMPTZ
rsvp
- id — BIGSERIAL — Primary key — NOT NULL
- occurrence_id — BIGINT — Foreign key → event_occurrence.id — NOT NULL
- user_id — BIGINT — Foreign key → app_user.id — NOT NULL
- status — VARCHAR(24) — NOT NULL
- responded_at — TIMESTAMPTZ
- idempotency_key — VARCHAR(64)
- reconfirm_required — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
schedule_change_log
- id — BIGSERIAL — Primary key — NOT NULL
- occurrence_id — BIGINT — Foreign key → event_occurrence.id — NOT NULL
- changed_by — BIGINT — Foreign key → app_user.id — NOT NULL
- change_type — VARCHAR(20) — NOT NULL
- old_value — TEXT
- new_value — TEXT
- changed_at — TIMESTAMPTZ — NOT NULL
share_link
- id — BIGSERIAL — Primary key — NOT NULL
- event_id — BIGINT — Foreign key → event.id — NOT NULL
- token — VARCHAR(64) — NOT NULL
- expires_at — TIMESTAMPTZ
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
todo
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → app_user.id — NOT NULL
- category_id — BIGINT — Foreign key → todo_category.id
- title — VARCHAR(200) — NOT NULL
- memo — TEXT
- start_at — TIMESTAMPTZ
- due_at — TIMESTAMPTZ
- priority — VARCHAR(10)
- is_done — BOOLEAN — NOT NULL
- completed_at — TIMESTAMPTZ
- is_recurring — BOOLEAN — NOT NULL
- rrule — VARCHAR(500)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
todo_category
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → app_user.id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- color — VARCHAR(20)
- created_at — TIMESTAMPTZ — NOT NULL
user_oauth
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → app_user.id — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_uid — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL