Tech Blog
Tables (9)
comment_likes
- id — Primary key — NOT NULL
- comments_id
- visitor_id
- liked_at
comments
- id — Primary key — NOT NULL
- post_id — Foreign key → posts.id — NOT NULL
- author_visitor_id — Foreign key → visitors.id — NOT NULL
- parent_id
- content
- like_count
- author_name
- created_at
- updated_at
- deleted_at
- is_deleted
main_views
- id — Primary key — NOT NULL
- visitor_id
- viewed_at
post_likes
- id — Primary key — NOT NULL
- posts_id — Foreign key → posts.id — NOT NULL
- visitor_id — Foreign key → visitors.id — NOT NULL
- liked_at
post_tags
- post_id — Foreign key → posts.id — NOT NULL
- tag_id — Foreign key → tags.id — NOT NULL
post_views
- id — Primary key — NOT NULL
- post_id — Foreign key → posts.id — NOT NULL
- visitor_id — Foreign key → visitors.id — NOT NULL
- viewed_at
posts
- id — Primary key — NOT NULL
- post_slug
- created_at
- updated_at
- deleted_at
- is_deleted
tags
- id — Primary key — NOT NULL
- name
- parent_id
- created_at
visitors
- id — Primary key — NOT NULL
- created_at