staffs

184 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
access_count_logs.staff_id access_count_logs_staff_id_foreignR
appointments.service_operator_id appointments_service_operator_id_foreignR
bulk_messages.staff_id bulk_messages_staff_id_foreignR
bulk_operation_customer_lists.staff_id bulk_operation_customer_lists_staff_id_foreignR
bulk_operation_histories.staff_id bulk_operation_histories_staff_id_foreignR
customer_interaction_histories.staff_id customer_interaction_histories_staff_id_foreignR
estimation_action_logs.staff_id estimation_action_logs_staff_id_foreignR
estimation_approvals.staff_id estimation_approvals_staff_id_foreignR
estimations.approver_id estimations_approver_id_foreignR
estimations.author_id estimations_author_id_foreignR
export_analysis_csv_files.login_staff_id export_analysis_csv_files_login_staff_id_foreignR
export_analysis_csv_files.staff_id export_analysis_csv_files_staff_id_foreignR
message_read_times.staff_id message_read_times_staff_id_foreignR
messages.staff_id messages_staff_id_foreignR
read_messages.staff_id read_messages_staff_id_foreignR
search_favorites.staff_id search_favorites_staff_id_foreignR
search_histories.staff_id search_histories_staff_id_foreignR
staff_device_tokens.staff_id staff_device_tokens_staff_id_foreignR
staff_notification_settings.staff_id staff_notification_settings_staff_id_foreignR
staff_operable_nested_groups.staff_id staff_operable_nested_groups_staff_id_foreignR
staff_settings.staff_id staff_settings_staff_id_foreignR
store_customers.application_staff_id store_customers_application_staff_id_foreignR
store_customers.contract_staff_id store_customers_contract_staff_id_foreignR
store_customers.inquiry_staff_id store_customers_inquiry_staff_id_foreignR
store_customers.main_staff_id store_customers_main_staff_id_foreignR
store_customers.viewing_staff_id store_customers_viewing_staff_id_foreignR
store_customers.visit_staff_id store_customers_visit_staff_id_foreignR
suggestions.staff_id suggestions_staff_id_foreignR
tasks.staff_id tasks_staff_id_foreignR
web_meetings.staff_id web_meetings_staff_id_foreignR

PK
store_id BIGINT UNSIGNED 20 null
stores.id staffs_store_id_foreignR

店舗ID
role_id BIGINT UNSIGNED 20 null
roles.id staffs_role_id_foreignR

ロールID
kimaroom_id BIGINT UNSIGNED 20 null

キマRoom!担当ID
name VARCHAR 255 null

従業員名
email VARCHAR 255 null

メールアドレス
login_id VARCHAR 255 null
job_batches.id Implied ConstraintR

ログインID
is_admin BIT 1 null

会社管理者フラグ
admin_flg INT UNSIGNED 10 0

管理者フラグ
sort_order TINYINT UNSIGNED 3 0

表示順
created_at TIMESTAMP 26 √ null
updated_at TIMESTAMP 26 √ null
deleted_at TIMESTAMP 26 √ null
kimaroom_access_token VARCHAR 1000 √ null

キマRoom!アクセストークン

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
staffs_kimaroom_id_unique Must be unique Asc kimaroom_id
staffs_role_id_foreign Performance Asc role_id
staffs_store_id_foreign Performance Asc store_id

Relationships

Close relationships within degrees of separation