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