playground-erd

Tables (10)

answer

  • id — BIGINT — Primary key
  • question_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • accepted — BOOLEAN — NOT NULL
  • deleted — BOOLEAN — NOT NULL
  • report_count — INT — NOT NULL
  • like_count — INT — NOT NULL
  • dislike_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

comments

  • id — BIGINT — Primary key
  • answer_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • deleted — BOOLEAN — NOT NULL
  • like_count — INT — NOT NULL
  • dislike_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notification

  • id — BIGINT — Primary key
  • receiver_id — BIGINT — NOT NULL
  • sender_id — BIGINT
  • type — VARCHAR(20) — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

question

  • id — BIGINT — Primary key
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — BIGINT — NOT NULL
  • report_count — INT — NOT NULL
  • like_count — INT — NOT NULL
  • dislike_count — INT — NOT NULL
  • accepted_answer_id — BIGINT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

reaction

  • id — BIGINT — Primary key
  • user_id — BIGINT — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • reaction_type — VARCHAR(10) — NOT NULL
  • created_at — DATETIME — NOT NULL

refresh_tokens

  • id — BIGINT — Primary key
  • user_id — BIGINT — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • expired_at — DATETIME — NOT NULL

reports

  • id — BIGINT — Primary key
  • reporter_user_id — BIGINT — NOT NULL
  • reported_user_id — BIGINT — NOT NULL
  • entity_id — BIGINT — NOT NULL
  • entity_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • detail — TEXT
  • created_at — DATETIME — NOT NULL

roles

  • id — BIGINT — Primary key
  • name — VARCHAR(50) — NOT NULL

user_roles

  • id — BIGINT — Primary key
  • user_id — BIGINT — NOT NULL
  • role_id — BIGINT — NOT NULL

users

  • id — BIGINT — Primary key
  • nickname — VARCHAR(100) — NOT NULL
  • login_id — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100)
  • joined_date — DATETIME — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • deleted_at — DATETIME
  • provider — VARCHAR(50)
  • provider_id — VARCHAR(255)