키오스크제작

테이블 (3)

Mnues (Menus)

  • StoreId (storeId) — VARCHAR(255) — 기본 키 — NOT NULL
  • StoreName (storename) — VARCHAR(255) — 외래 키 → Store.StoreName — NOT NULL
  • StoreId (storeId2) — VARCHAR(225) — 외래 키 → Store.StoreId
  • Name (name) — VARCHAR(100)
  • Price (price) — INT
  • Description (description) — TEXT
  • Image (image_url) — TEXT
  • Category (category) — INT
  • Store_id (store_id) — INT
  • Stock (stock) — Boolean

Store (Untitled2)

  • StoreName (storename) — VARCHAR(255) — 기본 키 — NOT NULL
  • StoreId (storeId) — VARCHAR(225) — 기본 키
  • UserId (userId) — VARCHAR(255) — 외래 키 → User.UserId — NOT NULL
  • Addreass (address) — VARCHAR(255)
  • City (city) — VARCHAR(100)
  • District (district) — VARCHAR(100)
  • Detail_Add (detail_add) — VARCHAR(100)
  • PhoneNumber (phoneNumber)

User (Untitled)

  • UserId (userId) — VARCHAR(255) — 기본 키 — NOT NULL
  • Password (password) — VARCHAR(255)
  • Email (email) — VARCHAR(255)
  • StoreName (storename) — VARCHAR(255)