Challenge_project

Tables (13)

Audio (Untitled10)

  • Audio_id (Key) — ID — Primary key — NOT NULL
  • File_id (ID) — ID — Foreign key → File.File_id — NOT NULL
  • audio_url (Field) — String
  • audio_url_img (Field2) — String
  • post (AudioFilesOfPost) — Post
  • createdAt (Field3) — Datetime

Category (Untitled12)

  • cat_id (Key) — Primary key — NOT NULL
  • cat_name (Field) — String
  • Field2

Comment (Untitled7)

  • Comment_id (Key) — Primary key — NOT NULL
  • Post_id (ID) — String — Foreign key → Post.Post_id — NOT NULL
  • User_id (ID2) — String — Foreign key → Post.User_id — NOT NULL
  • cat_id (Key2) — Foreign key → Post.cat_id — NOT NULL
  • File_id (ID3) — String — Foreign key → Post.File_id — NOT NULL
  • Room_id (Key3) — Foreign key → Post.Room_id — NOT NULL
  • User_id (ID22) — String — Foreign key → Post.User_id — NOT NULL
  • cat_id (Key22) — Foreign key → Post.cat_id — NOT NULL
  • Room_id (Key32) — Foreign key → Post.Room_id — NOT NULL
  • text (Field) — String
  • account (CommentsOfUser) — User
  • post (CommentOfPost) — Post
  • createdAt (Field2) — Datetime
  • updatedAt (Field3) — Datetime

File (Untitled2)

  • File_id (ID) — ID — Primary key — NOT NULL
  • url (Field) — String
  • post (Field2) — Post — NOT NULL
  • createdAt (Field3) — Datetime
  • updatedAt (Field4) — Datetime

Hashtag (Untitled13)

  • tag_id (Key) — Primary key — NOT NULL
  • tag_name (Field) — String
  • post (HashtagofPost) — Array
  • Post_id (ID) — String — Foreign key → Post.Post_id — NOT NULL
  • User_id (ID2) — String — Foreign key → Post.User_id — NOT NULL
  • cat_id (Key2) — Foreign key → Post.cat_id — NOT NULL
  • File_id (ID3) — String — Foreign key → Post.File_id — NOT NULL
  • Room_id (Key3) — Foreign key → Post.Room_id — NOT NULL
  • User_id (ID22) — String — Foreign key → Post.User_id — NOT NULL
  • cat_id (Key22) — Foreign key → Post.cat_id — NOT NULL
  • Room_id (Key32) — Foreign key → Post.Room_id — NOT NULL

Image (Untitled9)

  • Image_id (Key) — ID — Primary key — NOT NULL
  • File_id (ID) — ID — Foreign key → File.File_id — NOT NULL
  • image_url (Field) — String
  • post (ImageFilesOfPost) — Post
  • createdAt (Field2) — Datetime

Like (Untitled6)

  • Like_id (Key) — Primary key — NOT NULL
  • Post_id (ID) — String — Foreign key → Post.Post_id — NOT NULL
  • User_id (ID2) — String — Foreign key → Post.User_id — NOT NULL
  • cat_id (Key2) — Foreign key → Post.cat_id — NOT NULL
  • File_id (ID3) — String — Foreign key → Post.File_id — NOT NULL
  • Room_id (Key3) — Foreign key → Post.Room_id — NOT NULL
  • User_id (ID22) — String — Foreign key → Post.User_id — NOT NULL
  • cat_id (Key22) — Foreign key → Post.cat_id — NOT NULL
  • Room_id (Key32) — Foreign key → Post.Room_id — NOT NULL
  • account (LikeOfUser) — User
  • post (LikeOfPost) — Post
  • createdAt (Field) — Datetime
  • updatedAt (Field2) — Datetime

Message (Untitled4)

  • Message_id (ID) — ID — Primary key — NOT NULL
  • Room_id (Key) — Foreign key → Room.Room_id — NOT NULL
  • User_id (ID2) — String — Foreign key → Room.User_id — NOT NULL
  • cat_id (Key2) — Foreign key → Room.cat_id — NOT NULL
  • Room_id (Key3) — Foreign key → Room.Room_id — NOT NULL
  • text (Field) — String
  • from (Field1) — User
  • to (Field2) — User
  • room (Field3) — Room
  • createdAt (Field4) — Datetime
  • updatedAt (Field5) — Datetime

Post (Untitled5)

  • Post_id (ID) — String — Primary key — NOT NULL
  • User_id (ID2) — String — Foreign key → User.User_id — NOT NULL
  • cat_id (Key2) — Foreign key → User.cat_id — NOT NULL
  • File_id (ID3) — String — Foreign key → File.File_id — NOT NULL
  • Room_id (Key) — Foreign key → User.Room_id — NOT NULL
  • User_id (ID22) — String — Foreign key → User.User_id — NOT NULL
  • cat_id (Key22) — Foreign key → User.cat_id — NOT NULL
  • Room_id (Key3) — Foreign key → User.Room_id — NOT NULL
  • post_caption (Field) — String
  • user (PostOfUser) — User
  • likes (LikeOfPost) — Array
  • rel_challenger (RelChallOfUser) — Array
  • pre_challenger (PreChallOfUser) — Array
  • next_challenger (NextChallOfUser) — Array
  • tag_challenger (TagChallOfUser) — Array
  • hashtags (HashtagOfPost) — String
  • scope (Field2) — Boolean
  • comments (CommentOfPost) — Array
  • Category (Field3) — String
  • createdAt (Field4) — Datetime
  • updatedAt (Field5) — Datetime
  • tag_id (Key4) — Foreign key → Hashtag.tag_id — NOT NULL

Room (Untitled3)

  • Room_id (Key) — ID — Primary key — NOT NULL
  • User_id (ID) — String — Foreign key → User.User_id — NOT NULL
  • cat_id (Key2) — Foreign key → User.cat_id — NOT NULL
  • Room_id (Key3) — Foreign key → User.Room_id — NOT NULL
  • participants ([User!]!) — Array
  • messages ([Messages!]!) — Array
  • createdAt (Field) — Datetime
  • updatedAt (Field2) — Datetime

Text (Untitled11)

  • Text_id (Key) — ID — Primary key — NOT NULL
  • File_id (ID) — ID — Foreign key → File.File_id — NOT NULL
  • text_img_url (Field) — String
  • content (Field2) — String
  • post (TxtFilesOfPost) — Post
  • relay (Field3) — Boolean
  • createdAt (Field4) — Datetime

User (Untitled)

  • User_id (ID) — String — Primary key — NOT NULL
  • cat_id (Key2) — Foreign key → Category.cat_id — NOT NULL
  • Room_id (Key) — ID — Foreign key → Room.Room_id — NOT NULL
  • User_id (ID2) — String — Foreign key → Room.User_id — NOT NULL
  • cat_id (Key22) — Foreign key → Room.cat_id — NOT NULL
  • Room_id (Key3) — Foreign key → Room.Room_id — NOT NULL
  • username (Field) — String
  • avatar — String — NOT NULL
  • userid (Field2) — String
  • passwd (Field3) — String
  • email (Field4) — String
  • bio (Field7) — String — NOT NULL
  • following (Field8) — Array
  • follower (Field9) — Array
  • posts (Field10) — Array
  • likes (Field11) — Array
  • comments (Field12) — Array
  • rooms (Field13) — Array
  • loginSecret (Field14) — String — NOT NULL
  • createdAt (Field15) — Datetime
  • updatedAt (Field16) — Datetime

Video (Untitled8)

  • Video_id (Key) — Primary key — NOT NULL
  • File_id (ID) — ID — Foreign key → File.File_id — NOT NULL
  • video_url (Field) — String
  • post (VideoFilesOfPost) — Post
  • createdAt (Field2) — Datetime