final-pjt

Tables (7)

accounts_User (User)

  • Id — Primary key — NOT NULL
  • username
  • password (passwor)
  • etc

community_Comment

  • Id — Primary key — NOT NULL
  • user_id — Foreign key → accounts_User.Id — NOT NULL
  • post_id — Foreign key — NOT NULL
  • comment
  • created_at
  • updated_at

community_Post

  • Id — Primary key — NOT NULL
  • user_id — Foreign key → accounts_User.Id — NOT NULL
  • title
  • content
  • created_at
  • updated_at (updated_ad)

movie_like

  • Id — Primary key — NOT NULL
  • user_id — Foreign key → movies_Movie.Id — NOT NULL
  • movie_id — Foreign key → accounts_User.Id — NOT NULL

movies_Comment

  • Id — Primary key — NOT NULL
  • user_id — Foreign key → accounts_User.Id — NOT NULL
  • movie_id — Foreign key → movies_Movie.Id — NOT NULL
  • comment
  • craeted_at (created_at)
  • updated_ad (upated_ad)

movies_Movie

  • Id — Primary key — NOT NULL
  • title
  • overviwe (overview)
  • postet_path (poster_path)
  • etc

post_like

  • Id — Primary key — NOT NULL
  • user_id — Foreign key → accounts_User.Id — NOT NULL
  • post_id — Foreign key → community_Post.Id — NOT NULL