11
Tables (5)
categories
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
- slug — VARCHAR(50) — NOT NULL
- description — TEXT
- order — INT — NOT NULL
- is_active — TINYINT(1) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
comments
- id — BIGINT
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- parent_id — BIGINT
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
likes
- id — BIGINT
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
posts
- id — BIGINT
- user_id — BIGINT — NOT NULL
- category_id — BIGINT
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_category_created
users
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email_verified_at — TIMESTAMP
- remember_token — VARCHAR(100)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP