cafe
Tables (7)
Cafe
- id — Integer — Primary key — NOT NULL
- cafeNm — Text
- roadAddr — Text
- appOrderYn — Text
- kioskYn — Text
- discountAmt — Integer
Cafe (Untitled)
- cafe_id — Integer — Primary key — NOT NULL
- franchise_id — Integer — Foreign key → Franchise.franchise_id — NOT NULL
- etc... (Field)
Franchise (Untitled2)
- franchise_id — Integer — Primary key — NOT NULL
- etc... (Field)
FranchiseCafe
- id — Integer — Primary key — NOT NULL
- cafeNm — string
- roadAddr — Text
- appOrderYn — Text
- kioskYn — Text
- discountAmt — Integer
FranchiseMenu (CopyOfMenu)
- id — Integer — Foreign key → FranchiseCafe.id — NOT NULL
- menu1 — Text
- price1 — Integer
- menu2 — Text
- price2 — Integer
- menu3 — Text
- price3 — Integer
Menu
- id — Integer — Foreign key → Cafe.id — NOT NULL
- menu1 — Text
- price1 — Integer
- menu2 — Text
- price2 — Integer
- menu3 — Text
- price3 — Integer
Menu (Untitled3)
- menu_id — Integer — Primary key — NOT NULL
- cafe_id — Integer — Foreign key → Cafe.cafe_id — NOT NULL
- franchise_id — Integer — Foreign key → Cafe.franchise_id — NOT NULL
- menu_nm — Text
- menu_price — Integer