analytics_documentdownloadlog

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
object_id int4 10 √ null
url varchar 2000 null
downloaded_at timestamptz 35,6 null
ip_address inet 2147483647 √ null
user_id int4 10 √ null
auth_user.id analytics_documentdownloadlog_user_id_c27e4ba7_fk_auth_user_idR
source varchar 100 null
analytics_documentsourcekey.key analytics_documentdo_source_1953d680_fk_analyticsR
document_type varchar 100 null
analytics_documenttypekey.key analytics_documentdo_document_type_ffebd8d2_fk_analyticsR

Indexes

Constraint Name Type Sort Column(s)
analytics_documentdownloadlog_pkey Primary key Asc id
analytics_documentdownloadlog_document_type_ffebd8d2 Performance Asc document_type
analytics_documentdownloadlog_document_type_ffebd8d2_like Performance Asc document_type
analytics_documentdownloadlog_downloaded_at_5e525372 Performance Asc downloaded_at
analytics_documentdownloadlog_object_id_d9b700dd Performance Asc object_id
analytics_documentdownloadlog_source_1953d680 Performance Asc source
analytics_documentdownloadlog_source_1953d680_like Performance Asc source
analytics_documentdownloadlog_user_id_c27e4ba7 Performance Asc user_id

Check Constraints

Constraint Name Constraint
analytics_documentdownloadlog_object_id_check ((object_id >= 0))

Relationships

Close relationships within degrees of separation