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