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