seosan-issue

Tables (10)

bookmark

  • user_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME — NOT NULL

comment

  • id — BIGINT
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

last_crawled_info

  • category_name — VARCHAR(255)
  • last_crawled_link — VARCHAR(1024)
  • last_crawled_at — DATETIME

nickname_history

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • old_nickname — VARCHAR(40) — NOT NULL
  • new_nickname — VARCHAR(40) — NOT NULL
  • changed_at — DATETIME — NOT NULL

password_reset_log

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • reset_at — DATETIME
  • result — VARCHAR(16) — NOT NULL
  • ip — VARCHAR(45)
  • ua — VARCHAR(255)

post

  • id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • content — MEDIUMTEXT — NOT NULL
  • link — VARCHAR(1024) — NOT NULL
  • pub_date — VARCHAR(64) — NOT NULL
  • region — VARCHAR(255) — NOT NULL
  • category — VARCHAR(255) — NOT NULL
  • department — VARCHAR(255)
  • views — INT
  • crawled_at — DATETIME — NOT NULL

post_like

  • user_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Primary key — NOT NULL
  • liked_at — DATETIME — NOT NULL

post_view

  • user_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Primary key — NOT NULL
  • viewed_at — DATETIME — Primary key — NOT NULL

user

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(40) — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • user_id — BIGINT — Foreign key → user_role.user_id — NOT NULL
  • role — VARCHAR(32) — Foreign key → user_role.role — NOT NULL

user_role

  • user_id — BIGINT — Primary key — NOT NULL
  • role — VARCHAR(32) — Primary key — NOT NULL