exc_template


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
name VARCHAR 191 null
library VARCHAR 191 null
lib_library.identifier fk_exc_template_library R
original_filename VARCHAR 1024 NULL
file_size BIGINT 19 NULL
version BIGINT 19 null
created_by VARCHAR 255 'system'
last_modified_by VARCHAR 255 'system'
created_date TIMESTAMP 19 current_timestamp()
last_modified_date TIMESTAMP 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
idx_exc_template_library Performance Asc library
idx_exc_template_name_library Performance Asc/Asc name + library

Relationships