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