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