test
Tables (9)
administrators
- id — BIGINT — Primary key — NOT NULL — auto
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- store — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
call
- id — BIGINT — Primary key — NOT NULL — auto
- table_id — BIGINT — NOT NULL — 테이블
- name — VARCHAR(50) — NOT NULL
- status — VARCHAR(10) — NOT NULL — WAIT
catecory
- id — BIGINT — Primary key — NOT NULL — auto
- name — VARCHAR(20) — NOT NULL
dining_table
- id — BIGINT — Primary key — NOT NULL — 테이블
- status — BOOLEAN — NOT NULL — TRUE:
- calculation — BOOLEAN — NOT NULL — TRUE
menu
- id — BIGINT — Primary key — NOT NULL — auto
- category_id — BIGINT — NOT NULL — auto
- name — VARCHAR(50) — NOT NULL
- detail — VARCHAR(255)
- image — VARCHAR(255)
- price — BIGINT
- status — BOOLEAN — NOT NULL — TRUE:
- created_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
option_group
- id — BIGINT — Primary key — NOT NULL — auto
- menu_id — BIGINT — NOT NULL — auto
- group_name — VARCHAR(100) — NOT NULL
options
- id — BIGINT — Primary key — NOT NULL — auto
- group_id — BIGINT — NOT NULL — auto
- name — VARCHAR(100) — NOT NULL
- extra_price — BIGINT
order_items
- id — BIGINT — Primary key — NOT NULL — auto
- order_id — BIGINT — NOT NULL — auto
- menu_id — BIGINT — NOT NULL — auto
- quantity — INT — NOT NULL
- total — BIGINT
- status — BOOLEAN — NOT NULL — TRUE
orders
- id — BIGINT — Primary key — NOT NULL — auto
- table_id — BIGINT — NOT NULL — 테이블
- total — BIGINT
- created_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP