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 (생년월일)