빵그리(최신)

테이블 (4)

member

  • id — BIGINT
  • email — VARCHAR(255)
  • phone — VARCHAR(11)
  • name — VARCHAR(15)
  • nickname — VARCHAR(20)
  • birth — VARCHAR(10)
  • profile — VARCHAR(255)
  • provider — varchar(20)
  • provider_id — varchar(50)
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)
  • is_deleted — TINYINT

search

  • id — BIGINT
  • member_id — BIGINT — 외래 키 → member.id
  • user_type — VARCHAR(20)
  • is_deleted — tinyint
  • keyword — VARCHAR(255) — NOT NULL
  • created_at — DATETIME(6)

signature_agreement

  • id — BIGINT
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • date_of_signature — DATETIME(6) — NOT NULL
  • agreement_status — TINYINT — NOT NULL

store

  • id — BIGINT
  • identifier — VARCHAR(16) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • introduce — VARCHAR(255)
  • profile — VARCHAR(255)
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)
  • is_deleted — TINYINT