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