clean-chat
Tables (5)
chat_contents
- id — int — Primary key — NOT NULL
- content — text
- image_path — varchar(30)
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- chat_list_id — int — Foreign key → chat_lists.id
- user_id — int — Foreign key → users.id
- deleted — tinyint(1)
chat_lists
- id — int — Primary key — NOT NULL
- group — tinyint(1) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- deleted_at — datetime
chat_users
- id — int — Primary key — NOT NULL
- chat_title — varchar(50)
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- deleted_at — datetime
- user_id — int — Foreign key → users.id
- chat_list_id — int — Foreign key → chat_lists.id
friends
- user_id — int — Foreign key → users.id — NOT NULL
- friend_id — int — Foreign key → users.id — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
users
- id — int — Primary key — NOT NULL
- email — varchar(20) — NOT NULL
- password — varchar(100) — NOT NULL
- name — varchar(10) — NOT NULL
- gender — enum('M','F','X') — NOT NULL
- image_path — varchar(30) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- deleted_at — datetime