calendar

Tables (13)

Calendars (go_calendars)

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • color — character — NOT NULL
  • default_calendar — boolean — NOT NULL
  • name — character
  • seq — integer — NOT NULL
  • type — character
  • visibility — character
  • company_id — bigint — Foreign key → go_companies.id
  • owner_id — bigint — Foreign key → go_users.id
  • access_target_id — bigint — Foreign key → go_circles.id

go_action_logs

  • id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • message — text
  • actor_id — bigint

go_calendar_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
  • calendar_id — bigint — Foreign key → Calendars.id

go_calendar_attendees

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • event_id — bigint
  • user_id — bigint — Foreign key → go_users.id
  • name — character
  • email — character

go_calendar_colors

  • id — bigint — Primary key — NOT NULL
  • value — character
  • calendar_id — bigint — Foreign key → Calendars.id
  • looker_id — bigint — Foreign key → go_users.id

go_calendar_event_logs

  • go_calendar_event_id — bigint — Primary key — NOT NULL
  • seq — integer — Primary key — NOT NULL
  • log_id — bigint — Foreign key → go_action_logs.id — NOT NULL

go_calendar_event_mappings

  • event_id — bigint — NOT NULL
  • calendar_id — bigint — Foreign key → Calendars.id — NOT NULL

go_calendar_follow_links

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • color — character — NOT NULL
  • sequence — integer — NOT NULL
  • setting_date — timestamp
  • state — character — NOT NULL
  • feed_calendar_id — bigint — Foreign key → Calendars.id — NOT NULL
  • follower_user_id — bigint — Foreign key → go_users.id — NOT NULL

go_calendar_reminders

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • finished_at — timestamp
  • method — character
  • minute — integer — NOT NULL
  • next_schedule — timestamp — NOT NULL
  • event_id — bigint

go_calendar_sync_data

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • resource_name — character
  • event_id — bigint

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_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