permit_usage_log


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
permit_usage_log_entry.permit_usage_log_id fk_permit_usage_log_entry_log_id C
request_received_at DATETIME 23 null
request_completed_at DATETIME 23 null
user_id INT 10 √ null
sys_users.user_id fk_permit_usage_log_user_id C
proxy_user_id INT 10 √ null
url TEXT 65535 null
origin TEXT 65535 √ null
method VARCHAR 16 null
source VARCHAR 8 null
status_code INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_permit_usage_log_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation