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)