전자결재

테이블 (21)

approval_authority

  • authority_id — BIGSERIAL
  • position_id — BIGINT — NOT NULL
  • template_id — BIGINT — NOT NULL
  • min_amount — NUMERIC(15,2)
  • max_amount — NUMERIC(15,2) — 최대
  • can_approve — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

approval_line

  • line_id — BIGSERIAL
  • document_id — BIGINT — NOT NULL
  • approver_id — BIGINT — NOT NULL
  • sequence — INT — NOT NULL — 결재
  • approval_type — VARCHAR(20) — NOT NULL — 결재
  • status — VARCHAR(20) — NOT NULL — 결재
  • comment — TEXT — EX
  • approved_at — TIMESTAMP
  • is_required — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

approval_line_template

  • line_template_id — BIGSERIAL
  • template_id — BIGINT
  • template_name — VARCHAR(200) — NOT NULL
  • user_id — BIGINT — NOT NULL
  • is_default — BOOLEAN — NOT NULL — 기본
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

approval_line_template_detail

  • detail_id — BIGSERIAL
  • line_template_id — BIGINT — NOT NULL
  • sequence — INT — NOT NULL
  • approval_type — VARCHAR(20) — NOT NULL
  • position_id — BIGINT
  • organization_id — BIGINT — 조직
  • is_required — BOOLEAN — NOT NULL

approval_rule

  • rule_id — BIGSERIAL
  • template_id — BIGINT — NOT NULL
  • rule_name — VARCHAR(200) — NOT NULL
  • condition_type — VARCHAR(50) — NOT NULL
  • condition_value — JSONB — NOT NULL — 조건
  • priority — INT — NOT NULL — 우선순위
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

approval_rule_line

  • rule_line_id — BIGSERIAL
  • rule_id — BIGINT — NOT NULL
  • sequence — INT — NOT NULL
  • approval_type — VARCHAR(20) — NOT NULL
  • position_id — BIGINT
  • organization_id — BIGINT
  • is_required — BOOLEAN — NOT NULL

business_trip_request

  • trip_id — BIGSERIAL
  • document_id — BIGINT — NOT NULL
  • destination — VARCHAR(200) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • total_days — NUMERIC(5,1) — NOT NULL
  • estimated_cost — NUMERIC(15,2) — 예상
  • extra_data — JSONB

delegation

  • delegation_id — BIGSERIAL
  • delegator_id — BIGINT — NOT NULL
  • delegatee_id — BIGINT — NOT NULL — 대리자
  • delegation_type — VARCHAR(20) — NOT NULL — 타입
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • reason — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

document (전자결제)

  • document_id — BIGSERIAL
  • template_id — BIGINT — NOT NULL
  • drafter_id — BIGINT — NOT NULL
  • document_number — VARCHAR(50) — NOT NULL — 문서
  • title — VARCHAR(500) — NOT NULL
  • content — JSONB — 문서
  • status — VARCHAR(20) — NOT NULL — 문서
  • drafted_at — TIMESTAMP
  • submitted_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

document_attachment

  • attachment_id — BIGSERIAL
  • document_id — BIGINT — NOT NULL
  • file_name — VARCHAR(500) — NOT NULL
  • file_path — VARCHAR(1000) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • file_type — VARCHAR(100)
  • uploaded_at — TIMESTAMP — NOT NULL

document_category

  • category_id — BIGSERIAL
  • category_code — VARCHAR(50) — NOT NULL
  • category_name — VARCHAR(100) — NOT NULL — 카테고리명
  • description — TEXT
  • icon — VARCHAR(50) — 아이콘
  • display_order — INT — NOT NULL — 표시
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

document_history

  • history_id — BIGSERIAL
  • document_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • action — VARCHAR(50) — NOT NULL
  • comment — TEXT — EX
  • created_at — TIMESTAMP — NOT NULL

document_search_index

  • index_id — BIGSERIAL
  • document_id — BIGINT — NOT NULL
  • index_key — VARCHAR(100) — NOT NULL
  • index_value — TEXT — NOT NULL — 인덱스
  • data_type — VARCHAR(20) — NOT NULL — 데이터

document_template (전자결제템플릿)

  • template_id — BIGSERIAL
  • template_code — VARCHAR(50) — NOT NULL
  • template_name — VARCHAR(200) — NOT NULL
  • category_id — BIGINT — NOT NULL
  • template_type — VARCHAR(20) — NOT NULL — 템플릿
  • storage_type — VARCHAR(20) — NOT NULL — 저장
  • form_schema — JSONB — NOT NULL — 양식
  • detail_table_name — VARCHAR(100) — 상세
  • is_active — BOOLEAN — NOT NULL
  • is_deletable — BOOLEAN — NOT NULL — 삭제
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

expense_item

  • item_id — BIGSERIAL
  • expense_id — BIGINT — NOT NULL
  • item_name — VARCHAR(200) — NOT NULL
  • quantity — INT — NOT NULL
  • unit_price — NUMERIC(15,2) — NOT NULL
  • subtotal — NUMERIC(15,2) — NOT NULL
  • display_order — INT — NOT NULL

expense_request

  • expense_id — BIGSERIAL
  • document_id — BIGINT — NOT NULL
  • expense_type — VARCHAR(50) — NOT NULL
  • amount — NUMERIC(15,2) — NOT NULL
  • expense_date — DATE — NOT NULL
  • payment_method — VARCHAR(50)
  • vendor — VARCHAR(200) — 거래처
  • extra_data — JSONB

form_component

  • component_id — BIGSERIAL
  • component_code — VARCHAR(50) — NOT NULL
  • component_name — VARCHAR(100) — NOT NULL
  • component_type — VARCHAR(50) — NOT NULL — 컴포넌트
  • category — VARCHAR(50) — NOT NULL — 카테고리
  • config_schema — JSONB — NOT NULL — 설정
  • validation_schema — JSONB — NOT NULL — 검증
  • icon — VARCHAR(50)
  • display_order — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

notification

  • notification_id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • document_id — BIGINT
  • notification_type — VARCHAR(50) — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

overtime_request

  • overtime_id — BIGSERIAL
  • document_id — BIGINT — NOT NULL
  • work_date — DATE — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME — NOT NULL
  • total_hours — NUMERIC(5,2) — NOT NULL
  • extra_data — JSONB

template_version

  • version_id — BIGSERIAL
  • template_id — BIGINT — NOT NULL
  • version_number — INT — NOT NULL
  • form_schema — JSONB — NOT NULL
  • created_by — BIGINT — NOT NULL
  • change_description — TEXT — 변경
  • created_at — TIMESTAMP — NOT NULL

vacation_request

  • vacation_id — BIGSERIAL
  • document_id — BIGINT — NOT NULL
  • vacation_type — VARCHAR(50) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • total_days — NUMERIC(5,1) — NOT NULL
  • extra_data — JSONB — 추가