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