JUCIE

Tables (6)

USER

  • userId — INT(10) — Primary key — NOT NULL
  • Field (userEmail) — VARCHAR(200)
  • Field2 (userPwd) — VARCHAR(255)
  • Field
  • Field2 (userName) — VARCHAR(40)
  • Field3 (userRole) — TINYINT(4)
  • Field4 (userCreateDT) — DATETIME
  • Field5 (userDeleteDT) — DATETIME

Untitled (CHATROOM)

  • Key (roomId) — INT(10) — Primary key — NOT NULL
  • Field (roomName) — VARCHAR(40)
  • Field2 (lastMessage) — INT(100)
  • Field3 (lastUpdateDT) — DATETIME
  • Field4 (hostUserId) — INT(10)
  • Field5 (hostUserEmail) — VARCHAR(200)
  • Field (userCount) — INT(20)

Untitled (MESSAGE)

  • Key (messageId) — INT(100) — Primary key — NOT NULL
  • Field
  • Field2 (pubUserId)
  • Field3 (Message)
  • Field2 (laseMessageDT)
  • Field2 (deleteYn)

Untitled (SIGNINRESULT)

  • Key (userId) — Primary key — NOT NULL
  • Field (resultMessage) — TINYINT(4)
  • Field2 (userPwd) — VARCHAR(255)

Untitled

  • Field

Untitled2 (MYROOM)

  • Key (roomId) — INT(10) — Primary key — NOT NULL
  • Field (userId) — INT(10)
  • Field2 (userEmail) — VARCHAR(200)