Tripee

Tables (4)

Comment (Untitled3)

  • postUser_Id (Key3) — String — Primary key — NOT NULL
  • Post_id (Key) — String — Foreign key → Post.Post_id — NOT NULL
  • User_id (Key2) — String — Foreign key → Post.User_id — NOT NULL
  • content (Field) — String
  • created_At (Field2) — Date
  • updatedAt (Field4) — Date
  • anonymous (Field3) — Boolean

Post (Untitled2)

  • Post_id (Key) — String — Primary key — NOT NULL
  • User_id (Key2) — String — Foreign key → User.User_id — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • createdAt (Field3) — Date
  • updatedAt (Field4) — Date
  • paid (Field5) — Boolean
  • price (Field6) — integer

User (Untitled)

  • User_id (Key) — Primary key — NOT NULL
  • password (Field2) — String
  • userName (Field) — String
  • paidPost (Field5) — Post
  • myPost (Field3) — Post
  • likedChoice (Field4) — Post

notification (Untitled4)

  • postUser_Id (Key3) — String — Foreign key → Comment.postUser_Id — NOT NULL
  • Post_id (Key) — Foreign key → Comment.Post_id — NOT NULL
  • User_id (Key2) — Foreign key → Comment.User_id — NOT NULL
  • title (Field) — String
  • updatedAt (Field5) — Date
  • created_At (Field2) — Date
  • read (Field3) — Boolean
  • URl (Field4) — String