doc_bibliographic_record


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
doc_property.record fk_doc_property_record R
sigb VARCHAR 255 NULL
sudoc VARCHAR 255 NULL
calames VARCHAR 255 NULL
doc_unit VARCHAR 191 NULL
doc_unit.identifier fk_doc_bibliographic_record_doc_unit 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()
title TEXT 65535 NULL
doc_electronique VARCHAR 255 NULL
library VARCHAR 191 NULL
lib_library.identifier fk_doc_bibliographic_record_lib_library R
property_order VARCHAR 255 'BY_PROPERTY_TYPE'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
fk_doc_bibliographic_record_doc_unit Performance Asc doc_unit
fk_doc_bibliographic_record_lib_library Performance Asc library

Relationships