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