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