캡디 전문가

테이블 (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