S previous service table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m m |
Ttenbergen (talk | contribs) m m |
||
| Line 17: | Line 17: | ||
|| '''notes''' || text || notes about entry | || '''notes''' || text || notes about entry | ||
|- | |- | ||
|| '''sort_order''' || integer || sort order index for showing in drop-downs (e.g. to be able to sort "not applicable" to bottom | || '''sort_order''' || integer || sort order index for showing in drop-downs (e.g. to be able to sort "not applicable" to bottom) | ||
|} | |} | ||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: 2016 Time and Place changes]] | [[Category: 2016 Time and Place changes]] | ||
Revision as of 12:16, 21 March 2016
The S_previous_service table contains options to populate the previous service field.
This field is part of the 2016 Time and Place changes.
| field | type | description |
|---|---|---|
| previous_service_ID | long integer | unique ID |
| previous_service | text | actual name |
| active | true/false | available for collection |
| notes | text | notes about entry |
| sort_order | integer | sort order index for showing in drop-downs (e.g. to be able to sort "not applicable" to bottom) |