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