goott

Tables (7)

CATEGORY (Untitled4)

  • CATEGORY_ID — varchar — Primary key — NOT NULL
  • NAME — varchar

CATEGORY_ITEM (Untitled5)

  • CATEGORY_ID — varchar — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
  • ITEM_ID — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL

DELIVERY (Untitled2)

  • DELIVERY_ID — varchar — Primary key — NOT NULL
  • CITY — varchar
  • STREET — varchar
  • ZIPCODE — number
  • STATUS — varchar

ITEM (Untitled6)

  • ITEM_ID — varchar — Primary key — NOT NULL
  • NAME — varchar
  • PRICE — number
  • STOCKQUANTITY — number

MEMBER (ID)

  • MEMBER_ID (MID) — varchar — Primary key — NOT NULL
  • NAME (Field2) — varchar
  • CITY — varchar
  • STREET — varchar
  • ZIPCODE — NUMBER

ORDERS (Untitled)

  • ORDER_ID (OID) — varchar — Primary key — NOT NULL
  • MEMBER_ID (MID) — varchar — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • DELIVERY_ID — varchar — Foreign key → DELIVERY.DELIVERY_ID — NOT NULL
  • ORDERDATE — DATE
  • STATUS — varchar

ORDER_ITEM_ID (Untitled3)

  • ORDER_ITEM_ID (OITEM) — varchar — Primary key — NOT NULL
  • ORDER_ID (OID) — varchar — Foreign key → ORDERS.ORDER_ID — NOT NULL
  • ITEM_ID — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL
  • ORDERPRICE — number
  • COUNT — number