FortWiki Database Project - Data Definition

From FortWiki
Jump to: navigation, search

Database Project Home

Data Elements (edit list)
Name Table Format Definition Type Length Notes
Sequence Fortification nnnnnnn Acquisition Number Numeric 7 Char
Country Fortification nnn Present Day Country Abbreviation Alpha 3 Char From List
State Fortification aa Present Day State Abbreviation Alpha 2 Char
County Fortification nnn Present Day County Code Numeric 4 Char
Name Fortification aaaaa... Fortification Name Alpha ~255 Char
See Fortification nnnnnnn Primary Fort Acquisition Number Numeric 7 Char
Type Fortification aaaaa... Type of Fortification Alpha ~255 Char From List
GNISID Fortification nnnnnnn GNIS ID Number Alpha 7 Char


Sequence GPS nnnnnnn Acquisition Number Numeric 7 Char
Lat GPS aaaaaaaaaaaa Latitude Alpha 12 Char
Lon GPS aaaaaaaaaaaa Longitude Alpha 12 Char
Type GPS aaaaa... Description Alpha ~255 Char
Key Type nnnnn Type Table Key Int Int
Name Type aaaaa... Type Table Name Alpha ~255 Char
Key Country nnnnn Country Table Key Int Int
Name Country aaaaa... Country Table Name Alpha ~255 Char
Abbr Country aaa Country Table Name Alpha 3 Char
Sequence Timeline nnnnnnn Acquisition Number Numeric 7 Char
Year Timeline aaaa Year Alpha 4 Char
Month Timeline aaa Month Alpha 3 Char
Day Timeline aa Day Alpha 2 Char
DateType Timeline aaaaa... Date Type Alpha ~255 From List
Personal tools
Namespaces

Variants
Actions
content
Share
Google AdSense
Toolbox