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)