project1

Tables (8)

burger (Untitled)

  • menu_num (Key) — int — Primary key — NOT NULL — AUTO_INCREMENT
  • type_num (Key2) — int — Foreign key → menu_type.type_num — NOT NULL — AUTO_INCREMENT
  • name (Field) — char(20) — NOT NULL
  • size (Field2) — int(2) — NOT NULL — 사이즈 존재 유무
  • image (Field3) — BLOB — NOT NULL

cold drink (Untitled2)

  • menu_num (Key) — int — Primary key — NOT NULL — AUTO_INCREMENT
  • type_num (Key2) — int — Foreign key → menu_type.type_num — NOT NULL — AUTO_INCREMENT
  • name (Field) — char(20) — NOT NULL
  • size (Field2) — int(2) — NOT NULL — 사이즈 존재 유무
  • image (Field3) — BLOB — NOT NULL

desert (Untitled3)

  • menu_num (Key) — int — Primary key — NOT NULL — AUTO_INCREMENT
  • type_num (Key2) — int — Foreign key → menu_type.type_num — NOT NULL — AUTO_INCREMENT
  • name (Field) — char(20) — NOT NULL
  • size (Field2) — int(2) — NOT NULL — 사이즈 존재 유무
  • image (Field3) — BLOB — NOT NULL

menu_type

  • type_num (Key) — int — Primary key — NOT NULL — AUTO_INCREMENT
  • type_name (Field) — char(20) — NOT NULL — burger, drink, desert, etc..

receipt (Untitled5)

  • re_num (Key) — int — Primary key — NOT NULL — AUTO_INCREMENT
  • menu (Field) — text — NOT NULL — 주문한 메뉴 TEXT형식으로 저장
  • price (Field2) — int — NOT NULL
  • time (Field3) — time — NOT NULL — 주문한 시간 저장

size_price (Untitled4)

  • menu_num (Key2) — int — Foreign key → cold drink.menu_num — NOT NULL — AUTO_INCREMENT
  • type_num (Key22) — int — Foreign key → cold drink.type_num — NOT NULL — AUTO_INCREMENT
  • S (Field) — int — s사이즈 가격
  • M (Field2) — int — m사이즈 가격
  • L (Field3) — int — l사이즈 가격

size_price (CopyOfUntitled4)

  • menu_num (Key) — int — Foreign key → burger.menu_num — NOT NULL — AUTO_INCREMENT
  • type_num (Key2) — int — Foreign key → burger.type_num — NOT NULL — AUTO_INCREMENT
  • S (Field) — int — s사이즈 가격
  • M (Field2) — int — m사이즈 가격
  • L (Field3) — int — l사이즈 가격

size_price (CopyOfCopyOfUntitled4)

  • menu_num (Key) — int — Foreign key → desert.menu_num — NOT NULL — AUTO_INCREMENT
  • type_num (Key2) — int — Foreign key → desert.type_num — NOT NULL — AUTO_INCREMENT
  • S (Field) — int — s사이즈 가격
  • M (Field2) — int — m사이즈 가격
  • L (Field3) — int — l사이즈 가격