BlogService (PostgreSQL)
Tables (8)
BlogSetting
- id — INT
- description — TEXT
- progile_img_url — VARCHAR
- updated_at — TIMESTAMP
Category
- id — SERIAL
- name — VARCHAR — NOT NULL
- parent_id — INT
- sort_order — INT — NOT NULL
Comment
- id — SERIAL
- post_id — INT — NOT NULL
- parent_id — INT
- nickname — VARCHAR — NOT NULL
- password — VARCHAR — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Post
- id — SERIAL
- title — VARCHAR — NOT NULL
- content — TEXT
- is_private — BOOLEAN — NOT NULL
- is_draft — BOOLEAN — NOT NULL
- view_count — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- user_id — INT — NOT NULL
- category_id — INT
PostTag
- post_id — INT — Primary key — NOT NULL
- tag_id — INT — Primary key — NOT NULL
Tag
- id — SERIAL
- name — VARCHAR — NOT NULL
User
- id — SERIAL
- username — VARCHAR — NOT NULL
- password — VARCHAR — NOT NULL
- role — VARCHAR — NOT NULL
- created_at — TIMESTAMP — NOT NULL
VisitorLog
- id — SERIAL
- ip_address — VARCHAR
- user_agent — VARCHAR
- referrer — VARCHAR
- keyword — VARCHAR
- date — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP — NOT NULL