test
Tables (8)
categories
- id — int(11) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- slug — varchar(255) — NOT NULL
- sort_order — int(11) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
comments
- id — int(11) — Primary key — NOT NULL
- content — text — NOT NULL
- guestName — varchar(255)
- guestPassword — varchar(255)
- created_at — timestamp — NOT NULL
- deleted_at — timestamp
- deletedBy — varchar(255)
- notionPostId — varchar(255)
- userId — int(11) — Foreign key → users.id
- postId — int(11) — Foreign key → posts.id
- parent_id — int(11) — Foreign key → comments.id
likes
- id — int(11) — Primary key — NOT NULL
- postId — int(11)
- notionPostId — varchar(255)
- ipAddress — varchar(255) — NOT NULL
- created_at — timestamp — NOT NULL
notifications
- id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → users.id — NOT NULL
- type — varchar(50) — NOT NULL
- created_at — timestamp — NOT NULL
- read_at — timestamp
- post_id — int(11)
- notion_post_id — varchar(255)
- comment_id — int(11)
- actor_name — varchar(255)
- actor_user_id — varchar(255)
notion_page_views
- pageId — varchar(50) — Primary key — NOT NULL
- views — int(11) — NOT NULL
posts
- id — int(11) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- views — int(11) — NOT NULL
- likes — int(11) — NOT NULL
- created_at — timestamp — NOT NULL
- deleted_at — timestamp
- tags — varchar(255)
- userId — int(11) — Foreign key → users.id
- category_id — int(11) — Foreign key → categories.id
users
- id — int(11) — Primary key — NOT NULL
- userId — varchar(255) — NOT NULL
- nickname — varchar(255)
- password — varchar(255) — NOT NULL
- isAdmin — tinyint(4) — NOT NULL
visitor_logs
- id — int(11) — Primary key — NOT NULL
- ip_address — varchar(255)
- user_agent — text
- referrer — text
- page_url — text
- search_keyword — varchar(255)
- visited_at — timestamp — NOT NULL