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