배달의 민족 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