fillm

Tables (5)

Comment

  • Key (commentId) — int — Primary key — NOT NULL
  • Key (postId) — int — Foreign key → Post.Key — NOT NULL
  • Key (userId) — int — Foreign key → User.Key — NOT NULL
  • Field (content) — text
  • Field (createdAt) — LocalDateTime

Like

  • Key (id) — int — Primary key — NOT NULL
  • Key (postId) — int — Foreign key → Post.Key — NOT NULL
  • Key (userId) — int — Foreign key → Post.Key — NOT NULL

MovieCategory

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(45)
  • Field (posterPath) — varchar(200)

Post

  • Key (postId) — int — Primary key — NOT NULL
  • Key (categoryId) — int — Foreign key → MovieCategory.Key — NOT NULL
  • Key (userId) — int — Foreign key → User.Key — NOT NULL
  • Field (content) — text
  • Field (createdAt) — DateTime

User

  • Key (id) — int — Primary key — NOT NULL
  • Field (username) — varchar(30)
  • Field (email) — varchar(45)
  • Field (password) — varchar(45)