Member2

Tables (5)

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

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