첫손님서비스

테이블 (7)

promotion_offers (이벤트 제공내역) (offers)

  • ID — INT — 기본 키
  • promotion_id — INT — NOT NULL
  • restaurants_id — INT
  • user_id — INT
  • promitions_title — VARCHAR(100) — NOT NULL
  • quantity — INT — NOT NULL
  • price (pirce) — INT

promotions(지금오면 이벤트) (promotions)

  • ID — INT — 기본 키
  • restaurant_id — INT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • details — LONGTEXT — NOT NULL
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL
  • quantity — INT
  • price — INT
  • created_at — DATETIME

promotions_accept(지금오면 이벤트수락 목록) (promotions_accept)

  • ID — INT — 기본 키
  • restaurant_id — INT — NOT NULL
  • promotions_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • visit — char(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

restaurants(음식점) (restaurants)

  • ID — INT — 기본 키
  • name — VARCHAR(100) — NOT NULL
  • description — LONG TEXT
  • address — VARCHAR(255) — NOT NULL
  • latitude — DECIMAL(10, 8) — NOT NULL
  • longitude — DECIMAL(11, 8) — NOT NULL
  • phone_number — VARCHAR(20)
  • restaurants_number — VARCHAR(20)
  • created_at — DATETIME

user_locations(회원 위치) (user_locations)

  • ID — INT — 기본 키
  • user_id — INT — NOT NULL
  • latitude — DECIMAL(10, 8) — NOT NULL
  • longitude — DECIMAL(11, 8) — NOT NULL
  • recorded_at — DATETIME — NOT NULL

users(회원) (users)

  • ID — INT — 기본 키
  • user_login — VARCHAR(100)
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(20)
  • created_at — DATETIME — NOT NULL

visits(방문기록) (visits)

  • ID — INT — 기본 키
  • user_id — INT — NOT NULL
  • restaurant_id — INT — NOT NULL
  • visit_time — DATETIME — NOT NULL