LimSR12-log
Tables (6)
archives
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- source_url — VARCHAR(500)
- type — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
categories
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
portfolios
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- thumbnail — VARCHAR(500)
- github_url — VARCHAR(500)
- demo_url — VARCHAR(500)
- tech_stack — TEXT
- started_at — DATE
- ended_at — DATE
- sort_order — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
post_tags
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- tag_id — BIGINT — Foreign key → tags.id — NOT NULL
posts
- id — BIGINT
- category_id — BIGINT — Foreign key → categories.id
- title — VARCHAR(255) — NOT NULL
- slug — VARCHAR(300) — NOT NULL
- content — TEXT — NOT NULL
- summary — VARCHAR(500)
- thumbnail — VARCHAR(500)
- status — VARCHAR(20) — NOT NULL
- published_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
tags
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL