access_count_logs

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
access_count_url_id BIGINT UNSIGNED 20 null
access_count_urls.id access_count_logs_access_count_url_id_foreignR

URL ID
customer_id BIGINT UNSIGNED 20 √ null
customers.id access_count_logs_customer_id_foreignR

顧客ID
store_id BIGINT UNSIGNED 20 √ null
stores.id access_count_logs_store_id_foreignR

店舗ID
staff_id BIGINT UNSIGNED 20 √ null
staffs.id access_count_logs_staff_id_foreignR

担当者ID
access_datetime DATETIME 26 null

アクセス日時
created_at TIMESTAMP 26 √ null
updated_at TIMESTAMP 26 √ null
deleted_at TIMESTAMP 26 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
access_count_logs_access_count_url_id_foreign Performance Asc access_count_url_id
access_count_logs_customer_id_foreign Performance Asc customer_id
access_count_logs_staff_id_foreign Performance Asc staff_id
access_count_logs_store_id_foreign Performance Asc store_id

Relationships

Close relationships within degrees of separation