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 (수정일)