👤 Magento_Customer · engine innodb
customer_visitor
Visitor Table
Columns (5)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| visitor_id PK | bigint unsigned | no | Visitor ID | |
| customer_id | int | yes | Customer ID | |
| session_id | varchar(1) | yes | Deprecated: Session ID value no longer used | |
| created_at | timestamp | no | CURRENT_TIMESTAMP | Created At |
| last_visit_at | timestamp | no | CURRENT_TIMESTAMP | Last Visit Time |
Keys & indexes
Primary key: visitor_id
Indexes
- CUSTOMER_VISITOR_CUSTOMER_ID (customer_id) btree
- CUSTOMER_VISITOR_LAST_VISIT_AT (last_visit_at) btree