preservation_processing_attributes

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
processing_attribute_id INT 10 √ null
preservation_processing_attributes_items.processing_attribute_id preservation_processing_attributes_items_ibfk_1 C

primary key
processing_id INT 10 null
preservation_processings.processing_id preservation_processing_attributes_ibfk_1 C

link to the processing
name VARCHAR 80 null

name of the processing attribute
type enum('authorised_value', 'free_text', 'db_column') 17 null

Type of the processing attribute
option_source VARCHAR 80 √ null

source of the possible options for this attribute

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc processing_attribute_id
preservation_processing_attributes_ibfk_1 Performance Asc processing_id

Relationships

Close relationships within degrees of separation