database-project
Tables (6)
menus
- menu_id — BIGINT(20) — Primary key — NOT NULL
- store_id — BIGINT(20) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- category — VARCHAR(100) — NOT NULL
- status — VARCHAR(255) — NOT NULL — 영업 상태
- price — INT(11) — NOT NULL
- createdDate — TIMESTAMP — NOT NULL
order_menus
- order_menu_id — BIGINT(20) — Primary key — NOT NULL
- order_id — BIGINT(20) — NOT NULL
- menu_id — BIGINT(20) — NOT NULL
- user_id — BIGINT(20) — NOT NULL
- store_id — BIGINT(20) — NOT NULL
- quantity — INT(11) — NOT NULL
- createdDate — TIMESTAMP — NOT NULL
orders
- order_id — BIGINT(20) — Primary key — NOT NULL
- store_id — BIGINT(20) — NOT NULL
- user_id — BIGINT(20) — NOT NULL
- total_price — INT(11) — NOT NULL
- status — VARCHAR(255) — NOT NULL
- createdDate — TIMESTAMP — NOT NULL
reviews
- review_id — BIGINT(20) — Primary key — NOT NULL
- store_id — BIGINT(20) — NOT NULL
- user_id — BIGINT(20) — NOT NULL
- menu_id — BIGINT(20) — NOT NULL
- rating — INT(1) — NOT NULL
- content — VARCHAR(255) — NOT NULL
- createdDate — TIMESTAMP — NOT NULL
stores
- store_id — BIGINT(20) — Primary key — NOT NULL
- user_id — BIGINT(20) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- category — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- status — VARCHAR(255) — NOT NULL — 영업 상태
- content — VARCHAR(255)
- createdDate — TIMESTAMP — NOT NULL
users
- user_id — BIGINT(20) — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- role — VARCHAR(100) — NOT NULL
- address — VARCHAR(255)
- createdDate — TIMESTAMP — NOT NULL