ddd

Tables (4)

CART (Untitled3)

  • CUSTOMER_CODE (Key) — Foreign key → CUSTOMER.ID — NOT NULL
  • ITEM_CODE (Key2) — Foreign key → ITEM.CODE — NOT NULL
  • ITEM_QT (Field3)
  • TOTAL_PRICE (Field)

CUSTOMER (Untitled4)

  • ID (Key) — Primary key — NOT NULL
  • PWD (Field)
  • NAME (Field2)
  • ADRESS (Field3)
  • PHONE (Field5)
  • POINT (Field4)
  • Email (Field6)

ITEM (Untitled2)

  • CODE (Key) — Primary key — NOT NULL
  • NAME (Field)
  • PRICE (Field2)
  • STOCK (Field3) — 재고
  • CATEGORY (Field4)

ORDER (Untitled)

  • ORDER_CODE (Key) — Primary key — NOT NULL
  • CUSTOMER_CODE (Key2) — Foreign key → CART.CUSTOMER_CODE — NOT NULL
  • ITEM_CODE (Key22) — Foreign key → CART.ITEM_CODE — NOT NULL
  • ORDERDATE (Field2) — 시킨날
  • STATUS (Field)