asdf
Tables (3)
Menu ((음식점 메뉴))
- MenuID — String — Primary key — NOT NULL
- ShopID (ID2) — String — Foreign key → Shop.ShopID — NOT NULL
- MenuName (Name) — String
- MenuPrice (Price) — String
Shop ((가게))
- ShopID (ID) — String — Primary key — NOT NULL
- ShopName (Name) — String
- ShopType (type) — String
- OwnerID — String
- ShopInfo — String
- ShopPhoneNum (PhoneNum) — String
- ShopAddress (Address) — String
- ShopRate (rate) — Float
User ((사용자))
- UserID (ID) — String — Primary key — NOT NULL
- UserName (Name) — String
- UserEmail (Email) — String
- UserPassword (password) — Password
- UserPhoneNum (pheoneNum) — String
- UserType (Type) — String
- UserRate (Rate) — Float