FortWiki Database Project - Data Definition: Difference between revisions

Revision as of 10:47, 25 February 2015

This page is under construction

Data Elements
Name	Format	Definition	Table	Field	Type	Length
Sequence	nnnnnnn	Acquisition Number	ft	sequence	Numeric	7 Char
Country	nnn	Country Abbreviation	ft	country	Alpha	3 Char
State	aa	State Abbreviation	ft	state	Alpha	2 Char
County	nnnn	County Code	ft	county	Numeric	4 Char
Name	aaaaa...	Fort Name	ft	name	Alpha	~255
See	nnnnnnn	Primary Fort Acquisition Number	ft	see	Numeric	7 Char

@@ Line 14: / Line 14: @@
 ! Length
 |-
-| Country || aaa || Country Abbreviation || ft || country || Alpha || 3 Char
+| Sequence || nnnnnnn || Acquisition Number || ft || sequence || Numeric || 7 Char
+|-
+| Country || nnn || Country Abbreviation || ft || country || Alpha || 3 Char
 |-
 | State || aa || State Abbreviation || ft || state || Alpha || 2 Char
 |-
 | County || nnnn || County Code || ft || county || Numeric || 4 Char
-|-
-| Sequence || nnnnnnn || Acquisition Number || ft || sequence || Numeric || 7 Char
 |-
 | Name || aaaaa... || Fort Name || ft || name || Alpha || ~255
 |-
-| See || aaaaa... || Primary Fort Acquisition Number || ft || see || Numeric || 7 Char
+| See || nnnnnnn || Primary Fort Acquisition Number || ft || see || Numeric || 7 Char
 |}