cafe
Tables (5)
CAFE
- cafe_id — INT
- user_id — INT — NOT NULL
- cafe_name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- business_number — VARCHAR(20) — NOT NULL
CATEGORY
- category_id — INT
- cafe_id — INT — NOT NULL
- name — VARCHAR(50) — NOT NULL
MENU
- menu_id — INT
- cafe_id — INT — NOT NULL
- category_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- price — INT — NOT NULL
- is_available — TINYINT — NOT NULL
ORDERS
- order_id — INT
- user_id — INT — NOT NULL
- cafe_id — INT — NOT NULL
- status — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
USER (사용자)
- user_id (사용자 식별자) — Primary key — NOT NULL — autoincrement
- user_type (유저 종류(관리자/유저)) — NOT NULL — 관리자는 1 유저는 0
- password (사용자 비밀번호) — NOT NULL
- nickname (사용자 닉네임) — NOT NULL
- phone (사용자 전화버호) — NOT NULL
- business_number (사업자 번호) — 선택입력
- birth (생년월일) — NOT NULL