ONFFLine
Tables (5)
chatLog
- chat_idx — INT — Primary key — NOT NULL
- msg — VARCHAR(300)
- msgTime — DATETIME
- nickname — VARCHAR(15)
custom
- u_jd (u_id) — VARCHAR(15) — Foreign key → user.u_jd — NOT NULL
- hairStyle — INT
- hairColor — INT
- skinColor — INT
- eyesColor — INT
meetingRoom
- r_id — INT — Primary key — NOT NULL
- is_Active — BOOLEAN
- creator — VARCHAR(15)
- createTime — DATETIME
participants
- r_id — INT — Foreign key → meetingRoom.r_id — NOT NULL
- u_jd (u_id) — VARCHAR(15) — Foreign key → user.u_jd — NOT NULL
- nickname — VARCHAR(15)
user
- u_jd (u_id) — VARCHAR(15) — Primary key — NOT NULL
- u_type — INT
- nickname (nickName) — VARCHAR(15)
- pw — VARCHAR(15)