Memberinfo

Tables (7)

CATEGORY (Untitled5)

  • CATEGORY_ID (category_id) — varchar — Primary key — NOT NULL
  • PARENT_ID (parent_id) — varchar
  • NAME (name) — varchar

CATEGORY_ITEM (Untitled7)

  • Field2
  • Field
  • CATEGORY_ID (category_id) — varchar — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
  • ITEM_ID (item_id) — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL

DELIVERY (Untitled3)

  • DELIVERY_ID — varchar — Primary key — NOT NULL
  • CITY (city) — varchar
  • STREET (street) — varchar
  • ZIPCODE (zipcode) — varchar
  • STATUS (status) — varchar

ITEM (Untitled6)

  • ITEM_ID (item_id) — varchar — Primary key — NOT NULL
  • NAME (name) — varchar
  • PRICE (price) — varchar
  • STOCKQUANTITY (stockquantity) — varchar

MEMBER_ID (Untitled)

  • MEMBER_ID (member_id) — varchar — Primary key — NOT NULL
  • NAME — varchar
  • CITY (city) — varchar
  • STREET (street) — varchar
  • ZIPCODE (zipcode) — varchar

ORDERS_ID (Untitled2)

  • ORDER_ID (order_id) — varchar — Primary key — NOT NULL
  • ORDERDATE (orderdate) — date
  • STATUS (status) — varchar
  • MEMBER_ID (member_id) — varchar — Foreign key → MEMBER_ID.MEMBER_ID — NOT NULL
  • DELIVERY_ID — varchar — Foreign key → DELIVERY.DELIVERY_ID — NOT NULL

ORDER_ITEM (Untitled4)

  • ORDER_ITEM (order_item) — varchar — Primary key — NOT NULL
  • ORDER{RICE (orderprice) — num
  • COUNT (count) — vatchar
  • ORDER_ID (order_id) — varchar — Foreign key → ORDERS_ID.ORDER_ID — NOT NULL
  • ITEM_ID (item_id) — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL