알바고수
테이블 (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