Queensland
Tables (28)
bank_detail (계좌정보)
- id (계좌정보id) — Primary key — NOT NULL
- id (인적사항id) — Foreign key → personal_detail.id — NOT NULL
- id (양식버전id) — Foreign key → personal_detail.id — NOT NULL
- bank_name (은행명)
- account_name (예금주)
- bsb (은행번호)
- account_number (계좌번호)
board (게시판)
- id (게시판id) — Primary key — NOT NULL
- id (회사id) — Foreign key → company.id — NOT NULL
- created_at (생성일시)
- updated_at (수정일시)
- title (제목)
- content (내용)
company (회사)
- id (회사id) — Primary key — NOT NULL
- created_at (생성일시)
- updated_at (수정일시)
- name (이름)
- address (주소)
contract (계약서)
- id (계약서id) — Primary key — NOT NULL
- id (워홀러id) — Foreign key → worker.id — NOT NULL
- id (농장id) — Foreign key → farm.id — NOT NULL
- id (양식버전id) — Foreign key → form_version.id — NOT NULL
- created_at (생성일시)
- updated_at (수정일시)
emergency_contact (비상연락처)
- id (비상연락처id) — Primary key — NOT NULL
- id (인적사항id) — Foreign key → personal_detail.id — NOT NULL
- id (양식버전id) — Foreign key → personal_detail.id — NOT NULL
- name (이름)
- cell_phone (핸드폰번호)
farm (농장)
- id (농장id) — Primary key — NOT NULL
- id (회사id) — Foreign key → company.id — NOT NULL
- id (지역id) — Foreign key → location.id — NOT NULL
- created_at (생성일시)
- updated_at (수정일시)
- name (이름)
form_agree_item (동의)
- id (동의id) — Primary key — NOT NULL
- id (양식버전id) — Foreign key → form_version.id — NOT NULL
- number (번호)
- content (내용)
form_checklist_detail_item (건강체크리스트-상세)
- id (건강체크리스트-상세id) — Primary key — NOT NULL
- number (번호)
- content (내용)
- form_checklist_number (건강체크리스트번호)
form_checklist_item (건강체크리스트)
- id (건강체크리스트id) — Primary key — NOT NULL
- number (번호)
- content (내용)
form_guideline_item (안전수칙)
- id (안전수칙id) — Primary key — NOT NULL
- id (양식버전id) — Foreign key → form_version.id — NOT NULL
- number (번호)
- content (내용)
form_policy_detail_item (세부정책)
- id (세부정책id) — Primary key — NOT NULL
- id (양식버전id) — Foreign key → form_version.id — NOT NULL
- number (번호)
- content (내용)
- form_policy_number (정책번호)
form_policy_item (정책)
- id (정책id) — Primary key — NOT NULL
- id (양식버전id) — Foreign key → form_version.id — NOT NULL
- number (번호)
- title (제목)
- content_head (내용(전))
- content_tail (내용(후))
form_schedule_item (일정)
- id (일정id) — Primary key — NOT NULL
- id (양식버전id) — Foreign key → form_version.id — NOT NULL
- number (내용)
- content1 (내용1)
- content2 (내용2)
- content21 (내용2-1)
- content22 (내용2-2)
form_version (계약서양식버전)
- id (양식버전id) — Primary key — NOT NULL
- created_at (생성일시)
- updated_at (수정일시)
- is_main (메인여부)
general_health (일반건강)
- id (일반건강정보id) — Primary key — NOT NULL
- id (건강조사체크리스트id) — Foreign key → health_checklist.id — NOT NULL
- id (농장id) — Foreign key → health_checklist.id — NOT NULL
- id (양식버전id) — Foreign key → health_checklist.id — NOT NULL
- pre_existing_medical_condition (기존의료상태여부)
- taking_medication (약복용여부)
- recent_surgerie (최근수술여부)
- recent_injury (최근부상여부)
- job_related_limitation (직무관련제한여부)
health_checklist (건강조사체크리스트)
- id (건강조사체크리스트id) — Primary key — NOT NULL
- id (계약서id) — Foreign key → contract.id — NOT NULL
- id (농장id) — Foreign key → contract.id — NOT NULL
- id (양식버전id) — Foreign key → contract.id — NOT NULL
- extra_disclosure (공개의무에 의한 기타 건강상태)
location (지역)
- id (지역id) — Primary key — NOT NULL
- created_at (생성일시)
- updated_at (수정일시)
- name (이름)
medical_condition (의료상태)
- id (의료상태id) — Primary key — NOT NULL
- id (건강조사체크리스트id) — Foreign key → health_checklist.id — NOT NULL
- id (농장id) — Foreign key → health_checklist.id — NOT NULL
- id (양식버전id) — Foreign key → health_checklist.id — NOT NULL
- bee_sting (벌쏘임)
- epilepsy (간질)
- diabetes (당뇨)
- pregnant (임신)
- high_blood_pressure (고혈압)
- other (기타)
mental_health (정신건강)
- id (정신건강id) — Primary key — NOT NULL
- id (건강조사체크리스트id) — Foreign key → health_checklist.id — NOT NULL
- id (농장id) — Foreign key → health_checklist.id — NOT NULL
- id (양식버전id) — Foreign key → health_checklist.id — NOT NULL
- job_stress (직무스트레스여부)
- mental_counseling (정신상담여부)
- aware_of_eap (EAP인지여부)
order (파견)
- id (파견id) — Primary key — NOT NULL
- id (농장id) — Foreign key → farm.id — NOT NULL
- id (워홀러id) — Foreign key → worker.id — NOT NULL
- created_at (생성일시)
- updated_at (수정일시)
passport (여권정보)
- id (여권정보id) — Primary key — NOT NULL
- id (워홀러id) — Foreign key → worker.id — NOT NULL
- visa_grant_number (비자승인번호)
- visa_expire_date (비자만료일)
- nationality (국적)
- passport_number (여권번호)
personal_detail (인적사항)
- id (인적사항id) — Primary key — NOT NULL
- id (계약서id) — Foreign key → contract.id — NOT NULL
- id (양식버전id) — Foreign key → contract.id — NOT NULL
- cell_phone (휴대폰번호)
- email (이메일주소)
- address (주소)
- tax_file_number (세금번호)
safety_aware (안전인식)
- id (안전인식id) — Primary key — NOT NULL
- id (건강조사체크리스트id) — Foreign key → health_checklist.id — NOT NULL
- id (농장id) — Foreign key → health_checklist.id — NOT NULL
- id (양식버전id) — Foreign key → health_checklist.id — NOT NULL
- aware_of_safety_policy (안전규정인지여부)
- first_aid_training (응급처치훈련여부)
- safety_reporting_comfort (안전신고편의여부)
staff (관리자)
- id (관리자id) — Primary key — NOT NULL
- created_at (생성일시)
- updated_at (수정일시)
- level (등급)
- name (이름)
- password (암호)
staff_area (관리자영역)
- id (관리자영역id) — Primary key — NOT NULL
- id (워홀러id) — Foreign key → worker.id — NOT NULL
- start_date (시작일)
- end_date (종료일)
- tax (세금)
- farm_number (농장번호)
- memo (관리자메모)
superannuation (연금)
- id (연금id) — Primary key — NOT NULL
- id (인적사항id) — Foreign key → personal_detail.id — NOT NULL
- id (양식버전id) — Foreign key → personal_detail.id — NOT NULL
- fund_name (연금이름)
- member_number (연금번호)
team (팀)
- id (팀id) — Primary key — NOT NULL
- id (회사id) — Foreign key → company.id — NOT NULL
- created_at (생성일시)
- updated_at (수정일시)
- name (이름)
worker (워홀러)
- id (워홀러id) — Primary key — NOT NULL
- id (팀id) — Foreign key → team.id — NOT NULL
- created_at (생성일시)
- updated_at (수정일시)
- title (칭호)
- first_name (이름)
- last_name (성)
- english_name (영어이름)
- gender (성별)
- birth_date (생년월일)