Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| train_id | INT | 10 | √ | null |
|
|
primary key |
||||
| name | VARCHAR | 80 | null |
|
|
name of the train |
|||||
| description | VARCHAR | 255 | √ | NULL |
|
|
description of the train |
||||
| default_processing_id | INT | 10 | √ | NULL |
|
|
default processing, link to preservation_processings.processing_id |
||||
| not_for_loan | VARCHAR | 80 | '0' |
|
|
NOT_LOAN authorised value to apply toitem added to this train |
|||||
| created_on | TIMESTAMP | 19 | current_timestamp() |
|
|
creation date |
|||||
| closed_on | DATETIME | 19 | √ | NULL |
|
|
closing date |
||||
| sent_on | DATETIME | 19 | √ | NULL |
|
|
sending date |
||||
| received_on | DATETIME | 19 | √ | NULL |
|
|
receiving date |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | train_id |
| preservation_trains_ibfk_1 | Performance | Asc | default_processing_id |
Relationships
Close relationships within degrees of separation
