FortWiki Database Project - Data Definition: Difference between revisions

Latest revision as of 13:39, 15 August 2015

**Data Elements** (edit list)
Name	Table	Format	Definition	Type	Length	Notes
Acquisition No	Fortification	nnnnnn	Acquisition Number	Numeric	6 Char
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
PLat	GPS	aaaaaaaaaaaa	Latitude	Alpha	12 Char
PLon	GPS	aaaaaaaaaaaa	Longitude	Alpha	12 Char
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

@@ Line 1: / Line 1: @@
 {{SocialNetworks}}
 {{PageHeader}}
-This page is under construction
+{{DatabaseHome}}
+{{FWDD-List}}
-{| class="wikitable sortable" width="800px"
-|+ 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
-|}
-{{FWHeader|Title=Data Elements|EditPage=FWDD-List}}
-{{FWDBList|Element=|Table=|Format=|Definition=|Type=|Length=|Notes}}
-{{CommomFooter}}
-<!--
-{| class="wikitable sortable" style="margin: 1em auto 1em auto" width="800px"
-|+'''{{{Title}}}''' [{{SERVER}}/index.php?title=Template:{{{EditPage}}}&action=edit (edit list)]
-|-
-! Name
-| Table
-! Format
-! Definition
-! Type
-! Length
-! Notes
-----
-|-
-| {{Name}}} | {{{Table}}} || {{{Format}}} || {{{Definition}}} || {{{Type}}} || {{{Length}} || {{{Notes}}}
--->
 {{PageFooter}}
-{{DEFAULTSORT:Data Definition}}
+{{DEFAULTSORT:FortWiki Database Project}}
 [[Category:FortWiki Database Project]]
 [[Category:Lists]]