Database Assignment

Tables (10)

Cart

  • cartMemberNumber (Key) — number — Foreign key → Member.memberNumber — NOT NULL
  • totalAmount (Field) — decimal
  • paymentType (Field2) — enum

CartMenu

  • cartMemberNumber (Key3) — number — Foreign key → Cart.cartMemberNumber — NOT NULL
  • menuNumber (Key) — number — Foreign key → Menu.menuNumber
  • shopNumber (Key2) — number — Foreign key → Menu.shopNumber — NOT NULL
  • amount (Field) — decimal
  • count (Field2) — number

Delivery

  • orderNumber (Key) — number — Foreign key → Order.orderNumber — NOT NULL
  • cartMemberNumber (Key2) — number — Foreign key → Order.cartMemberNumber — NOT NULL
  • riderNumber (Key3) — number — Foreign key → Rider.riderNumber — NOT NULL
  • deliveryStartTime (Field)
  • deliveryEndTime (Field2)

Member

  • memberNumber (Key) — number — Primary key — NOT NULL
  • memberId (Field) — string
  • phoneNumber (Field2) — string
  • address (Field3) — string

Menu

  • menuNumber (Key) — number — Primary key
  • shopNumber (Key2) — number — Foreign key → Shop.shopNumber — NOT NULL
  • menuName (Field) — string
  • amount (Field2) — decimal
  • description (Field3) — string

Order

  • orderNumber (Key) — number — Primary key — NOT NULL
  • cartMemberNumber (Key2) — number — Foreign key → Cart.cartMemberNumber — NOT NULL
  • finalTotalAmount (Field) — decimal
  • finalPaymentType (Field2) — enum

OrderMenu

  • menuNumber (Key) — number — Primary key
  • shopNumber (Key2) — number — Primary key
  • orderNumber (Key3) — number — Foreign key → Order.orderNumber — NOT NULL
  • cartMemberNumber (Key4) — number — Foreign key → Order.cartMemberNumber — NOT NULL
  • amount (Field) — decimal
  • count (Field2) — number

Review

  • memberNumber (Key) — number — Foreign key → Member.memberNumber — NOT NULL
  • shopNumber (Key2) — number — Foreign key → Shop.shopNumber — NOT NULL
  • rating (Field) — number
  • description (Field2) — string

Rider

  • riderNumber (Key) — number — Primary key — NOT NULL
  • phoneNumber (Field) — string
  • address (Field2) — string
  • riderName (Field3) — string

Shop

  • shopNumber (Key) — number — Primary key — NOT NULL
  • shopName (Field) — string
  • phoneNumber (Field2) — string
  • address (Field3) — string