test

Tables (8)

answer

  • answer_id — bigint
  • content — varchar(255)
  • create_at — bigint
  • is_accepted — boolean
  • modified_date — bigint
  • score — bigint
  • post_id — bigint
  • user_id — bigint

answer_vote

  • answer_vote_id — bigint
  • answer_vote_down — boolean
  • answer_vote_up — boolean
  • answer_id — bigint
  • user_id — bigint

comment

  • comment_id — bigint
  • comment_content — varchar(255)
  • comment_date — timestamp
  • comment_modified — boolean
  • answer_id — bigint
  • post_id — bigint
  • user_id — bigint

member

  • user_id — bigint
  • email — varchar(255)
  • nick_name — varchar(255)
  • password — varchar(255)
  • profile_id — bigint

post

  • post_id — bigint
  • create_at — timestamp
  • is_answered — boolean
  • modified_at — timestamp
  • post_content — varchar(255)
  • post_name — varchar(255)
  • score — bigint
  • view_count — bigint
  • user_id — bigint

post_vote

  • post_vote_id — bigint
  • post_vote_down — boolean
  • post_vote_up — boolean
  • post_id — bigint
  • team_id — bigint

profile

  • profile_id — bigint
  • about — varchar(255)
  • created_at — timestamp
  • last_visit — timestamp
  • profile_image_link — varchar(255)
  • reputation — bigint

tag

  • tag_id — bigint
  • tag_description — varchar(255)
  • tag_name — varchar(255)
  • post_id — bigint