ddd

Tables (3)

GAME_ITEM (아이템)

  • 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)

USER_ITEM (Untitled)

  • 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