delivery
Tables (5)
Item (item)
- itemId (Key) — Long — Primary key — NOT NULL
- name (Field) — string
- amount (Field2) — int
- price (Field3) — int
- image_url (Field4) — string
- created_time (Field5) — DateTime
- category (Field6) — enum
- store (Field7) — string
Member (member)
- memberId (Key) — Long — Primary key — NOT NULL
- name (Field2) — String
- address (Field3) — string
- email (Field) — string
- password (Field4) — string
- nickname (Field5) — string
Orders (orders)
- orderId (Key) — Long — Primary key — NOT NULL
- memberId (Key2) — Long — Foreign key → Member.memberId — NOT NULL
- orderItems (Field2) — List
- status (Field) — Enum
- date (Key3) — DateTime — NOT NULL
Orders_has_Item
- OrderItemId (Key) — Long — Primary key — NOT NULL
- orderId (Key2) — Long — Foreign key → Orders.orderId — NOT NULL
- itemId (Key3) — Long — Foreign key → Item.itemId — NOT NULL
address_book
- addressId (Key) — Long — Primary key — NOT NULL
- memberId (Key2) — Long — Foreign key → Member.memberId — NOT NULL
- zip_code (Field) — int
- address (Field2) — string