stackoverflow

Tables (3)

comments

  • id — INTEGER — Primary key
  • post_id — INTEGER
  • score — INTEGER
  • text — TEXT
  • creation_date — TIMESTAMP
  • user_id — INTEGER
  • user_display_name — TEXT

posts

  • id — INTEGER — Primary key
  • post_type_id — INTEGER
  • creation_date — TIMESTAMP
  • score — INTEGER
  • view_count — INTEGER
  • body — TEXT
  • last_editor_user_id — INTEGER
  • last_edit_date — TIMESTAMP
  • last_activity_date — TEXT
  • title — TEXT
  • tags — TEXT
  • answer_count — INTEGER
  • comment_count — INTEGER
  • content_license — TEXT
  • accepted_answer_id — INTEGER
  • parent_id — INTEGER
  • favorite_count — INTEGER
  • owner_display_name — TEXT
  • last_editor_display_name — TEXT
  • closed_date — TIMESTAMP
  • community_owned_date — TIMESTAMP
  • owner_user_id — INTEGER

users

  • id — INTEGER
  • reputation — INTEGER
  • creation_date — TIMESTAMP
  • display_name — TEXT
  • last_access_date — TIMESTAMP
  • views — INTEGER
  • up_votes — INTEGER
  • down_votes — INTEGER
  • account_id — INTEGER
  • website_url — TEXT
  • location — TEXT
  • about_me — TEXT
  • post_id — INTEGER
  • score — INTEGER
  • text — TEXT
  • creation_date — TIMESTAMP
  • user_id — INTEGER
  • user_display_name — TEXT