conf_collection_ia


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
doc_unit.collection_ia fk_doc_unit_coll_ia R
lot_lot.collection_ia fk_lot_coll_ia R
proj_project.collection_ia fk_proj_coll_ia R
name VARCHAR 191 null
conf_ia VARCHAR 191 null
conf_internet_archive.identifier fk_conf_collection_ia R
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
fk_conf_collection_ia Performance Asc conf_ia
name Must be unique Asc name

Relationships

Close relationships within degrees of separation