SubwayChat
Tables (6)
ChatRoom (채팅방)
- id (아이디) — NOTNULL — Primary key — NOT NULL
- line (지하철 노선) — NOTNULL
- createdData (생성일자) — NOTNULL
- updatedData (수정일자) — NOTNULL
ChatUser (참가자)
- id (아이디) — NOTNULL — Primary key — NOT NULL
- userId (유저 아이디) — NOTNULL — Foreign key → User.id — NOT NULL
- roomId (채팅방 아이디) — NOTNULL — Foreign key → ChatRoom.id — NOT NULL
- createdData (생성일자) — NOTNULL
- updatedData (수정일자) — NOTNULL
Comment (댓글)
- id (아이디) — NOTNULL — Primary key — NOT NULL
- userId (유저 아이디) — NOTNULL — Foreign key → User.id — NOT NULL
- postID (게시글 아이디) — NOTNULL — Foreign key → Post.id — NOT NULL
- content (댓글) — NOTNULL
- createdData (생성일자) — NOTNULL
- updatedData (수정일자) — NOTNULL
Message (메시지)
- id (아이디) — NOTNULL — Primary key — NOT NULL
- userId (유저 아이디) — NOTNULL — Foreign key → User.id — NOT NULL
- roomId (채팅방 아이디) — NOTNULL — Foreign key → ChatRoom.id — NOT NULL
- content (내용) — NOTNULL
- createdData (생성일자) — NOTNULL
- updatedData (수정일자) — NOTNULL
Post (게시글)
- id (아이디) — NOTNULL — Primary key — NOT NULL
- userId (유저 아이디) — NOTNULL — Foreign key → User.id — NOT NULL
- title (제목) — NOTNULL
- content (내용) — NOTNULL
- type (게시글 유형) — NOTNULL
- createdData (생성일자) — NOTNULL
- updatedData (수정일자) — NOTNULL
User (유저)
- id (아아디) — NOTNULL — Primary key — NOT NULL
- nickName (닉네임) — NOTNULL
- line (지하철 노선) — NOTNULL
- createdData (생성일자) — NOTNULL
- updatedData (수정일자) — NOTNULL