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)