배달의 민족 ERD
테이블 (6)
phone_verifications
- Id — BIGINT — 기본 키 — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- send_number — VARCHAR(10) — NOT NULL
- verification_code — VARCHAR(10) — NOT NULL
- remaining_attempts — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- auth_token — VARCHAR(255)
- expire_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
receive_options
- id — BIGINT — 기본 키
- term_id — VARCHAR(50) — 외래 키 → terms.term_id — NOT NULL
- version — VARCHAR(20) — 외래 키 → terms.version — NOT NULL
- option_type — VARCHAR(20) — NOT NULL
- is_required — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
terms
- term_id — VARCHAR(50) — 기본 키 — NOT NULL
- version — VARCHAR(20) — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- is_required — BOOLEAN — NOT NULL
- link — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user_receive_options
- Id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.Id — NOT NULL
- receive_option_id — BIGINT — 외래 키 → receive_options.id
- is_agreed — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user_terms_agreements
- Id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.Id — NOT NULL
- term_id (term_id2) — VARCHAR(50) — 외래 키 → terms.term_id — NOT NULL
- version (version2) — VARCHAR(20) — 외래 키 → terms.version — NOT NULL
- is_agreed — BOOLEAN — NOT NULL
- agreed_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
users
- Id — BIGINT — 기본 키 — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- birth_date — DATE — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL