doc_condreport_detail


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
doc_condreport_desc.detail fk_doc_condreport_binding_detail R
type VARCHAR 255 null
lib_writer_name VARCHAR 255 NULL
lib_writer_function VARCHAR 255 NULL
prov_writer_name VARCHAR 255 NULL
prov_writer_function VARCHAR 255 NULL
report_date DATE 10 NULL
nb_view_binding INT 10 NULL
nb_view_body INT 10 NULL
nb_view_additionnal INT 10 NULL
dim1 INT 10 NULL
dim2 INT 10 NULL
dim3 INT 10 NULL
binding_desc TEXT 65535 NULL
body_desc TEXT 65535 NULL
additionnal_desc TEXT 65535 NULL
report VARCHAR 191 null
doc_condreport.identifier fk_doc_condreport_detail_report R
version BIGINT 19 null
created_by VARCHAR 191 'system'
last_modified_by VARCHAR 191 'system'
created_date TIMESTAMP 19 current_timestamp()
last_modified_date TIMESTAMP 19 current_timestamp()
insurance DOUBLE 22 NULL
position INT 10 0
comment TEXT 65535 NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
idx_doc_condreport_attachment_report Performance Asc report
idx_doc_condreport_detail_report Performance Asc report

Relationships