그룹웨어 전자결재

테이블 (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