ChatProject
Tables (4)
ChatParticipant (Untitled)
- id (Key) — Primary key — NOT NULL
- id (userId) — NOTNULL — Foreign key → User.id — NOT NULL
- id (ChatRoomID) — NOTNULL — Foreign key → ChatRoom.id — NOT NULL
- joinedAt (Field)
ChatRoom (채팅)
- id (Key) — NOTNULL — Primary key — NOT NULL
- type (타입) — NOTNULL
- roomname (방이름) — NOTNULL
- createdAt (Field3)
Message (메세지)
- id (Key) — Primary key — NOT NULL
- id (userId) — NOTNULL — Foreign key → User.id — NOT NULL
- id (ChatRoomId) — NOTNULL — Foreign key → ChatRoom.id — NOT NULL
- content (Field)
- createdAt (Field2)
- messageType (Field3)
User (유저)
- id (Key) — NOTNULL — Primary key — NOT NULL
- email (이메일) — NOTNULL
- password (패스워드) — NOTNULL
- username (이름) — NOTNULL
- gender (성별) — NOTNULL
- age (나이) — NOTNULL