Meeting

Tables (9)

Meeting_Attendance (근태 및 근무관리현황 입력값)

  • idx (인덱스) — Primary key — NOT NULL
  • MH_idx (회의자료_인덱스) — Foreign key → Meeting_History.idx — NOT NULL
  • MS_idx (회의목차_인덱스) — Int — Foreign key → Meeting_Section.idx — NOT NULL
  • last_member_count (전주인원)
  • last_member_bigo1 (전주인원 비고)
  • last_member_bigo_2 (전주인원 비고2)
  • this_member_count (금주인원)
  • this_member_bigo_1 (금주인원 비고)
  • this_member_bigo_2 (금주인원 비고2)
  • created_at (생성일)
  • updated_at (수정일)

Meeting_Attendance_DataHistory (근태 및 근무관리현황 데이터이력)

  • idx (인덱스) — Primary key — NOT NULL
  • MH_idx (회의자료_인덱스) — Foreign key → Meeting_History.idx — NOT NULL
  • MS_idx (회의목차_인덱스) — Int — Foreign key → Meeting_Section.idx — NOT NULL
  • last_vacation_count_txt (전주 휴가인원)
  • last_vacation_member_txt (전주 휴가자)
  • last_vacation_total_time (전주 휴가총시간)
  • this_vacation_count_txt (금주 휴가인원)
  • this_vacation_member_txt (금주 휴가자)
  • this_vacation_total_time (금주 휴가총시간)
  • late_member (금주 지각자(일자))
  • late_member_part (금주 지각자 부서)
  • created_at (생성일)
  • updated_at (수정일)

Meeting_Date (회의일자)

  • idx (인덱스) — Int — Primary key — NOT NULL
  • target_year (Field) — Char
  • target_month (Field2) — Char
  • target_week (Field3) — Char
  • created_at (생성일) — Timestamp
  • updated_at (수정일) — Timestamp

Meeting_History (회의자료)

  • idx (인덱스) — Int — Primary key — NOT NULL
  • MD_idx (회의일자_인덱스) — Int — Foreign key → Meeting_Date.idx — NOT NULL
  • history_date (일자) — Date
  • created_at (생성일) — Timestamp
  • updated_at (수정일) — Timestamp

Meeting_ProgressStatus (부서별 공정목표현황 입력값)

  • idx (인덱스) — Primary key — NOT NULL
  • MH_idx (회의자료_인덱스) — Foreign key → Meeting_History.idx — NOT NULL
  • MS_idx (회의목차_인덱스) — Int — Foreign key → Meeting_Section.idx — NOT NULL
  • late_project_name (공정지연 프로젝트)
  • late_reason (공정지연 사유)
  • late_after (공정지연 향후대응)
  • late_bigo (공정지연 비고)
  • created_at (생성일)
  • updated_at (수정일)

Meeting_ProgressStatus_DataHistory (부서별 공정목표현황)

  • idx (인덱스) — Primary key — NOT NULL
  • MH_idx (회의자료_인덱스) — Int — Foreign key → Meeting_History.idx — NOT NULL
  • MS_idx (회의목차_인덱스) — Int — Foreign key → Meeting_Section.idx — NOT NULL
  • project_name (프로젝트 명)
  • project_link (프로젝트 링크)
  • basis_percent (프로젝트 공정률)
  • now_status (공정목표 상태값)
  • now_date (공정목표 적용일)
  • now_orderBy (공정목표 정렬기준)
  • created_at (생성일)
  • updated_at (수정일)
  • Field2
  • Field3
  • Field4
  • Field5

Meeting_Section (회의목차)

  • idx (인덱스) — Int — Primary key — NOT NULL
  • section_name (목차이름) — Char
  • status (상태) — Int
  • created_at (생성일) — Timestamp
  • updated_at (수정일) — Timestamp

Meeting_Target_Info (Untitled)

    Meeting_Weekly_DataHistory (부서별 공정이익현황)

    • idx (인덱스) — Primary key — NOT NULL
    • MH_idx (회의자료_인덱스) — Int — Foreign key → Meeting_History.idx — NOT NULL
    • MS_idx (회의목차_인덱스) — Int — Foreign key → Meeting_Section.idx — NOT NULL
    • part_order (부서정렬기준)
    • part_name (부서명)
    • project_contract_part_amount (부서 공정매출)
    • sum_work_value (부서 공정비용)
    • data (부서 공정손익)
    • created_at (생성일)
    • updated_at (수정일)