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