chatty_erd
Tables (6)
Chatting
- room_id — int — Foreign key → Rooms.id — NOT NULL
- sender_id — int — Foreign key → User.id — NOT NULL
- chat_id — int — NOT NULL
- image — varchar(100)
- file — varchar(200)
- text — varchar(1000)
- createdAt — datetime — NOT NULL
Friends
- user_id (user_id2) — int — Foreign key → User.id — NOT NULL
- friend_id — int
- status — bit — NOT NULL
Notification
- room_id — int — Foreign key → Rooms.id — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- count — int
Room_members
- room_id — int — Foreign key → Rooms.id — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime
- is_member — tinyint(1)
Rooms
- id — int — Primary key — NOT NULL
- name — varchar(20)
- createdAt — datetime — NOT NULL
- updatedAt — datetime
User
- id — int — Primary key — NOT NULL
- email — varchar(30) — NOT NULL
- nickname — varchar(20) — NOT NULL
- password — varchar(30)
- intro — varchar(200)
- profile — varchar(200)
- createdAt — datetime
- updatedAt — datetime
- del — tinyint(1)
- type — varchar(10)
- social_id — varchar(30)