todo
Tables (6)
menu
- id — BIGINT — Primary key
- store_id — BIGINT — Foreign key → store.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- price — INT — NOT NULL
- describe — VARCHAR(255)
- is_deleted — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
order
- id (유저식별자) — BIGINT — Primary key
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- menu_id — BIGINT — Foreign key → menu.id — NOT NULL
- status — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
owner
- id — BIGINT — Primary key
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
review
- id (Key) — BIGINT — Primary key — NOT NULL
- order_id (유저식별자) — BIGINT — Foreign key → order.id
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- comment — VARCHAR(255) — NOT NULL — ARCHAR(255) NOT NUL
- rate — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
store
- id — BIGINT — Primary key
- owner_id — BIGINT — Foreign key → owner.id
- store_name — VARCHAR(255) — NOT NULL
- min_price — INT — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- open_time — TIME — NOT NULL
- close_time — TIME — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user
- id — BIGINT — Primary key
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL