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