go_appr_doc

Tables (21)

go_appr_doc_access_logs

  • id — bigint — Primary key — 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 — Foreign key → go_users.id — NOT NULL
  • company_id — bigint — Foreign key → go_companies.id

go_appr_doc_attaches

  • document_id — bigint — Foreign key → go_appr_documents.id — NOT NULL
  • attach_id — bigint — Foreign key → go_attaches.id — NOT NULL

go_appr_doc_bodies

  • id — bigint — Primary key — NOT NULL
  • contents — text
  • user_id — bigint — Foreign key → go_users.id

go_appr_doc_body_histories

  • id — bigint — Primary key — NOT NULL
  • contents — text

go_appr_doc_folder_shares

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • doc_folder_id — bigint
  • folder_type — character
  • include_sub_dept — boolean
  • seq — integer — NOT NULL
  • shared_by_id — bigint — Foreign key → go_users.id
  • target_dept_id — bigint — Foreign key → go_departments.id
  • target_user_id — bigint — Foreign key → go_users.id

go_appr_doc_master

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • type — character
  • company_id — bigint — Foreign key → go_companies.id
  • user_id — bigint — Foreign key → go_users.id
  • actions — character

go_appr_doc_reader_histories

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • read_count — integer — NOT NULL
  • document_id — bigint — Foreign key → go_appr_documents.id — NOT NULL
  • reader_id — bigint — Foreign key → go_users.id — NOT NULL

go_appr_doc_readers

  • id — bigint — Primary key — 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 — Foreign key → go_departments.id
  • document_id — bigint — Foreign key → go_appr_documents.id
  • user_id — bigint — Foreign key → go_users.id

go_appr_doc_references

  • document_id — bigint — Foreign key → go_appr_documents.id — NOT NULL
  • reference_id — bigint — Foreign key → go_appr_documents.id — NOT NULL

go_appr_doc_subscriber_masters

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • dept_id — bigint — Foreign key → go_departments.id
  • user_id — bigint — Foreign key → go_users.id

go_appr_doc_subscribers

  • id — bigint — Primary key — 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 — Foreign key → go_appr_documents.id
  • subscriber_dept_id — bigint
  • reception_return_comment — character — haracter varying(1000

go_appr_doc_variables

  • name — character — Primary key — NOT NULL
  • document_id — bigint — Foreign key → go_appr_documents.id — NOT NULL
  • value — text

go_appr_document_versions

  • id — bigint — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • version — integer — NOT NULL
  • doc_body_id — bigint
  • document_id — bigint
  • 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
  • company_id — bigint
  • company_doc_folder_id — bigint
  • doc_body_id — bigint
  • form_id — bigint
  • latest_activity_user_id — bigint
  • security_level_id — bigint
  • 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_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_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
  • user_id — bigint
  • emoticon_path — character

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
  • parent_id — bigint

go_users

  • id — bigint — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp
  • employee_number — character
  • locale — character — NOT NULL
  • last_logined_at — timestamp
  • login_count — integer
  • login_fail_count — integer
  • login_id — character
  • login_locked_at — timestamp
  • mail_group — character
  • name — character — NOT NULL
  • name_hurigana — character
  • noti — character
  • open_type — character
  • password — character — NOT NULL
  • password_changed_at — timestamp
  • search_name — character
  • status — character
  • time_zone — character
  • fixed_ip — character
  • company_id — bigint
  • config_id — bigint
  • mail_user_seq — bigint
  • user_profile_id — bigint
  • user_push_setting_id — bigint
  • user_web_noti_setting_id — bigint
  • user_mobile_noti_setting_id — bigint
  • user_mail_noti_setting_id — bigint
  • user_noti_setting_id — bigint
  • use_cert — boolean
  • user_integration_id — bigint
  • force_to_change_password — boolean
  • delayed_pw_change_checked_at — timestamp