Computer network 1

Tables (8)

Francchi (Untitled3)

  • francchi id — Not Null — Primary key — NOT NULL
  • menu id — Not Null
  • addr
  • phone number
  • search tag
  • Full-checker
  • type — NOT NULL

Menu (Untitled4)

  • menu id — Not Null — Primary key — NOT NULL
  • francchi id — Not Null — Foreign key → Francchi.francchi id — NOT NULL
  • menu img (menu imgi)
  • product id (products) — Not Null

Order (Untitled2)

  • order id — Not Null — Primary key — NOT NULL
  • user id — Not Null — Foreign key → User.user id
  • francchi id — Not Null — Foreign key → Francchi.francchi id — NOT NULL
  • review id
  • order products id
  • order status

Product (Untitled5)

  • product id — Not Null — Primary key — NOT NULL
  • menu id — Not Null — Foreign key → Menu.menu id — NOT NULL
  • francchi id — Not Null — Foreign key → Menu.francchi id — NOT NULL
  • product img
  • price — Not Null
  • Regular Option

Regular Option (Untitled8)

  • product id — Not Null — Foreign key → Product.product id — NOT NULL
  • menu id — Not Null — Foreign key → Product.menu id — NOT NULL
  • francchi id — Not Null — Foreign key → Product.francchi id — NOT NULL
  • Option (Option 1)

Review (Untitled6)

  • review idr (review id) — Not Null — Primary key — NOT NULL
  • order id — Not Null — Foreign key → Order.order id — NOT NULL
  • user id
  • francchi id
  • 별점 - 맛
  • 별점 - 분위기
  • 별점 - 만족도

User (Untitled)

  • user id — Not Null — Primary key
  • phone number
  • Field

order products (Untitled7)

  • order products id — Primary key — NOT NULL
  • order id — Not Null — Foreign key → Order.order id — NOT NULL
  • product id
  • product number
  • Regular Options
  • Additional Option