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