Re-dish

Tables (9)

Container Inventory (다회용기 재고 정보)

  • ContainerType (Field) — VARACHAR(255) — NOT NULL
  • ContainerNum (Field2) — INT — NOT NULL

Container Order (CopyOfUntitled2)

  • ID (Field7) — VARACHAR(255) — Foreign key → Restaurant.ID — NOT NULL
  • RestaurantID (Field2) — BIGINT — NOT NULL
  • ContainerType (Field4) — VARACHAR(255) — NOT NULL
  • ContainerNum (Field5) — INT — NOT NULL
  • TotalPrice (Field6) — INT — NOT NULL
  • RestaurantInventory (Field) — INT — NOT NULL
  • RedishInventory (Field3) — INT — NOT NULL
  • RestaurantAddress (Field8) — VARCHAR(255) — NOT NULL

Customer (고객 정보)

  • ID (Field) — VARACHAR(255) — Primary key — NOT NULL
  • Password (Field2) — VARACHAR(255) — NOT NULL
  • Name (Field3) — VARACHAR(255) — NOT NULL
  • PhoneNum (Field4) — VARACHAR(255) — NOT NULL
  • DeliverAddress (Field5) — VARACHAR(255) — NOT NULL

Food Order (Untitled2)

  • ID (Field11) — VARACHAR(255) — Foreign key → Customer.ID — NOT NULL
  • MenuID (Field) — BIGINT — NOT NULL
  • RestaurantID (Field2) — BIGINT — NOT NULL
  • CustomerID (Field3) — BIGINT — NOT NULL
  • ContainerType (Field4) — VARACHAR(255) — NOT NULL
  • ContainerNum (Field5) — INT — NOT NULL
  • TotalPrice (Field6) — INT — NOT NULL
  • RestaurantInventory (Field8) — INT — NOT NULL
  • RedishInventory (Field9) — INT — NOT NULL
  • DeliverAddress (Field10) — VARCHAR(255) — NOT NULL

Menu (Untitled)

  • ID (Field7) — VARACHAR(255) — Foreign key → Restaurant.ID — NOT NULL
  • RestaurantID (Field2) — BIGINT — NOT NULL
  • Name (Field3) — VARACHAR(255) — NOT NULL
  • Price (Field4) — INT — NOT NULL
  • ContainerType (Field5) — VARACHAR(255) — NOT NULL
  • Status (Field6) — VARACHAR(255) — NOT NULL

Mypage (Untitled3)

  • UserID (Field) — String — NOT NULL
  • Point (Field2) — Float — NOT NULL
  • Usage (Field3) — INT — NOT NULL

PickUp (Untitled4)

  • ID (Field11) — VARACHAR(255) — Foreign key → Food Order.ID — NOT NULL
  • CustomerID (Field) — VARACHAR(255) — NOT NULL
  • DeliverAddress (Field2) — VARACHAR(255) — NOT NULL
  • Image (Field3) — VARACHAR(255) — NOT NULL
  • ContainerType (Field6) — VARACHAR(255) — NOT NULL
  • ContainerNum (Field7) — INT — NOT NULL
  • ContainerStatus (Field5) — VARACHAR(255) — NOT NULL
  • EmployeeID (Field4) — VARACHAR(255)

Redish Employee (관리자 정보)

  • Key — VARACHAR(255) — Primary key — NOT NULL
  • Password (Field2) — VARACHAR(255) — NOT NULL
  • Name (Field3) — VARACHAR(255) — NOT NULL
  • PhoneNum (Field4) — VARACHAR(255) — NOT NULL
  • Department (Field5) — VARACHAR(255) — NOT NULL

Restaurant (가게 정보)

  • ID (Field) — VARACHAR(255) — Primary key — NOT NULL
  • Password (Field2) — VARACHAR(255) — NOT NULL
  • Name (Field3) — VARACHAR(255) — NOT NULL
  • PhoneNum (Field4) — VARACHAR(255) — NOT NULL
  • BusinessNumber (Field6) — VARACHAR(255) — NOT NULL
  • RestaurantAddress (Field5) — VARACHAR(255) — NOT NULL