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)