couphone

테이블 (4)

couphone

  • Key (couphone_id) — int unsigned — 기본 키 — NOT NULL
  • Key (store_id) — int unsigned — 외래 키 → store.Key — NOT NULL
  • (content) — varchar(300)

couphone_log

  • Key (couphone_log_id) — int unsigned — 기본 키 — NOT NULL
  • user_id — int unsigned — 외래 키 → 사용자.user_id — NOT NULL
  • Key (store_id) — int unsigned — 외래 키 → store.Key — NOT NULL
  • count — int unsigned
  • deleted_at — TIMESTAMP
  • created_at — TIMESTAMP

store

  • Key (store_id) — int unsigned — 기본 키 — NOT NULL
  • logo — varchar(200)
  • name — varchar(50)
  • category — varchar(50)
  • address — varchar(200)
  • created_at — TIMESTAMP
  • deleted_at — TIMESTAMP

사용자 (user)

  • user_id — int unsigned — 기본 키 — NOT NULL
  • user_name — varchar(50)
  • phone_number — varchar(50)
  • password — varchar(100)
  • created_at — TIMESTAMP
  • deleted_at — TIMESTAMP