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