cupist

Tables (5)

Chats (chats)

  • Chats_id (chats_id) — Int — Primary key — NOT NULL
  • Is_Talking (is_talking) — Bool
  • Like_Id (like_id) — Int — Foreign key → Likes.Like_Id — NOT NULL
  • User_Id (user_id) — Int — Foreign key → Users.User_Id — NOT NULL
  • User_Id (user_id2) — Int — Foreign key → Users.User_Id — NOT NULL

Hobby (hobby)

  • Hobby_Id (hobby_id) — Int — Primary key — NOT NULL
  • Hobby (hobby) — Varchar(255)

Likes (likes)

  • Like_Id (like_id) — Int — Primary key — NOT NULL
  • Is_Received (is_received) — Bool
  • Sender_Id (sender_user_id) — Int — Foreign key → Users.User_Id — NOT NULL
  • Receiver_Id (receiver_user_id) — Int — Foreign key → Users.User_Id — NOT NULL

User_Hobbies (user_hobbies)

  • User_id (user_id) — Int — Foreign key → Users.User_Id — NOT NULL
  • Hobby_id (hobby_id) — Int — Foreign key → Hobby.Hobby_Id — NOT NULL

Users (users)

  • User_Id (user_id) — Int — Primary key — NOT NULL
  • Nickname (nickname) — Varchar(255)
  • Sex (sex) — Varchar(255)
  • Birthday (birthday) — Date