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