첫손님서비스
테이블 (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