전자결재
테이블 (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 — 추가