timeline

Tables (22)

go_circles

  • id — bigint — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • app — character
  • company_id — bigint

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_timeline_access_allow_beacons

  • id — bigint — Primary key — NOT NULL
  • location — character — NOT NULL
  • uuid — character — NOT NULL
  • major — integer — NOT NULL
  • minor — integer — NOT NULL
  • description — character
  • company_id — bigint — Foreign key → go_companies.id
  • timeline_work_place_id — bigint — Foreign key → go_timeline_work_places.id

go_timeline_access_allow_gps

  • id — bigint — Primary key — NOT NULL
  • latitude — double
  • longitude — double
  • name — character — NOT NULL
  • radius — integer
  • company_id — bigint — Foreign key → go_companies.id
  • timeline_work_place_id — bigint — Foreign key → go_timeline_work_places.id

go_timeline_access_allow_ips

  • id — bigint — Primary key — NOT NULL
  • ip_name — character
  • ip_range — character
  • company_id — bigint — Foreign key → go_companies.id
  • timeline_work_place_id — bigint — Foreign key → go_timeline_work_places.id
  • description — character

go_timeline_access_beacons

  • id — bigint — Primary key — NOT NULL
  • location — character — NOT NULL
  • uuid — character — NOT NULL
  • major — integer — NOT NULL
  • minor — integer — NOT NULL
  • description — character
  • company_id — bigint — Foreign key → go_companies.id
  • timeline_work_place_id — bigint — Foreign key → go_timeline_work_places.id

go_timeline_access_gps

  • id — bigint — Primary key — NOT NULL
  • latitude — double
  • longitude — double
  • name — character — NOT NULL
  • radius — integer
  • company_id — bigint — Foreign key → go_companies.id
  • timeline_work_place_id — bigint — Foreign key → go_timeline_work_places.id

go_timeline_approvals

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • base_date — character
  • end_time — timestamp
  • hours — real
  • including_working_time — boolean — NOT NULL
  • name — character — NOT NULL
  • reasons — character
  • reference_id — character
  • start_time — timestamp
  • sync — boolean — NOT NULL
  • timeline_approval_status — character
  • timeline_approval_type — character
  • timeline_one_day_id — bigint — Foreign key → go_timeline_one_days.id
  • vacation_status_id — bigint — Foreign key → go_vacation_statuses.id

go_timeline_change_history

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • after_status_content — character
  • after_status_name — character
  • after_status_time — character
  • before_status_content — character
  • before_status_name — character
  • before_status_time — character
  • reason — character
  • timeline_change_type — character
  • working_day — character
  • modifier_id — bigint — Foreign key → go_users.id
  • user_id — bigint — Foreign key → go_users.id

go_timeline_group

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • access_setting — character
  • default_group — boolean — NOT NULL
  • use_mobile_gps — boolean
  • latest_version — boolean — NOT NULL
  • name — character
  • description — character
  • sort_order — integer — NOT NULL
  • status — character
  • fixed_time — character
  • relative_hour — integer
  • type — integer
  • ignore_after_end — boolean
  • ignore_after_start — boolean
  • ignore_before_start — boolean
  • night_end_time — character
  • night_start_time — character
  • work_end_time — character
  • work_start_time — character
  • work_day — character
  • end_date — timestamp
  • start_date — timestamp
  • use_period_setting — boolean — NOT NULL
  • version — integer — NOT NULL
  • working_type — character
  • access_target_id — bigint — Foreign key → go_circles.id
  • exception_target_id — bigint — Foreign key → go_circles.id
  • company_id — bigint — Foreign key → go_companies.id
  • origin_id — bigint — Foreign key → go_timeline_group.id
  • duty_start_time — character
  • duty_end_time — character
  • consensus_hours_per_day — real
  • enable_duty_time — boolean
  • warning_check — boolean
  • private_ip_auto_save — boolean

go_timeline_group_allow_device

  • timeline_group_id — bigint — Foreign key → go_timeline_group.id — NOT NULL
  • allow_device — character

go_timeline_group_rest_periods

  • timeline_group_id — bigint — Foreign key → go_timeline_group.id — NOT NULL
  • end_time — character
  • name — character
  • start_time — character
  • seq — integer — NOT NULL

go_timeline_history

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • auto — boolean — NOT NULL
  • check_ip — character
  • check_latitude — character
  • check_longitude — character
  • check_time — timestamp
  • client_type — character
  • edited_check_time — boolean — NOT NULL
  • sync — boolean — NOT NULL
  • timeline_status_id — bigint — Foreign key → go_timeline_status.id
  • timeline_one_day_id — bigint — Foreign key → go_timeline_one_days.id
  • content — character
  • reason — character
  • timezone_offset — integer
  • beacon_uuid — character

go_timeline_masters

  • 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_timeline_noti_histories

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • user_id — bigint — Foreign key → go_users.id
  • timeline_noti_type — character
  • working_day — character
  • week_first_day — character
  • month_first_day — character
  • timeline_noti_setting_id — bigint

go_timeline_one_days

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • department_name — character
  • early — boolean — NOT NULL
  • extension — bigint — NOT NULL
  • holi_day — boolean — NOT NULL
  • night — bigint — NOT NULL
  • normal — bigint — NOT NULL
  • tardy — boolean — NOT NULL
  • total — bigint — NOT NULL
  • working_day — character
  • company_id — bigint — Foreign key → go_companies.id
  • timeline_group_id — bigint — Foreign key → go_timeline_group.id
  • user_id — bigint — Foreign key → go_users.id
  • timeline_one_month_id — bigint — Foreign key → go_timeline_one_months.id
  • timeline_one_week_id — bigint — Foreign key → go_timeline_one_weeks.id
  • has_vacation — boolean
  • vacation_hours — real
  • timeline_version — integer
  • missing_clock_in — boolean
  • missing_clock_out — boolean
  • absence — boolean
  • late_clock_out — boolean
  • auto_clock_out — boolean
  • etc_status — boolean
  • warning — boolean
  • un_auth_devices — character
  • has_holiday_work — boolean

go_timeline_one_months

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • department_name — character
  • extension — bigint — NOT NULL
  • night — bigint — NOT NULL
  • normal — bigint — NOT NULL
  • total — bigint — NOT NULL
  • early — integer — NOT NULL
  • tardy — integer — NOT NULL
  • holi_day — integer — NOT NULL
  • first_day — character
  • last_day — character
  • company_id — bigint — Foreign key → go_companies.id
  • timeline_group_id — bigint — Foreign key → go_timeline_group.id
  • user_id — bigint — Foreign key → go_users.id
  • future — bigint
  • absence — integer
  • un_commute_completed — integer
  • vacation_day — integer
  • vacation_hours — real
  • timeline_version — integer
  • late_clock_out — integer
  • auto_clock_out — integer
  • warning — integer
  • missing_clock_in — integer
  • missing_clock_out — integer
  • etc_status — integer
  • un_auth_device — integer

go_timeline_one_weeks

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • department_name — character
  • extension — bigint — NOT NULL
  • night — bigint — NOT NULL
  • normal — bigint — NOT NULL
  • total — bigint — NOT NULL
  • early — integer — NOT NULL
  • tardy — integer — NOT NULL
  • holi_day — integer — NOT NULL
  • first_day — character
  • last_day — character
  • company_id — bigint — Foreign key → go_companies.id
  • timeline_group_id — bigint — Foreign key → go_timeline_group.id
  • user_id — bigint — Foreign key → go_users.id
  • future — bigint
  • absence — integer
  • un_commute_completed — integer
  • vacation_day — integer
  • vacation_hours — real
  • timeline_version — integer
  • late_clock_out — integer
  • auto_clock_out — integer
  • warning — integer
  • missing_clock_in — integer
  • missing_clock_out — integer
  • etc_status — integer
  • un_auth_device — integer

go_timeline_status

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • attnd_status_id — bigint
  • deleted_at — timestamp
  • include_working_time — boolean — NOT NULL
  • latest_version — boolean — NOT NULL
  • name — character
  • timeline_code — character
  • type — character — NOT NULL
  • useyn — boolean — NOT NULL
  • version — integer — NOT NULL
  • company_id — bigint — Foreign key → go_companies.id
  • origin_id — bigint — Foreign key → go_timeline_status.id

go_timeline_work_places

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • name — character — NOT NULL
  • use_beacon — boolean
  • use_gps — boolean
  • use_ip — boolean
  • company_id — bigint — Foreign key → go_companies.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

go_vacation_statuses

  • id — bigint — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • code — character
  • company_id — bigint
  • enable — boolean — NOT NULL
  • latest_version — boolean — NOT NULL
  • name — character
  • use_vacation_point — boolean — NOT NULL
  • version — integer — NOT NULL
  • origin_id — bigint
  • holiday_policy — character
  • paid — boolean
  • limited — boolean
  • available_max — numeric