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 — 등록자