preservation_trains_items

0 rows


Columns

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

primary key
train_id INT 10 null
preservation_trains.train_id preservation_item_ibfk_1 C

link with preservation_train
item_id INT 10 null
items.itemnumber preservation_item_ibfk_2 C

link with items
processing_id INT 10 √ NULL
preservation_processings.processing_id preservation_item_ibfk_3 N

specific processing for this item
user_train_item_id INT 10 null

train item id for this train, starts from 1
added_on DATETIME 19 √ NULL

added date

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc train_item_id
preservation_item_ibfk_2 Performance Asc item_id
preservation_item_ibfk_3 Performance Asc processing_id
train_id Must be unique Asc/Asc train_id + item_id

Relationships

Close relationships within degrees of separation