IMI CHATTING-SERVER
Tables (4)
EMOTICION (이모티콘)
- id (prviate) — INTEGER — Primary key — NOT NULL
- file (Field) — VARCHAR
- width (Field2) — FLOAT
- height (Field3) — FLOAT
- price (Field4) — INTGER
- createdAt (Field5) — DATE
- updatedAt (Field6) — DATE
MESSASGE (메세지)
- id (Key) — INTEGER — Primary key — NOT NULL
- roomid (Key2) — INTEGER — Foreign key → ROOM.id — NOT NULL
- userid (Key3) — INTEGER — Foreign key → USER.id — NOT NULL
- contents (Field) — VARCHAR
- files (Field2) — JSON
- isRead (Field3) — BOOELAN
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
ROOM (채팅방)
- id (Key) — INTEGER — Primary key — NOT NULL
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
- senderid (Key2) — Foreign key → USER.id — NOT NULL
- reciverid (Key3) — Foreign key → USER.id — NOT NULL
USER (회원(TEST-기존회원으로 변경예정))
- id (Key) — Primary key — NOT NULL