Beomeo_wiki

Tables (4)

post (Untitled2)

  • post_id (Primary Key) — INT — Primary key — NOT NULL
  • user_id (Foreign Key) — INT — Foreign key → user.유저 id — NOT NULL
  • post_title (Field) — VARCHAR(50)
  • post_tag (Field2) — INT
  • post_content (Field4) — VARCHAR(5000)
  • updated_at (Field3) — DATE

post_history (Untitled4)

  • history_id (Primary Key) — Integer — Primary key — NOT NULL
  • user_id (Foreign Key2) — Integer — Foreign key → user.유저 id — NOT NULL
  • post_id (Primary Key2) — INT — Foreign key → post.post_id — NOT NULL
  • content_before (Field) — VARCHAR(5000)
  • content_after (Field2) — VARCHAR(5000)
  • content_diff (Field3) — VARCHAR(5000)
  • modified_at (Field4) — DATE

report (Untitled3)

  • report_id (Key) — Integer — Primary key — NOT NULL
  • report_content (Field) — VARCHAR(500)
  • report_type (Field2) — VARCHAR(20)
  • user_id (Primary Key) — INT — Foreign key → user.유저 id — NOT NULL
  • post_id (Primary Key2) — INT — Foreign key → post.post_id — NOT NULL

user (Untitled)

  • 유저 id (user_id) — INT — Primary key — NOT NULL
  • 이름 (username) — VARCHAR(50)
  • 메일 (mail) — VARCHAR(50)
  • 비밀번호 (password) — VARCHAR(20)
  • created_at (Field3) — DATE