Member

Tables (8)

admin_approval

  • id — BIGINT
  • document_id — BIGINT
  • admin_user_id — BIGINT
  • decision — VARCHAR(20)
  • reason — TEXT
  • decided_at — DATETIME

disabled_profile

  • id — BIGINT
  • user_id — BIGINT
  • disability_type — VARCHAR(50)
  • disability_level — VARCHAR(50)
  • description — TEXT

helper_profile

  • id — BIGINT
  • user_id — BIGINT
  • career_years — INT
  • available_time — VARCHAR(100)
  • activity_area — VARCHAR(100)
  • introduction — TEXT

matches

  • id — BIGINT
  • disabled_user_id — BIGINT
  • helper_user_id — BIGINT
  • post_id — BIGINT
  • status — VARCHAR(20)
  • started_at — DATETIME
  • ended_at — DATETIME

payments

  • id — BIGINT
  • user_id — BIGINT
  • type — VARCHAR(20)
  • amount — INT
  • status — VARCHAR(20)
  • created_at — DATETIME

posts

  • id — BIGINT
  • author_user_id — BIGINT
  • post_type — VARCHAR(20)
  • title — VARCHAR(200)
  • content — TEXT
  • region — VARCHAR(100)
  • reward_honey — INT
  • created_at — DATETIME
  • updated_at — DATETIME

users

  • id — BIGINT
  • email — VARCHAR(255)
  • password_hash — VARCHAR(255)
  • name — VARCHAR(100)
  • nickname — VARCHAR(100)
  • birth_date — DATE
  • gender — VARCHAR(10)
  • phone — VARCHAR(50)
  • address — VARCHAR(255)
  • role — VARCHAR(20)
  • status — VARCHAR(20)
  • created_at — DATETIME
  • updated_at — DATETIME

verification_document

  • id — BIGINT
  • user_id — BIGINT
  • document_type — VARCHAR(30)
  • file_url — VARCHAR(500)
  • exif_score — DECIMAL(5,2)
  • ocr_score — DECIMAL(5,2)
  • forgery_score — DECIMAL(5,2)
  • status — VARCHAR(20)
  • requested_at — DATETIME