CoffeeOrder

Tables (8)

Bean (원두테이블)

  • BeanSeq (PK) — number — Primary key — NOT NULL
  • BeanName (Field) — varchar2(40)
  • Price (Field2) — number

ExtraMenu (추가주문테이블)

  • ExtraSeq (PK) — number — Primary key — NOT NULL
  • ExtraName (Field) — varchar2(40)
  • Price (Field2) — number

Menu (메뉴테이블)

  • MenuSeq (PK) — number — Primary key — NOT NULL
  • MenuName (Field) — varchar2(40)
  • Price (Field2) — number

OrderExtra (주문테이블(메뉴+원두+추가))

  • OrderSeq (OFK) — number — Foreign key → OrderMenu.MenuSeq — NOT NULL
  • ExtraSeq (EFK) — number — Foreign key → ExtraMenu.ExtraSeq — NOT NULL

OrderMenu (주문테이블(메뉴+원두))

  • OrderSeq (PK) — number — Primary key — NOT NULL
  • MenuSeq (MFK) — number — Foreign key → Menu.MenuSeq — NOT NULL
  • BeanSeq (BFK) — number — Foreign key → Bean.BeanSeq — NOT NULL

Untitled10

  • OrderSeq (OMFK) — number — Foreign key → OrderMenu.OrderSeq — NOT NULL
  • TotalPrice (Field) — number

beanmenu (Untitled2)

  • bean_seq (Key) — number — Primary key — NOT NULL
  • bean_name (Field) — varchar2(40)
  • bean_price (Field2) — number

extramenu (Untitled3)

  • extra_seq (Key) — number — Primary key — NOT NULL
  • extra_name (Field) — varchar2(40)
  • extra_price (Field2) — number