| 1 |
|
|---|
| 2 |
|
|---|
| 3 |
|
|---|
| 4 | FROM Tbl_Per_Events -> Its ID becomes a match in Tbl_Per_Events under the field Person[col 2]
|
|---|
| 5 | e.g. Found [ID=119] with 2nd entry in record <4> == Tbl_People[ID] ALBERT, Sam back in in Tbl_People
|
|---|
| 6 | [Type+of+Event] -> <25> = Attestation in Tbl_Event
|
|---|
| 7 |
|
|---|
| 8 | To work out the photo that goes with this ...
|
|---|
| 9 |
|
|---|
| 10 | Take the Tbl_Per_Events <ID> (e.g 119) and find this in Tbl_Pictures under Per_EventsID[col 6]
|
|---|
| 11 | => Gives us everything we need to display image (show description??)
|
|---|
| 12 |
|
|---|
| 13 | Then finds another 2nd entry in record <4> = ALBERT, Sam back in Tbl_People
|
|---|
| 14 | [Type+of+Event] -> <10> = Medals in Tbl_Event
|
|---|
| 15 |
|
|---|
| 16 |
|
|---|
| 17 | Tbl_Pictures
|
|---|
| 18 | ID: is not sequential, jumps up
|
|---|
| 19 | ... actually found lower ID nums later on (e.g. ID 1, Salut Wairo Team photo + text used in Credits)
|
|---|
| 20 |
|
|---|
| 21 |
|
|---|
| 22 | MajorEventsID is a <string>, with spaces [e.g., "Maori at Lemnos Island - Sarpi Camp."]
|
|---|
| 23 |
|
|---|
| 24 | Per_EventsID is an <int> that maps back to Tbl_People ID
|
|---|
| 25 |
|
|---|
| 26 | LocationID is a <string>!
|
|---|
| 27 |
|
|---|
| 28 | CoolStuff -- which (collection, in DL parlance) it is in
|
|---|
| 29 |
|
|---|
| 30 | Stream -- marks it out for swirling down the centre
|
|---|
| 31 |
|
|---|
| 32 |
|
|---|
| 33 | Tbl_EventType
|
|---|
| 34 | -- shows up as the Administration Menu in AccessDB
|
|---|
| 35 | -- List of icons to show, e.g. Poppy, Wounded, Diary/Letters, Theatres of War
|
|---|
| 36 | -- ~ 50% link to icons, others have the Icon field blank (e.g. Attestation)
|
|---|
| 37 |
|
|---|
| 38 | Tbl_CoolStuff == Conceptual match with GS Collections
|
|---|
| 39 | -- Defines what the collections are, has ID, uses 'Order' to list them
|
|---|
| 40 | -- Specifies a <string> for 'Title' [col=2] which Tbl_Pictures then matches to
|
|---|
| 41 |
|
|---|
| 42 |
|
|---|
| 43 | Tbl_Timeline
|
|---|
| 44 | -- Specifies the containers that are available as timelines (e.g. for Wairoa WW1, Main-Timeline and Maori-Timeline)
|
|---|
| 45 | -- Use Tbl_MajorEvents to get elments and text to place on the TimeLine
|
|---|
| 46 | -- (Presumably???) Use Tbl_Pictures to find photos that intersect Tbl_Timeline Container + Tbl_MajorEvents
|
|---|
| 47 |
|
|---|
| 48 |
|
|---|
| 49 | Tbl_Maps
|
|---|
| 50 |
|
|---|
| 51 | ... to investiage ... likely used Location X,Y to put poppies on map
|
|---|
| 52 |
|
|---|
| 53 |
|
|---|
| 54 | Tbl_Acknowledgements
|
|---|
| 55 | -- Drives the 4 Labels and Thumbnails that appear under "Credits"
|
|---|
| 56 | : SPONSORS, Salute Wairoa Team, Biography, Acknowledgements
|
|---|
| 57 |
|
|---|
| 58 | Tbl_Sponsors
|
|---|
| 59 | -- does the content of this turn up in Interface?
|
|---|
| 60 | -- Maybe used to hand-craft the image that is shown, Tbl_Pictures, ID=3793
|
|---|
| 61 |
|
|---|
| 62 | Team -- Hardired to show Tbl_Pictures ID=1
|
|---|
| 63 | Biography -- Hardwired to show Tbl_Pictures ID=3794 ????
|
|---|
| 64 | Acknoweldgements -- Hardwired to ID=3796
|
|---|
| 65 |
|
|---|
| 66 |
|
|---|
| 67 |
|
|---|
| 68 |
|
|---|
| 69 | Request/?query=SELECT+ID,FirstName,MiddleName,LastName,DOB,DOD,MainPicture,Summary,Type,Feature,ServiceNo+FROM+Tbl_People+WHERE+(Display+=+true)
|
|---|
| 70 | Request/?query=SELECT+EventTypeid,Order,EventType,Description,Icon+FROM+Tbl_EventType
|
|---|
| 71 | Request/?query=SELECT+Eventid,Person,[Type+of+Event],EventDate,Description+FROM+Tbl_Per_Events
|
|---|
| 72 |
|
|---|
| 73 | Request/?query=SELECT+ID,Pictures,Title,Description,MajorEventsID,Per_EventsID,LocationID,MapID,[Cool+stuff],Stream,Audio,LocationY,LocationX,Achnolodgements,Order+FROM+Tbl_Pictures
|
|---|
| 74 |
|
|---|
| 75 | Request/?query=SELECT+ID,Video,Title,Description,Order,Pictures+FROM+Tbl_Videos
|
|---|
| 76 | Request/?query=SELECT+ID,Title,Description,Icon,Dynamic+FROM+Tbl_Timeline
|
|---|
| 77 | Request/?query=SELECT+ID,Event,Description,EventDate,Timeline+FROM+Tbl_MajorEvents
|
|---|
| 78 | Request/?query=SELECT+ID,Title,Description,Order+FROM+Tbl_CoolStuff
|
|---|
| 79 | Request/?query=SELECT+Team,Name,Role+FROM+Team
|
|---|
| 80 | Request/?query=SELECT+ID,Organisation,Contribution,Logo+FROM+Tbl_Sponsors
|
|---|
| 81 | Request/?query=SELECT+ID,Order,Title,Pictures+FROM+Tbl_Acknowledgements
|
|---|
| 82 | Request/?query=SELECT+Mapsid,Order,MapName,Description,Picture,Dynamic+FROM+Tbl_Maps
|
|---|
