projectlist_export


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version BIGINT 19 null
complete_date DATETIME 23 √ null
duration INT 10 √ null
file_name VARCHAR 128 √ null
format VARCHAR 255 null
message TEXT 65535 √ null
notify BIT 1 null
project_list_id INT 10 √ null
projectlist_custom.id FK_96rjsluq2dm8bjiy9awnlnt5c N
request_args TEXT 65535 √ null
request_date DATETIME 23 null
run_parameters TEXT 65535 √ null
start_date DATETIME 23 √ null
status INT 10 null
title VARCHAR 128 null
total_rows INT 10 √ null
user_id INT 10 null
sys_users.user_id FK_1mqriro6em5okync3a0uivo90 R
total_elapsed_wait INT 10 √ null
sql_query TEXT 65535 √ null
draft_list_id INT 10 √ null
projectlist_custom.id FX_projectlist_export_projectlist R
type VARCHAR 40 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_1mqriro6em5okync3a0uivo90 Performance Asc user_id
FK_96rjsluq2dm8bjiy9awnlnt5c Performance Asc project_list_id
FX_projectlist_export_projectlist_idx Performance Asc draft_list_id
IX_Projectlist_export_status Performance Asc/Asc status + id
IX_projectlistExport_status_type Performance Asc/Asc status + type

Relationships

Close relationships within degrees of separation