View table: Plan_Index

Jump to navigation Jump to search

Table structure:

  1. RecordID - Text
  2. Line - Page
  3. Mileage - String
  4. Metrage - String
  5. Station - Page
  6. StructureID - String
  7. Category - String
  8. Drawing_Titkle - String
  9. Date - String
  10. Key_Words - List of Text, delimiter: ,
  11. Microfiche - Boolean (allowed values: no · yes)
  12. Archived - List of String, delimiter: ,
  13. Hyperlink - Wikitext string
  14. Scan_Quality - Integer (allowed values: 1 · 2 · 3 · 4 · 5)
  15. CCE_No - String
  16. Sheet_No - Integer
  17. District - String (allowed values: Auckland · Hamilton · Wanganui · Wellington · Westport · Greymouth · Christchurch · Dunedin · Invercargill)
  18. DE_Number - String
  19. RE_Number - String
  20. PWD_Numbers - List of String, delimiter: ,

This table has 5 rows altogether.

Recreate data.

Page RecordID Line Mileage Metrage Station StructureID Category Drawing Titkle Date Key Words Microfiche Archived Hyperlink Scan Quality CCE No Sheet No District DE Number RE Number PWD Numbers
Abbotsford Yard 1900 (edit) 7000001 Abbotsford c1900 1 9595 10 Dunedin
Bluff Yard 1875 (edit) 7000002 Bluff 1875 2 4044 Invercargill
Bluff Yard 1882 (edit) 7000003 Bluff 1882 2 2718 Invercargill
Bluff Yard 1898 (edit) 7000004 Bluff 8-April-1898 2 3004 Invercargill
Bluff Yard 1901 (edit) 7000005 Bluff 15-April-1901 2 10283 Invercargill