논리적설계

테이블 (9)

Untitled

  • Key — 기본 키 — NOT NULL
  • Key2 — 기본 키 — NOT NULL
  • Field
  • Field2

Untitled2

  • Key — 기본 키 — NOT NULL
  • Key2 — 기본 키 — NOT NULL
  • Field
  • Field2
  • Key (Key3) — 외래 키 → Untitled.Key — NOT NULL
  • Key2 (Key22) — 외래 키 → Untitled.Key2 — NOT NULL

business

  • bus_name — varchar(20)
  • bus_man — varchar(20)
  • bus_num — varchar(20)

cstomer

  • name — char(20)
  • password — int(10)
  • number — varchar(20)
  • mail — varchar(20)
  • rating — varchar(20)

menu_coffee

  • menu_num — INT
  • coffee — VARCHAR(255)
  • price — INT(10)
  • manufacturer — VARCHAR(100)
  • stock — INT(10)

menu_desert

  • menu_num — INT
  • desert — VARCHAR(255)
  • price — INT(10)
  • buisiness — VARCHAR(100)
  • stock — INT(10)

menu_drink

  • menu_num — INT
  • drink — VARCHAR(255)
  • price — INT(10)
  • buisiness — VARCHAR(100)
  • stock — INT(10)

orders

  • order_id — char(20)
  • name — char(20)
  • amount — int

stock

  • stock_no — int(10)
  • coffee_total — varchar(20)
  • drink_total — varchar(20)
  • dessert_total — varchar(20)