aaa
Tables (12)
CUSTOMERS
- id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- contact — BIGINT — NOT NULL
- points — BIGINT — NOT NULL
- restaurant — BIGINT — NOT NULL
DISHES
- id — BIGINT — NOT NULL
- restaurant — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- price — BIGINT — NOT NULL
- veganism — TINYINT(1) — NOT NULL
DRINKS
- id — BIGINT — NOT NULL
- restaurant — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- alcoholic — TINYINT(1) — NOT NULL
- milliliters — BIGINT — NOT NULL
- price — BIGINT — NOT NULL
EMPLOYEES
- id — BIGINT — NOT NULL
- restaurant — BIGINT — NOT NULL
- position — VARCHAR(255) — NOT NULL
- salary — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- contact — BIGINT — NOT NULL
- age — BIGINT — NOT NULL
- hire_date — DATE — NOT NULL
- grade — CHAR(255) — NOT NULL
INGREDIENTS
- id — BIGINT — NOT NULL
- supplier — VARCHAR(255) — NOT NULL
- name — BIGINT — NOT NULL
- price — BIGINT — NOT NULL
ORDERS
- id — BIGINT — NOT NULL
- restaurant — BIGINT — NOT NULL
- menu — VARCHAR(255) — NOT NULL
- table — BIGINT — NOT NULL
- order_time — TIMESTAMP — NOT NULL
- payment — VARCHAR(255) — NOT NULL
- price — BIGINT — NOT NULL
PURCHASES
- id — BIGINT — NOT NULL
- restautant — BIGINT — NOT NULL
- stock_id — BIGINT — NOT NULL
- quantity — BIGINT — NOT NULL
- supplier — VARCHAR(255) — NOT NULL
R-TABLES
- id — BIGINT — NOT NULL
- restaurant — BIGINT — NOT NULL
- capacity — BIGINT — NOT NULL
- active — TINYINT(1) — NOT NULL
RESERVATIONS
- id — BIGINT — NOT NULL
- restaurant — BIGINT — NOT NULL
- customer — BIGINT — NOT NULL
- date — DATE — NOT NULL
- time — TIME — NOT NULL
- guests_number — BIGINT — NOT NULL
- table — BIGINT — NOT NULL
RESTAURANTS
- id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- contact — BIGINT — NOT NULL
- location — BIGINT — NOT NULL
- category — VARCHAR(255) — NOT NULL
- user_id — BIGINT — NOT NULL
STOCKS
- id — BIGINT — NOT NULL
- restaurant — BIGINT — NOT NULL
- name — BIGINT — NOT NULL
- quantity — BIGINT — NOT NULL
USERS
- id — BIGINT — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- user_pw — VARCHAR(255) — NOT NULL
- user_name — VARCHAR(255) — NOT NULL