test

Tables (5)

answer

  • answer_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • content — text
  • author_id — bigint
  • question_id — bigint

question

  • question_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • content — text
  • title — varchar(255)
  • views — bigint — NOT NULL
  • author_id — bigint

user_roles

  • user_user_id — bigint — NOT NULL
  • roles — varchar(255)

users

  • user_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • display_name — varchar(255)
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • user_status — varchar(255)

vote

  • vote_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • amount — int — NOT NULL
  • answer_id — bigint
  • question_id — bigint
  • voter_id — bigint