모의해킹
테이블 (5)
members
- id — INT — 기본 키 — NOT NULL
- userid — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- birth — VARCHAR(20) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- role — VARCHAR(10) — NOT NULL
- created_at — VARCHAR(20) — NOT NULL
menus
- id — INT — 기본 키 — NOT NULL
- store_id — INT — 외래 키 → stores.id — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — VARCHAR(200) — NOT NULL
- price — INT — NOT NULL
- thumbnail — VARCHAR(100)
orders
- id — INT — 기본 키 — NOT NULL
- store_id — INT — 외래 키 → stores.id — NOT NULL
- menu_id — INT — 외래 키 → menus.id — NOT NULL
- quantity — INT — NOT NULL
- total_price — INT — NOT NULL
- created_at — VARCHAR(20) — NOT NULL
store_sales
- id — INT — 기본 키 — NOT NULL
- store_id — INT — NOT NULL
- member_id — INT — NOT NULL
- account_info — VARCHAR(100) — NOT NULL
- sale_date — VARCHAR(20) — NOT NULL
- settlement_amount — INT — NOT NULL
stores
- id — INT — 기본 키 — NOT NULL
- member_id — INT — 외래 키 → members.id — NOT NULL
- category — VARCHAR(20) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- created_at — VARCHAR(20) — NOT NULL