알바고수

테이블 (8)

경력기록

  • history_id — INT
  • user_id — INT
  • alba_id — INT
  • contract_id — INT
  • start_date — DATE
  • end_date — DATE

고용자

  • employer_id — INT
  • employer_name — VARCHAR(255) — NOT NULL
  • business_name — VARCHAR(255)
  • business_address — VARCHAR(255)

근로계약

  • contract_id — INT
  • user_id — INT
  • employer_id — INT
  • job_duties — VARCHAR(255)
  • work_location — VARCHAR(255)
  • start_date — DATE
  • end_date — DATE
  • salary — INT
  • weekly_hours — INT
  • holidays — VARCHAR(255)
  • payment_date — DATE
  • payment_method — ENUM('현금', '계좌이체')
  • created_at — DATE

근로자

  • user_id — INT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • gender — ENUM('남', '여') — NOT NULL
  • birthdate — DATE
  • address — VARCHAR(255)
  • region_id — INT
  • created_at — DATE
  • Field

근무일정

  • calendar_id — INT
  • user_id — INT
  • contract_id — INT
  • work_date — DATE
  • hours_worked — INT
  • salary — INT
  • created_at — DATE

급여

  • user_id — INT
  • contract_id — INT
  • alba_id — INT
  • month — VARCHAR(20)
  • salary_amount — INT
  • total_hours_worked — INT
  • created_at — DATE

아르바이트

  • alba_id — INT
  • alba_name — VARCHAR(255) — NOT NULL
  • description — TEXT

지역

  • region_id — INT
  • region_name — VARCHAR(255) — NOT NULL