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