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)
Untitled2 (MYROOM)
- Key (roomId) — INT(10) — Primary key — NOT NULL
- Field (userId) — INT(10)
- Field2 (userEmail) — VARCHAR(200)