go_chat

Tables (15)

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_chat_backups

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • canceled — boolean — NOT NULL
  • chat_buddy_id — bigint
  • file_deleted_at — timestamp
  • file_type — character
  • from_date — timestamp
  • progress_count — bigint
  • room_seq — bigint
  • to_date — timestamp
  • total_count — bigint
  • file_id — bigint — Foreign key → go_attach_files.id
  • requester_id — bigint — Foreign key → go_users.id

go_chat_buddies

  • id — bigint — Primary key — NOT NULL
  • join_room — boolean
  • join_time — timestamp
  • leave_time — timestamp
  • unread_message_count — integer
  • buddy_id — bigint — Foreign key → go_users.id
  • chat_message_id — bigint
  • chat_room_id — bigint — Foreign key → go_chat_rooms.id
  • chat_pubsub_id — bigint — Foreign key → go_chat_pubsubs.id
  • chat_room_name — character
  • user_id — bigint — Foreign key → go_users.id
  • company_id — bigint — Foreign key → go_companies.id
  • use_pin — boolean — NOT NULL

go_chat_message_aging_traces

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • oldest_date — timestamp
  • trace_type — character
  • company_id — bigint — Foreign key → go_companies.id

go_chat_message_attaches

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • attach_file_id — bigint — Foreign key → go_attach_files.id
  • deleted_at — timestamp

go_chat_message_histories

  • id — bigint — Primary key — NOT NULL
  • confirm — boolean
  • chat_buddy_id — bigint — Foreign key → go_chat_buddies.id
  • chat_message_id — bigint
  • user_id — bigint

go_chat_messages

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • confirm_count — integer
  • from_resource — character
  • message — text
  • message_type — character
  • recipient_count — integer
  • to_resource — character
  • chat_message_attach_id — bigint — Foreign key → go_chat_message_attaches.id
  • chat_room_id — bigint — Foreign key → go_chat_rooms.id
  • chat_pubsub_id — bigint — Foreign key → go_chat_pubsubs.id
  • from_user_id — bigint — Foreign key → go_users.id
  • to_user_id — bigint — Foreign key → go_users.id

go_chat_pubsub_targets

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp
  • is_company_target — boolean
  • chat_message_id — bigint
  • access_target_id — bigint — Foreign key → go_circles.id
  • exception_target_id — bigint — Foreign key → go_circles.id

go_chat_pubsubs

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • company_id — bigint — Foreign key → go_companies.id
  • creator_id — bigint — Foreign key → go_users.id

go_chat_room_members

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • chat_room_id — bigint — Foreign key → go_chat_rooms.id
  • member_id — bigint — Foreign key → go_users.id

go_chat_room_notices

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • chat_message_id — bigint — Foreign key → go_chat_messages.id
  • creator_id — bigint — Foreign key → go_users.id

go_chat_rooms

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • room_type — character
  • member_count — integer
  • company_id — bigint — Foreign key → go_companies.id
  • creator_id — bigint — Foreign key → go_users.id
  • chat_message_id — bigint
  • chat_room_notice_id — bigint — Foreign key → go_chat_room_notices.id

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
  • uuid — character
  • mail_domain_seq — bigint
  • company_group_id — bigint
  • group_depth — integer
  • manager_id — 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
  • fixed_ip — character
  • company_id — bigint
  • config_id — bigint
  • mail_user_seq — bigint
  • user_profile_id — bigint
  • user_push_setting_id — bigint
  • user_web_noti_setting_id — bigint
  • user_mobile_noti_setting_id — bigint
  • user_mail_noti_setting_id — bigint
  • user_noti_setting_id — bigint
  • use_cert — boolean
  • user_integration_id — bigint
  • force_to_change_password — boolean
  • delayed_pw_change_checked_at — timestamp