needU

Tables (4)

terms

  • id — UUID — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content_url — TEXT
  • required — BOOLEAN — NOT NULL
  • active — BOOLEAN — NOT NULL
  • effective_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

user_sessions

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • refresh_token_hash — VARCHAR(128) — NOT NULL
  • device_id — VARCHAR(255)
  • user_agent — TEXT
  • ip_address — INET
  • expires_at — TIMESTAMPTZ — NOT NULL
  • last_used_at — TIMESTAMPTZ
  • revoked_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

user_term_agreements

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • term_id — UUID — Foreign key → terms.id — NOT NULL
  • agreed_at — TIMESTAMPTZ — NOT NULL
  • revoked_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

users

  • id — UUID — Primary key — NOT NULL
  • kakao_user_id — VARCHAR(64) — NOT NULL
  • email — VARCHAR(320)
  • email_verified — BOOLEAN — NOT NULL
  • nickname — VARCHAR(50)
  • profile_image_url — TEXT
  • status — VARCHAR(20) — NOT NULL
  • signup_completed_at — TIMESTAMPTZ
  • last_login_at — TIMESTAMPTZ
  • kakao_unlinked_at — TIMESTAMPTZ
  • withdrawn_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL