pms
Tables (25)
applied_standards
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- standards_organization_id — uuid — Foreign key → standards_organizations.id — NOT NULL
- number — varchar — NOT NULL — 표기
- version — varchar — NOT NULL — 표준
- title — varchar — NOT NULL — 표준
- sort_order — int4 — NOT NULL — 동일
clause_documents
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- document_number — varchar — NOT NULL — 문서
- registered_by_name — varchar — 등록자
- description — text — 문서
- name — varchar — NOT NULL — 문서(템플릿)
- category — varchar — NOT NULL — 문서
- file_url — text — 첨부
departments
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- name — varchar — NOT NULL — 부서명
- code — varchar — 부서
- sort_order — int4 — NOT NULL — 표시·정렬
employee_assignments
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- employee_id — uuid — Foreign key → employees.id — NOT NULL
- department_id — uuid — Foreign key → departments.id — NOT NULL
- start_date — date — NOT NULL — 배정
- end_date — date — 배정
- is_primary — bool — NOT NULL — 주
employee_projects
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- employee_id — uuid — Foreign key → employees.id — NOT NULL
- project_id — uuid — Foreign key → projects.id — NOT NULL
- role — varchar — NOT NULL — 프로젝트
- sort_order — int4 — NOT NULL — 표시
- start_date — date — 참여
- end_date — date — 참여
employees
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- name — varchar — NOT NULL — 직원
- email — varchar — 이메일
- employee_number — varchar — 사번
- status — varchar — NOT NULL — 재직·계약
model_types
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- name — text — NOT NULL — 모델
- code — varchar — NOT NULL — 모델
- description — text — NOT NULL — 설명
- sort_order — int4 — NOT NULL — 표시
project_applied_standards
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- project_id — uuid — Foreign key → projects.id — NOT NULL
- applied_standard_id — uuid — Foreign key → applied_standards.id — NOT NULL
- sort_order — int4 — NOT NULL — 프로젝트
- is_used — bool — NOT NULL — 사용
- created_by_name — varchar — 등록자
project_change_histories
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- project_id — uuid — Foreign key → projects.id — NOT NULL
- history_type — varchar — NOT NULL — 이력
- version — int4 — NOT NULL — 이력
- status — varchar — NOT NULL — 이력
- summary — text — 변경
- approved_at — timestamp — 승인
- approved_by_employee_id — uuid — Foreign key → employees.id
- snapshot — text — 승인
- created_by_employee_id — uuid — Foreign key → employees.id
project_change_history_changes
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- history_id — uuid — Foreign key → project_change_histories.id — NOT NULL
- sort_order — int4 — NOT NULL — 같은
- item_name — text — NOT NULL — 변경
- category — varchar — NOT NULL — 변경
- changed_field — varchar — NOT NULL — 변경된
- before_value — text — 변경
- after_value — text — 변경
- created_by_employee_id — uuid — Foreign key → employees.id
project_departments
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- project_id — uuid — Foreign key → projects.id — NOT NULL
- display_name — varchar — NOT NULL — 프로젝트
- sort_order — int4 — NOT NULL — 프로젝트
- company_department_id — uuid — Foreign key → departments.id — NOT NULL
- is_used — bool — NOT NULL — 프로젝트에서
project_events
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- project_id — uuid — Foreign key → projects.id — NOT NULL
- name — text — NOT NULL — 이벤트
- description — text — NOT NULL — 이벤트
- event_date — date — NOT NULL — 이벤트
- type — varchar — NOT NULL — 이벤트
project_model_types
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- project_id — uuid — Foreign key → projects.id — NOT NULL
- model_type_id — uuid — Foreign key → model_types.id — NOT NULL
- sort_order — int4 — NOT NULL — 프로젝트
project_structure_department_assignees
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- project_structure_id — uuid — Foreign key → project_structures.id — NOT NULL
- employee_id — uuid — Foreign key → employees.id — NOT NULL
- sort_order — int4 — NOT NULL — 동일
project_structures
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- project_id — uuid — Foreign key → projects.id
- parent_id — uuid — Foreign key → project_structures.id
- sort_order — int4 — NOT NULL — 형제
- level — int4 — NOT NULL — 트리
- code — varchar — NOT NULL — 구조
- name — text — NOT NULL — 구조
- status — varchar — NOT NULL — 항목
- project_department_id — uuid — Foreign key → project_departments.id
- dpm_employee_id — uuid — Foreign key → employees.id
- start_date — date — NOT NULL — 계획
- due_date — date — NOT NULL — 계획
- completed_date — date — 실제
- current_version — varchar — NOT NULL — 현재
- updated_by_employee_id — uuid — Foreign key → employees.id
project_wbs
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- project_id — uuid — Foreign key → projects.id — NOT NULL
- parent_id — uuid — Foreign key → project_wbs.id
- sort_order — int4 — NOT NULL — 형제
- level — int4 — NOT NULL — WBS
- code — varchar — NOT NULL — WBS
- name — text — NOT NULL — 작업(업무)명
- description — text — 작업
- assignee_employee_id — uuid — Foreign key → employees.id
- current_version — varchar — NOT NULL — 현재
- updated_by_employee_id — uuid — Foreign key → employees.id
- created_by_employee_id — uuid — Foreign key → employees.id
- effort — numeric — 공수(예:
- priority — varchar — 우선순위
- status — varchar — 작업
projects
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- parent_id — uuid — Foreign key → projects.id
- sort_order — int4 — NOT NULL — 형제
- name — text — NOT NULL — 프로젝트명
- code — varchar — NOT NULL — 프로젝트
- description — text — NOT NULL — 프로젝트
- status — varchar — NOT NULL — 프로젝트
- progress — int4 — NOT NULL — 진척도(0–100
- start_date — date — NOT NULL — 시작일
- due_date — date — NOT NULL — 목표
- pm_employee_id — uuid — Foreign key → employees.id
- current_draft_structure_history_id — uuid — Foreign key → project_change_histories.id
- current_draft_assignee_history_id — uuid — Foreign key → project_change_histories.id
- current_draft_wbs_history_id — uuid — Foreign key → project_change_histories.id
query-result-cache
- id — serial4 — Primary key — NOT NULL
- identifier — varchar
- time — int8 — NOT NULL
- duration — int4 — NOT NULL
- query — text — NOT NULL
- result — text — NOT NULL
standard_clause_documents
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- standard_clause_item_id — uuid — Foreign key → standard_clause_items.id — NOT NULL
- clause_document_id — uuid — Foreign key → clause_documents.id — NOT NULL
- sort_order — int4 — NOT NULL — 동일
- is_required — bool — NOT NULL — 필수
standard_clause_items
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- applied_standard_id — uuid — Foreign key → applied_standards.id — NOT NULL
- parent_id — uuid — Foreign key → standard_clause_items.id
- sort_order — int4 — NOT NULL — 같은
- code — varchar — NOT NULL — 조항
- clause_type — varchar — NOT NULL — 조항
- name — text — NOT NULL — 조항명
- content — text — 조항
- manager — varchar — 담당자(문자열
- process — varchar — 프로세스명
- department — varchar — 부서(문자열)
- parent_code — varchar — 상위
- document_category — varchar — 문서
- document_number — varchar — 문서
- document_name — varchar — 문서명
- document_url — text — 문서
- document_category2 — varchar — 부속
- document_number2 — varchar — 부속
- document_name2 — varchar — 부속
- document_category3 — varchar — 부속
- document_number3 — varchar — 부속
- document_name3 — varchar — 부속
- change_history — text — 변경
- approval_status — varchar — 승인
- approval_requested_at — timestamp — 승인
- due_date — date — 기한일
- document_format_type — varchar — 문서
- form_registration_type — varchar — 폼
standards_organizations
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- name — varchar — NOT NULL — 표준화기구명(예:
- code — varchar — NOT NULL — 기구
- description — text — 설명
- sort_order — int4 — NOT NULL — 표시
work_order_assignees
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- work_order_id — uuid — Foreign key → work_orders.id — NOT NULL
- employee_id — uuid — Foreign key → employees.id — NOT NULL
- sort_order — int4 — NOT NULL — 동일
work_order_clauses
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- work_order_id — uuid — Foreign key → work_orders.id — NOT NULL
- standard_clause_item_id — uuid — Foreign key → standard_clause_items.id — NOT NULL
- sort_order — int4 — NOT NULL — 동일
work_order_documents
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- work_order_id — uuid — Foreign key → work_orders.id — NOT NULL
- clause_document_id — uuid — Foreign key → clause_documents.id — NOT NULL
- sort_order — int4 — NOT NULL — 동일
- is_required — bool — NOT NULL — 필수
work_orders
- id — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL — 생성
- updated_at — timestamptz — NOT NULL — 수정
- deleted_at — timestamptz — 삭제
- created_by — varchar(255) — 생성자
- updated_by — varchar(255) — 수정자
- lock_version — int4 — NOT NULL — 낙관적
- project_id — uuid — Foreign key → projects.id — NOT NULL
- project_structure_id — uuid — Foreign key → project_structures.id — NOT NULL
- wbs_id — uuid — Foreign key → project_wbs.id — NOT NULL
- name — text — NOT NULL — 업무지시
- model_type_id — uuid — Foreign key → model_types.id
- due_date — date — 기한일
- status — varchar — NOT NULL — 업무지시
- created_by_name — varchar — 등록자