dashboard
Tables (11)
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_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
- mail_domain_seq — bigint
- company_group_id — bigint
- group_depth — integer
- manager_id — character
- uuid — character
go_dashboard_admins
- id — bigint — Primary key — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- company_id — bigint — Foreign key → go_companies.id
- user_id — bigint — Foreign key → go_users.id
go_dashboard_g_opts
- id — bigint — Primary key — NOT NULL
- contents — text
go_dashboard_g_opts_images
- go_dashboard_g_opt_id — bigint — Foreign key → go_dashboard_g_opts.id — NOT NULL
- image_id — bigint — Foreign key → go_attach_files.id — NOT NULL
go_dashboard_gadgets
- id — bigint — Primary key — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- box_number — integer — NOT NULL
- box_order — integer — NOT NULL
- option_id — bigint — Foreign key → go_dashboard_g_opts.id
- personalization_auth — character
- personalized_state — character
- creator_id — bigint — Foreign key → go_users.id
- dashboard_id — bigint — Foreign key → go_dashboards.id
- original_id — bigint — Foreign key → go_dashboard_gadgets.id
- spec_id — bigint
go_dashboard_gadgets_attaches
- go_dashboard_gadget_id — bigint — Foreign key → go_dashboard_gadgets.id — NOT NULL
- attach_id — bigint — Foreign key → go_attaches.id — NOT NULL
go_dashboard_gspec_usages
- id — bigint — Primary key — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- active — boolean — NOT NULL
- company_id — bigint — Foreign key → go_companies.id
- spec_id — bigint
go_dashboards
- id — bigint — Primary key — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- activated — boolean — NOT NULL
- box_count — integer — NOT NULL
- gadget_addable — boolean — NOT NULL
- layout — integer — NOT NULL
- owner_type — character
- seq — integer
- title — character
- company_id — bigint — Foreign key → go_companies.id
- user_id — bigint — Foreign key → go_users.id
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
- company_id — bigint
- config_id — bigint
- mail_user_seq — bigint
- user_profile_id — bigint
- user_push_setting_id — bigint
- use_cert — boolean
- user_integration_id — bigint
- force_to_change_password — boolean
- user_web_noti_setting_id — bigint
- user_mobile_noti_setting_id — bigint
- user_mail_noti_setting_id — bigint
- user_noti_setting_id — bigint
- fixed_ip — character
- delayed_pw_change_checked_at — timestamp