chat_emotion_Project
Tables (4)
Chat (CopyOfUser)
- Chat_id (chat_id) — INT — Primary key
- User_id (user_id) — INT — Foreign key → User.User_id — NOT NULL
- sender_id — INT
- Receiver_id (receiver_id) — INT
- Message_type (message_type) — ENUM('text',image','emoji','video')
- Content (content) — TEXT
- sent_time — DATETIME
- Emotion_id (emotion_id) — INT — NOT NULL
- updated_at — DATATIME
Copy Of User (CopyOfUser2)
- User_id (user_id) — INT — Primary key — NOT NULL
- Relation_id (relation_id) — INT — Foreign key → RelatinoShip.Relation_id
- User_id (user_id2) — INT — Foreign key → RelatinoShip.User_id — NOT NULL
- User_name (user_name) — VARCAHR
- email — VARCHAR
- password
- Gender (gender) — CHAR
- Age (age) — INT
- Join_date (join_date) — DATETIME
- updated_at — DATETIME
RelatinoShip (CopyOfCopyOfUser)
- Relation_id (relation_id) — INT — Primary key
- User_id (user_id) — INT — Foreign key → User.User_id — NOT NULL
- User1_id (user1_id) — INT
- User2_id (user2_id) — INT
- Relation_type (relation_type) — ENUM('호감','친구','불편')
- relation_score — FLOAT
- updated_at — DATETIME
User
- User_id (user_id) — INT — Primary key — NOT NULL
- User_name (user_name) — VARCAHR
- email — VARCHAR
- password
- Gender (gender) — CHAR
- Age (age) — INT
- Join_date (join_date) — DATETIME
- updated_at — DATETIME