그룹웨어 전자결재
테이블 (50)
go_appr_act_copies
- id — bigint — 기본 키 — NOT NULL
- act_copy_document_id — bigint
- actor_id — bigint
go_appr_act_group_histories
- id — bigint — 기본 키 — NOT NULL
- group_name — character
- seq — integer — NOT NULL
- appr_flow_version_id — bigint — 외래 키 → go_appr_flow_versions.id
go_appr_activities
- id — bigint — 기본 키 — NOT NULL
- seq — integer — NOT NULL
- type — character — NOT NULL
- assigned — boolean — NOT NULL
- dept_name — character
- dept_id — bigint — 외래 키 → go_departments.id
- user_name — character
- user_id — bigint
- activity_group_id — bigint — 외래 키 → go_appr_activity_groups.id
- sync_activity_id — bigint — 외래 키 → go_appr_activities.id
- arbitrary — boolean — NOT NULL
- status — character
go_appr_activity_groups
- id — bigint — 기본 키 — NOT NULL
- group_name — character
- seq — integer — NOT NULL
- max_approval_count — integer
- use_approval — boolean — NOT NULL
- use_agreement — boolean — NOT NULL
- use_check — boolean — NOT NULL
- use_inspection — boolean — NOT NULL
- use_appr_line_rule — boolean — NOT NULL
- appr_flow_id — bigint — 외래 키 → go_appr_flows.id
go_appr_activity_histories
- id — bigint — 기본 키 — NOT NULL
- seq — integer — NOT NULL
- type — character — NOT NULL
- dept_id — bigint — 외래 키 → go_departments.id
- user_id — bigint
- activity_group_id — bigint — 외래 키 → go_appr_act_group_histories.id
- arbitrary — boolean — NOT NULL
go_appr_activity_logs
- id — bigint — 기본 키 — NOT NULL
- appr_action — character — NOT NULL
- approval_comment — character — haracter varying(1000
- completed_at — timestamp
- status — character
- type — character — NOT NULL
- appr_activity_id — bigint — 외래 키 → go_appr_activities.id
- deputy_log_id — bigint — 외래 키 → go_appr_activity_logs.id
- holding_log_id — bigint — 외래 키 → go_appr_activity_logs.id
- document_id — bigint — 외래 키 → go_appr_documents.id
- user_id — bigint
- user_name — character
- user_position_name — character
- user_sign_id — bigint — 외래 키 → go_appr_user_signs.id
- dept_name — character
- user_duty_name — character
go_appr_company_doc_folders
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- description — character
- name — character
- seq — integer — NOT NULL
- folder_user_scope — character — NOT NULL
- state — character — NOT NULL
- parent_id — bigint — 외래 키 → go_appr_company_doc_folders.id
- company_id — bigint — 외래 키 → go_companies.id
- folder_user_id — bigint — 외래 키 → go_circles.id
go_appr_company_folder_docs
- folder_id — bigint — 외래 키 → go_appr_company_doc_folders.id — NOT NULL
- document_id — bigint — 외래 키 → go_appr_documents.id — NOT NULL
go_appr_dept_doc_folders
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- description — character
- name — character
- seq — integer — NOT NULL
- parent_id — bigint — 외래 키 → go_appr_dept_doc_folders.id
- department_id — bigint — 외래 키 → go_departments.id
go_appr_dept_folder_documents
- folder_id — bigint — 외래 키 → go_appr_dept_doc_folders.id — NOT NULL
- document_id — bigint — 외래 키 → go_appr_documents.id — NOT NULL
go_appr_doc_access_logs
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- access_at — timestamp
- doc_drafter_id — bigint
- doc_drafter_name — character
- doc_form_name — character
- doc_id — bigint
- doc_status — integer
- doc_title — character
- type — integer
- access_user_id — bigint — NOT NULL
- company_id — bigint — 외래 키 → go_companies.id
go_appr_doc_attach_histories
- doc_version_id — bigint — 외래 키 → go_appr_document_versions.id — NOT NULL
- attach_id — bigint — 외래 키 → go_attaches.id — NOT NULL
go_appr_doc_attaches
- document_id — bigint — 외래 키 → go_appr_documents.id — NOT NULL
- attach_id — bigint — 외래 키 → go_attaches.id — NOT NULL
go_appr_doc_bodies
- id — bigint — 기본 키 — NOT NULL
- contents — text
- user_id — bigint
go_appr_doc_body_histories
- id — bigint — 기본 키 — NOT NULL
- contents — text
go_appr_doc_comments
- id — bigint — 외래 키 → go_comments.id — NOT NULL
- document_id — bigint — 외래 키 → go_appr_documents.id
go_appr_doc_master
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- type — character
- company_id — bigint — 외래 키 → go_companies.id
- user_id — bigint
- actions — character
go_appr_doc_readers
- id — bigint — 기본 키 — NOT NULL
- type — character — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- doc_read_type — character
- read_at — timestamp
- received_at — timestamp
- dept_id — bigint — 외래 키 → go_departments.id
- document_id — bigint — 외래 키 → go_appr_documents.id
- user_id — bigint
go_appr_doc_refer_histories
- doc_version_id — bigint — 외래 키 → go_appr_document_versions.id — NOT NULL
- doc_reference_id — bigint — 외래 키 → go_appr_documents.id — NOT NULL
go_appr_doc_references
- document_id — bigint — 외래 키 → go_appr_documents.id — NOT NULL
- reference_id — bigint — 외래 키 → go_appr_documents.id — NOT NULL
go_appr_doc_subscriber_masters
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- dept_id — bigint — 외래 키 → go_departments.id
- user_id — bigint
go_appr_doc_subscribers
- id — bigint — 기본 키 — NOT NULL
- type — character — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- assigned — boolean — NOT NULL
- doc_read_type — integer
- received_at — timestamp
- subscriber_id — bigint
- subscriber_name — character
- subscriber_type — integer
- document_id — bigint — 외래 키 → go_appr_documents.id
- subscriber_dept_id — bigint
- reception_return_comment — character — haracter varying(1000
go_appr_doc_variables
- name — character — 기본 키 — NOT NULL
- document_id — bigint — 외래 키 → go_appr_documents.id — NOT NULL
- value — text
go_appr_docbody_history_images
- docbody_history_id — bigint — 외래 키 → go_appr_doc_body_histories.id — NOT NULL
- image_id — bigint — 외래 키 → go_attach_files.id — NOT NULL
go_appr_docnum_configs
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- digit — integer
- seq_flag — boolean — NOT NULL
- type — integer
- use_flag — boolean
- company_id — bigint — 외래 키 → go_companies.id
go_appr_docnum_sequences
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- seq — integer — NOT NULL
- user_str — character
- company_id — bigint — 외래 키 → go_companies.id
go_appr_document_versions
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- version — integer — NOT NULL
- doc_body_id — bigint — 외래 키 → go_appr_doc_body_histories.id
- document_id — bigint — 외래 키 → go_appr_documents.id
- user_id — bigint
go_appr_documents
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- appr_status — character
- attach_count — integer
- comment_count — integer
- completed_at — timestamp
- doc_num — character
- doc_num_prefix — character
- doc_num_seq — integer
- doc_status — character
- doc_year — integer
- drafted_at — timestamp
- drafter_dept_id — bigint
- drafter_dept_name — character
- drafter_employee_number — character
- drafter_id — bigint
- drafter_name — character
- drafter_position_id — bigint
- drafter_position_name — character
- form_alias — character
- form_name — character
- is_public — boolean — NOT NULL
- latest_activity_completed_at — timestamp
- reference_count — integer
- reception_return_comment — character — haracter varying(1000
- title — character
- act_copy_id — bigint — 외래 키 → go_appr_act_copies.id
- company_id — bigint — 외래 키 → go_companies.id
- company_doc_folder_id — bigint — 외래 키 → go_appr_company_doc_folders.id
- doc_body_id — bigint — 외래 키 → go_appr_doc_bodies.id
- form_id — bigint — 외래 키 → go_appr_forms.id
- latest_activity_user_id — bigint
- security_level_id — bigint — 외래 키 → go_appr_security_levels.id
- receiver_id — bigint
- origin_receiver_id — bigint
- receiver_dept_id — bigint
- reception_origin_id — bigint
- received_at — timestamp
- doc_type — character
- officially_sent — boolean — NOT NULL
- re_draft — boolean — NOT NULL
- is_emergency — boolean — NOT NULL
- doc_owner_dept_id — bigint
- official_doc_owner_dept_id — bigint
- received_doc_owner_dept_id — bigint
- locale — character
go_appr_favorite_forms
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- seq — integer — NOT NULL
- department_id — bigint — 외래 키 → go_departments.id
- form_id — bigint — 외래 키 → go_appr_forms.id
- user_id — bigint
go_appr_flow_versions
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- version — integer — NOT NULL
- document_id — bigint — 외래 키 → go_appr_documents.id
- user_id — bigint
go_appr_flows
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- use_parallel_agreement — boolean — NOT NULL
- document_id — bigint
go_appr_form_activities
- id — bigint — 기본 키 — NOT NULL
- seq — integer — NOT NULL
- type — character — NOT NULL
- dept_id — bigint — 외래 키 → go_departments.id
- user_id — bigint
- activity_group_id — bigint — 외래 키 → go_appr_form_activity_groups.id
go_appr_form_activity_groups
- id — bigint — 기본 키 — NOT NULL
- group_name — character
- seq — integer — NOT NULL
- max_approval_count — integer
- use_approval — boolean — NOT NULL
- use_agreement — boolean — NOT NULL
- use_check — boolean — NOT NULL
- use_inspection — boolean — NOT NULL
- use_appr_line_rule — boolean — NOT NULL
- form_id — bigint — 외래 키 → go_appr_forms.id
go_appr_form_folders
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- name — character — NOT NULL
- seq — integer — NOT NULL
- parent_id — bigint — 외래 키 → go_appr_form_folders.id
- company_id — bigint — 외래 키 → go_companies.id
- folder_state — character — NOT NULL
go_appr_form_help_images
- form_help_id — bigint — 외래 키 → go_appr_form_helps.id — NOT NULL
- image_id — bigint — 외래 키 → go_attach_files.id — NOT NULL
go_appr_form_helps
- id — bigint — 기본 키 — NOT NULL
- contents — text
go_appr_form_htmls
- id — bigint — 기본 키 — NOT NULL
- contents — text
go_appr_forms
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- act_copy_alterable — boolean — NOT NULL
- activity_editable — boolean — NOT NULL
- alias — character — NOT NULL
- arbt_decision_active — boolean — NOT NULL
- assigned_activity_deletable — boolean — NOT NULL
- code — character
- document_editable — boolean — NOT NULL
- document_open_editable — boolean — NOT NULL
- document_openable — boolean — NOT NULL
- folder_changeable — boolean — NOT NULL
- form_user_scope — character — NOT NULL
- integration_bean_name — character
- integration_name — character
- is_integration_active — boolean — NOT NULL
- latest_version — boolean — NOT NULL
- name — character — NOT NULL
- preserve_duration_editable — boolean — NOT NULL
- preserve_duration_in_year — integer — NOT NULL
- reader_active — boolean — NOT NULL
- receiver_editable — boolean — NOT NULL
- reception_active — boolean — NOT NULL
- reference_active — boolean — NOT NULL
- referrer_editable — boolean — NOT NULL
- referrer_id — bigint
- security_level_active — boolean — NOT NULL
- security_level_editable — boolean — NOT NULL
- seq — integer — NOT NULL
- state — character — NOT NULL
- type — character — NOT NULL
- version — integer — NOT NULL
- company_id — bigint — 외래 키 → go_companies.id — NOT NULL
- company_doc_folder_id — bigint — 외래 키 → go_appr_company_doc_folders.id
- creator_id — bigint
- folder_id — bigint — 외래 키 → go_appr_form_folders.id
- form_user_id — bigint — 외래 키 → go_circles.id
- origin_id — bigint — 외래 키 → go_appr_forms.id
- receiver_id — bigint — 외래 키 → go_circles.id
- security_level_id — bigint — 외래 키 → go_appr_security_levels.id — NOT NULL
- template_id — bigint — 외래 키 → go_appr_form_htmls.id
- admin_id — bigint — 외래 키 → go_circles.id
- form_help_id — bigint — 외래 키 → go_appr_form_helps.id
- use_help — boolean — NOT NULL
- official_document_sendable — boolean
- external_script — character
- appr_line_rule_id — bigint — 외래 키 → go_appr_line_rules.id
- script_body_id — bigint
- official_form_id — bigint
- official_sender_id — bigint
- official_sign_id — bigint
- reader_id — bigint — 외래 키 → go_circles.id
- allow_mobile_approval — boolean
go_appr_line_activity_groups
- id — bigint — 기본 키 — NOT NULL
- group_name — character
- seq — integer — NOT NULL
- appr_line_id — bigint — 외래 키 → go_appr_lines.id
go_appr_line_rules
- id — bigint — 기본 키 — NOT NULL
- company_id — bigint — 외래 키 → go_companies.id
- name — character
- seq — integer — NOT NULL
- state — character — NOT NULL
go_appr_lines
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- title — character
- type — character — NOT NULL
- modifier_id — bigint
- owner_company_id — bigint — 외래 키 → go_companies.id
- owner_user_id — bigint
- register_id — bigint
- use_parallel_agreement — boolean — NOT NULL
go_appr_security_levels
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- level_value — integer
- name — character
- use_flag — boolean — NOT NULL
- company_id — bigint — 외래 키 → go_companies.id
go_appr_user_signs
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- use_flag — boolean — NOT NULL
- attach_file_id — bigint — 외래 키 → go_attach_files.id
- user_id — bigint
go_attach_files
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- extension — character
- host_id — character
- name — character
- path — character
- length — bigint
go_attaches
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- status — integer
go_circles
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- app — character
- company_id — bigint — 외래 키 → go_companies.id
go_comments
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- sort_criteria — timestamp
- attach_flag — boolean — NOT NULL
- message — text
- reply_count — integer — NOT NULL
- thread_id — bigint — 외래 키 → go_comments.id
- user_id — bigint
- emoticon_path — varchar(255)
go_companies
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- algorithm_name — character
- company_quota — bigint
- delete_user_count — integer
- deleted_at — timestamp
- domain_name — character — NOT NULL
- locale — character — NOT NULL
- manager_name — character
- name — character — NOT NULL
- online_user_count — integer
- stop_user_count — integer
- total_account_quota — bigint
- used_count — integer
- user_count — integer
- wait_user_count — integer
- site_url — character
- uuid — character
- mail_domain_seq — bigint
- company_group_id — bigint
- group_depth — integer
- manager_id — character
go_departments
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- code — character
- deleted_at — timestamp
- dept_alias — character
- email_id — character
- name — character
- path — character
- search_name — character
- sort_flag — boolean — NOT NULL
- sort_order — integer — NOT NULL
- company_id — bigint — 외래 키 → go_companies.id
- parent_id — bigint — 외래 키 → go_departments.id
go_domain_codes
- id — bigint — 기본 키 — NOT NULL
- code — character
- code_type — character
- en_name — character
- jp_name — character
- ko_name — character
- vi_name — character
- sort_order — integer — NOT NULL
- zhcn_name — character
- zhtw_name — character
- company_id — bigint — 외래 키 → go_companies.id