baggum

Tables (4)

ChatHistory (Untitled4)

  • id (Key) — Integer — Primary key — NOT NULL
  • id (userId) — Integer — Foreign key → User.id — NOT NULL
  • id (roomId) — Integer — Foreign key → Room.id — NOT NULL
  • content (채팅 내역) — text
  • createDate (전송 시각) — Datetime

Room (Untitled2)

  • id (Key) — Integer — Primary key — NOT NULL
  • name (이름) — String
  • createdDate (생성 날짜) — Date
  • isActive (활성화 여부) — Bool

User (Untitled)

  • id (Key) — Integer — Primary key — NOT NULL
  • name (이름) — String
  • email (이메일) — String
  • password (비밀번호) — String
  • lastname (성) — String
  • role (권한) — Integer
  • image (프로필 사진) — String
  • token (토큰) — String
  • tokenExp (토큰 만료일) — Integer

UserRoomMapping (Untitled3)

  • id (Key) — Integer — Primary key — NOT NULL
  • id (roomId) — Integer — Foreign key → Room.id — NOT NULL
  • id (userId) — Integer — Foreign key → User.id — NOT NULL