DODODODO
Tables (4)
ChannelChats (채널채팅)
- id (Key) — int — Primary key — NOT NULL
- Userid — int — Foreign key → Users.id — NOT NULL
- ChannelId — int — Foreign key → Channels.id — NOT NULL
- content — text
- createdAt — datetime
- updatedAt — datetime
ChannelMembers (채널멤버)
- UserId — int — Foreign key → Users.id — NOT NULL
- ChannelId — int — Foreign key → Channels.id — NOT NULL
- createdAt — datetime
- updatedAt — datetime
Channels (채널)
- id (Key) — int — Primary key — NOT NULL
- content — string
- createdAt — datetime
- updatedAt — datetime
- naem (name) — varchar(30)
- private — tinyint(1)
Users (유저)
- id — int — Primary key — NOT NULL
- email — varchar(30)
- nickname — varchar(30)
- password — varchar(100)
- createdAt — datetime
- updatedAt — datetime
- deletedAt — datetime