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