maifia_test

Tables (7)

ITEM (아이템)

  • ITEM_ID (Key) — NUMBER — Primary key — NOT NULL
  • ITEM_NAME (Field) — VARCHAR2(50)
  • EFFECT (Field2) — VARCHAR2(50)

JOB (직업)

  • JOB_ID (Key) — NUMBER — Primary key — NOT NULL
  • JOB_NAME (Field) — VARCAHR2(20)
  • JOB_SKILL (Field2) — VARCHAR2(30)

JOB_ITEM (직업_아이템)

  • JOB_ID (Key) — VARCHAR2(1) — Foreign key → JOB.JOB_ID — NOT NULL
  • ITEM_ID (Key2) — NUMBER — Foreign key → ITEM.ITEM_ID — NOT NULL

ROOM (게임 방)

  • ROOM_ID (Key) — NUMBER — Primary key — NOT NULL
  • ROOM_NAME (Field) — VARCHAR2(30)
  • STATUS (Field2) — VARCHAR2(3)

USER (유저)

  • USER_NO (Key2) — NUMBER — Primary key — NOT NULL
  • USER_ID (Field6) — VARCHAR2(10)
  • USER_PWD (Field) — VARCHAR2(30)
  • USER_LEVEL (Field2) — NUMBER
  • USER_EXP (Field3) — NUMBER
  • USER_GAME_MONEY (Field4) — NUMBER
  • USER_CASH (Field5) — NUMBER
  • ROOM_ID (Key) — NUMBER — Foreign key → ROOM.ROOM_ID — NOT NULL
  • WIN_COUNT (Field7) — NUMBER
  • PLAY_TIMES (Field8) — NUMBER

USER_ITEM (유저_아이템)

  • ITEM_ID (Key2) — NUMBER — Foreign key → ITEM.ITEM_ID — NOT NULL
  • Key2 (Key22) — Foreign key → USER.USER_NO — NOT NULL

USER_JOB_STATS (유저 직업별 승률)

  • USER_NO (Key2) — NUMBER — Foreign key → USER.USER_NO — NOT NULL
  • JOB_ID (Key) — NUMBER — Foreign key → JOB.JOB_ID — NOT NULL