캡디 전문가
테이블 (9)
bids
- id — BIGINT
- job_post_id — BIGINT — 외래 키 → job_posts.id — NOT NULL
- expert_user_id — BIGINT — 외래 키 → users.id — NOT NULL
- bid_amount — DECIMAL(15,2) — NOT NULL
- estimated_days — INT — NOT NULL
- proposal_message — TEXT
- status — VARCHAR(20) — NOT NULL
- submitted_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
companies
- id — BIGINT
- company_name — VARCHAR(100) — NOT NULL
- representative_name — VARCHAR(50) — NOT NULL
- company_type — VARCHAR(50) — NOT NULL
- business_number — VARCHAR(30)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
expert_certificates
- id — BIGINT
- verification_request_id — BIGINT — 외래 키 → expert_verification_requests.id — NOT NULL
- certificate_name — VARCHAR(100) — NOT NULL
- certificate_number — VARCHAR(100) — NOT NULL
- registration_period — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
expert_profiles
- id — BIGINT
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- specialty — VARCHAR(100) — NOT NULL
- business_name — VARCHAR(100)
- career_description — TEXT
- education — VARCHAR(200)
- portfolio_description — TEXT
- is_verified — BOOLEAN — NOT NULL
- verified_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
expert_verification_files
- id — BIGINT
- verification_request_id — BIGINT — 외래 키 → expert_verification_requests.id — NOT NULL
- file_id — BIGINT — 외래 키 → files.id — NOT NULL
- file_type — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
expert_verification_requests
- id — BIGINT
- expert_profile_id — BIGINT — 외래 키 → expert_profiles.id — NOT NULL
- career_description — TEXT
- education — VARCHAR(200)
- business_name — VARCHAR(100)
- portfolio_description — TEXT
- status — VARCHAR(20) — NOT NULL
- submitted_at — DATETIME
- reviewed_at — DATETIME
- reject_reason — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
files
- id — BIGINT
- original_name — VARCHAR(255) — NOT NULL
- stored_name — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- file_size — BIGINT — NOT NULL
- mime_type — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
job_posts
- id — BIGINT
- company_id — BIGINT — 외래 키 → companies.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- category — VARCHAR(100) — NOT NULL
- license_type — VARCHAR(100) — NOT NULL
- work_type — VARCHAR(100) — NOT NULL
- client_type — VARCHAR(50) — NOT NULL
- budget — DECIMAL(15,2) — NOT NULL
- region — VARCHAR(100)
- description — TEXT
- bid_deadline — DATETIME
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- id — BIGINT
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL