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