Appendix E - Database Structure

E.1 - Sites Database Structure

Column	Variable Name	Field Type and Size	Field Type	Editable	Notes
1	ID	INT 6	INTERNAL	NO
2	Site_ID	VARCHAR 10	INTERNAL	NO
3	Site_Name	VARCHAR 200	MANDATORY	YES
4	Key_Words	VARCHAR 200	MANDATORY	YES
5	Site_Location	VARCHAR 200	OPTIONAL	YES
6	Site_Visibility	VARCHAR 200	OPTIONAL	YES
7	Street	VARCHAR 100	OPTIONAL	YES
8	Village	VARCHAR 50	OPTIONAL	YES
9	Town	VARCHAR 50	MANDATORY	YES
10	Post_Code	VARCHAR 20	OPTIONAL	YES
11	County	VARCHAR 35	MANDATORY	NO
12	NGR	VARCHAR 500	MANDATORY	YES
13	NGC	VARCHAR 500	INTERNAL	NO
14	Latitude	VARCHAR 500	INTERNAL	NO
15	Longitude	VARCHAR 500	INTERNAL	NO
16	featuretype	VARCHAR 20	DEFAULT - Point, OPTIONS - Line and Area	YES
17	Admin_Area	VARCHAR 50	OPTIONAL	YES
18	Parish	VARCHAR 50	OPTIONAL	YES
19	Pre74_County	VARCHAR 50	OPTIONAL	YES
20	era_list	VARCHAR 250	OPTIONAL	YES
21	Site_Status	VARCHAR 50	OPTIONAL	YES
22	Site_Condition	VARCHAR 100	OPTIONAL	YES
23	NMR	VARCHAR 250	OPTIONAL	YES
24	EHBID	VARCHAR 250	OPTIONAL	YES
25	Earliest_Date	VARCHAR 20	OPTIONAL	YES
26	Latest_Date	VARCHAR 20	OPTIONAL	YES
27	Site_Description	TEXT	OPTIONAL	YES
28	Site_History	TEXT	OPTIONAL	YES
29	Site_References	TEXT	OPTIONAL	YES
30	Site_Comments	TEXT	OPTIONAL	YES	Attend Text only
31	Site_Comments_Status	VARCHAR 15	OPTIONAL	YES
32	Site_Comments_Rev_By	VARCHAR 30	OPTIONAL	YES
33	Site_Comments_Rev_Date	VARCHAR 30	OPTIONAL	YES
34	Visit_By	VARCHAR 30	OPTIONAL	YES
35	Visit_Date	VARCHAR 30	OPTIONAL	YES
36	Entry_By	VARCHAR 30	INTERNAL	YES	Linked to login details
37	Entry_Date	VARCHAR 30	INTERNAL	YES	Linked to login date
38	Msociety	VARCHAR 100	INTERNAL	YES	Linked to login details
39	Reviewed_By	VARCHAR 30	MANDATORY ON REVIEW	NO	Linked to Reviewers Login details
40	Reviewed_Date	VARCHAR 30	MANDATORY ON REVIEW	NO	Linked to Date of Review
41	Linked_Sites	VARCHAR 250	OPTIONAL	YES
42	Recvis	VARCHAR 20	DEFAULT - Public Options - Deleted, Private	YES
43	Record_Status	VARCHAR 15	DEFAULT - Incomplete OPTIONS - Complete, Reviewed, Queried	YES
44	Site_Type	VARCHAR 30	Currently Not Used	NO
45	Site_ID_Was	VARCHAR 10	Currently Not Used	NO
46	TS_Created		INTERNAL	NO
47	TS_Updated		INTERNAL	NO

Help Index

E.2 - Media Database Structure

Column	Variable Name	Field Type and Size	Field Type	Editable	Notes
1	ID	INT 6	NO
2	Site_ID	VARCHAR 10	INTERNAL	NO	Linked to Site Record
3	Site_Name	VARCHAR 200	INTERNAL	NO	Linked to Site Record
4	Key_Words	VARCHAR 200	MANDATORY	YES
5	Upload_File	VARCHAR 100	MANDATORY	NO
6	Caption	TEXT	MANDATORY	YES	Append Only
7	Additional_Info	TEXT	OPTIONAL	YES	Append Only
8	Media_By	VARCHAR 50	MANDATORY	NO
9	Media_Date	VARCHAR 20	MANDATORY	NO
10	Digital_Media_By	VARCHAR 30	MANDATORY	NO
11	Digital_Media_Date	VARCHAR 50	MANDATORY	NO
12	Copyright	VARCHAR 20	MANDATORY	NO
13	Imagevis	VARCHAR 20	DEFAULT - Public Option - Deleted, Private	YES
14	Image_Status	VARCHAR 20	DEFAULT - Incomplete, OPTIONS Complete, Reviewed, Queried	YES
15	Entry_By	VARCHAR 20	INTERNAL	NO	Linked to Login Details
16	Entry_Date	VARCHAR 20	INTERNAL	NO	Linked to Login Date
17	Society	VARCHAR 100	INTERNAL	NO	Linked to Login Details
18	Reviewed_By	VARCHAR 30	MANDATORY ON REVIEW	NO	Linked to Reviewers log in details
19	Reviewed_Date	VARCHAR 30	MANDATORY ON REVIEW	NO	Linked to date of review
20	Media_Comments	TEXT	OPTIONAL	NO	Append Text Only
21	Media_Comments_Status	VARCHAR 30	OPTIONAL	YES
22	Media_Comments_Rev_By	VARCHAR 30	MANDATORY ON REVIEW	YES	Linked to Reviewers log in details
23	Media_Comments_Rev_Date	VARCHAR 100	MANDATORY ON REVIEW	YES	Linked to date of Review
24	Media_URL	VARCHAR 100	MANDATORY	NO
25	TPUpload_File	VARCHAR 100	MANDATORY	NO
26	TS_Created		INTERNAL	NO
27	TS_Updated		INTERNAL	NO

Rules for displaying images on Public and Members Searches

Database Term Copyright Category Copyright Text Public

Copyright 1 Individual Contributors copyright cc-by-nc-sa/4.0 - © . $mediaby . - IHO Yes

Copyright 2 YAHS copyright cc-by-nc-sa/4.0 - © YAHS Archive - www.yahs.org.uk Yes

Copyright 3 was Third Party 1 Copyright Holder Known cc-by-nc-sa/4.0 - © . $mediaby . - IHO Yes

Out of Copyright was Third Party 2 Out of copyright Out of Copyright Yes

Web / Downloaded Images

1. Geograph Geograph cc by-sa/2.0 - © . $mediaby . - www.geograph.org.uk Yes
2. NLS National Libraries of Scotland cc by-nc-sa/4.0 - National Libraries of Scotland Yes
3. Graces Guide Grace's Guide to British Industrial History Grace's Guide to British Industrial History Yes
4. Google Earth was Third Party 4a Source - Google Earth Yes
5. Wikipedia was Third Party 4c Source - Wikipedia Yes
6. Wikimedia was Third Party 4c Source - Wikimedia Yes
7. Web Other was Third Party 4d Source - Web Image Yes
Excluded Images
8. Third Party 3 Other Third Party or Unknown copyright Third Party copyright No
9. Third Party 4b Historic England/Aerofilms/Britian from Above Source - Historic England/Aerofilms No

Help Index

E.3- Copyright Database Structure

Column	Variable Name	Field Type and Size	Field Type	Editable	Notes
1	ID	INT 6	INTERNAL	NO
2	Media_ID	VARCHAR 20	INTERNAL	NO
3	Entry_By	VARCHAR 30	INTERNAL	NO
4	Entry_Date	VARCHAR 20	INTERNAL	NO
5	Media_By	VARCHAR 30	INTERNAL	NO
6	Digitial_Media_By	VARCHAR 30	INTERNAL	NO
7	Copyright	VARCHAR 20	INTERNAL	NO
8	Upload_File	VARCHAR 100	INTERNAL	NO
9	Media_URL	VARCHAR 100	INTERNAL	NO
10	TPUplaod_File	VARCHAR 100	INTERNAL	NO
11	Add_Info	VARCHAR 500	INTERNAL	NO