1234

Tables (7)

comment

  • comments_id — int — Primary key — NOT NULL
  • post_id — int — NOT NULL
  • user_id — int — NOT NULL
  • parent_id — int — NOT NULL
  • content — text — NOT NULL
  • depth — int — NOT NULL
  • anonymity — boolean — NOT NULL
  • deleted — boolean — NOT NULL
  • created_at — datetime — NOT NULL

policy

  • policies_id — int — Primary key — NOT NULL
  • regions_id — int — NOT NULL
  • title — varchar(200) — NOT NULL
  • content — VARCHAR(255) — NOT NULL

post

  • post_id — int — Primary key — NOT NULL
  • user_id — int — NOT NULL
  • title — varchar(100) — NOT NULL
  • content — text — NOT NULL
  • anonymity — boolean — NOT NULL
  • deleted — boolean — NOT NULL
  • created_at — datetime — NOT NULL
  • view_count — int — NOT NULL

post_like

  • like_id — int — Primary key — NOT NULL
  • post_id — int — Foreign key → post.post_id — NOT NULL
  • user_id — int — NOT NULL
  • reaction_type — int — NOT NULL

region

  • region_id — int — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL

report

  • reports_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • post_id — int — NOT NULL
  • status — int — NOT NULL
  • created_at — datetime — NOT NULL

user

  • user_id — int — Primary key — NOT NULL
  • regions_id — int — NOT NULL
  • login_id — varchar(100) — NOT NULL
  • email — varchar(100) — NOT NULL
  • password — varchar(255) — NOT NULL
  • nickname — varchar(50) — NOT NULL
  • role — int — NOT NULL
  • birth_year — int — NOT NULL
  • gender — int — NOT NULL
  • provider_type — varchar(20)
  • created_at — datetime — NOT NULL