dealer_request_log


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
dealer_request_id INT 10 null
dealer_request.id fk_dealer_request_log_dealer_request R
user_id INT 10 null
sys_users.user_id fk_dealer_request_log_user_id R
proxy_user_id INT 10 √ null
sys_users.user_id fk_dealer_request_log_proxy_user_id R
subject VARCHAR 80 √ null
body VARCHAR 1000 √ null
timestamp DATETIME 19 null
source VARCHAR 255 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_dealer_request_log_dealer_request_idx Performance Asc dealer_request_id
fk_dealer_request_log_proxy_user_id_idx Performance Asc proxy_user_id
fk_dealer_request_log_user_id_idx Performance Asc user_id

Relationships

Close relationships within degrees of separation