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