DDD
Tables (7)
CART (Untitled5)
- ID (Key3) — Foreign key → CUSTOMER.ID — NOT NULL
- ITEM_CODE (Key2) — Foreign key → ITEM.ITEM_CODE — NOT NULL
- ITEM_NAME (Field)
- QT (Field2)
- ITEM_PRICE (Field3)
- TOTAL_PRICE (Field4)
CUSTOMER (Untitled3)
- ID (Key) — Primary key — NOT NULL
- PWD (Field)
- ADDRESS (Field2)
- NAME (Field3)
- PHONE (Field4)
- POINT (Field5)
GAME_ITEM (Untitled)
- ID (Key) — Primary key — NOT NULL
- NAME (Field)
- PRICE (Field2)
- REGDATE (Field3)
GAME_USER (사용자)
- ID (아이디) — VARCHAR2(10) — Primary key — NOT NULL
- PWD (암호) — VARCHAR2(20)
- NAME (이름) — VARCHAR2(20)
ITEM (Untitled4)
- ITEM_CODE (Key) — Primary key — NOT NULL
- PRICE (Field2)
- ITEM_NAME (Field)
- ITEM_STOCK (Field3)
ORDER (Untitled6)
- ORDER_NUMBER (Key) — Primary key — NOT NULL
- ITEM_CODE (Key22) — Foreign key → CART.ITEM_CODE — NOT NULL
- ID (Key3) — Foreign key → CART.ID — NOT NULL
- ITEM_NAME (Field2)
- QT (Field4)
- ITEM_PRICE (Field)
- TOTAL_PRICE (Field5)
- ADDRESS (Field6)
- DATE (Field7)
USER_ITEM (Untitled2)
- ID (Key) — Primary key — NOT NULL
- USER_ID (아이디) — VARCHAR2(10) — Foreign key → GAME_USER.ID — NOT NULL
- ITEM_ID (Key2) — Foreign key → GAME_ITEM.ID — NOT NULL
- QT (Field)