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