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