source: gs3-installations/computing50/trunk/sites/computing50/ConnectProxyExpress.deprecated/README.txt@ 38451

Tbl_Per_Events -> Its ID becomes a match in Tbl_Per_Events under the field Person[col 2]
  e.g. Found [ID=119] with 2nd entry in record <4> == Tbl_People[ID] ALBERT, Sam back in in Tbl_People
    [Type+of+Event] -> <25> = Attestation in Tbl_Event

    To work out the photo that goes with this ...

      Take the Tbl_Per_Events <ID> (e.g 119) and find this in Tbl_Pictures under Per_EventsID[col 6]
      => Gives us everything we need to display image (show description??)      
  
  Then finds another 2nd entry in record <4> = ALBERT, Sam back in Tbl_People
    [Type+of+Event] -> <10> = Medals in Tbl_Event
    

Tbl_Pictures
  ID: is not sequential, jumps up
  ... actually found lower ID nums later on (e.g. ID 1, Salut Wairo Team photo + text used in Credits)
  

  (in ACCESSDB) MajorEventsID is a <string>, with spaces [e.g., "Maori at Lemnos Island  - Sarpi Camp."] -- Timeline related?
  Actually an int in Tbl_Pictures, For example:
    Battle of Messines -- <c>65</c> L139296 in Tbl_Pictures
    
  Per_EventsID is an <int> that maps back to Tbl_People ID
  
  LocationID is a <string>!

  CoolStuff -- which (collection, in DL parlance) it is in
  
  Stream -- marks it out for swirling down the centre
  

Tbl_Per_Events
  -- EventID (int)
  -- Person (int, ID of the person in Tbl_People)
  -- Type_of_Event (int, ID in Tbl_EventTypes)
  -- then: EventDate, Description
  For example:
    <r>
      <c>109</c>
      <c>1</c>   Tbl_People[ID=1]     => Surname: ALLISON
      <c>25</c>  Tbl_EventType[ID=25] => EventType: Attestation
      <c />
      <c />
    </r>



Tbl_EventType
  -- shows up as the Administration Menu in AccessDB
  -- List of icons to show, e.g. Poppy, Wounded, Diary/Letters, Theatres of War
  -- ~ 50% link to icons, others have the Icon field blank (e.g. Attestation)

  <!-- EventTypeid, Order, EventType, Description, Icon -->  
  For example:
    <r>
      <c>1</c>
      <c>1</c>
      <c>Birth</c>
      <c />
      <c>C:\Table\Projects\SaluteWairoa\Attachments\Pictures\Icons\Birth.jpg</c>
    </r>


Tbl_CoolStuff == Conceptual match with GS Collections
  -- Defines what the collections are, has ID, uses 'Order' to list them
  -- Specifies a <string> for 'Title' [col=2] which Tbl_Pictures then matches to


Tbl_Timeline
  -- Specifies the containers that are available as timelines (e.g. for Wairoa WW1, Main-Timeline and Maori-Timeline)
  -- Use Tbl_MajorEvents to get elments and text to place on the TimeLine
  -- (Presumably???) Use Tbl_Pictures to find photos that intersect Tbl_Timeline Container + Tbl_MajorEvents


Tbl_Maps

   ... to investiage ... likely used Location X,Y to put poppies on map
   
   
Tbl_Acknowledgements
  -- Drives the 4 Labels and Thumbnails that appear under "Credits"
     : SPONSORS, Salute Wairoa Team, Biography, Acknowledgements
     
  Tbl_Sponsors
    -- does the content of this turn up in Interface?
    -- Maybe used to hand-craft the image that is shown, Tbl_Pictures, ID=3793

  Team -- Hardired to show Tbl_Pictures ID=1
  Biography -- Hardwired to show Tbl_Pictures ID=3794 ????
  Acknoweldgements -- Hardwired to ID=3796
  



Request/?query=SELECT+ID,FirstName,MiddleName,LastName,DOB,DOD,MainPicture,Summary,Type,Feature,ServiceNo+FROM+Tbl_People+WHERE+(Display+=+true)
Request/?query=SELECT+EventTypeid,Order,EventType,Description,Icon+FROM+Tbl_EventType
Request/?query=SELECT+Eventid,Person,[Type+of+Event],EventDate,Description+FROM+Tbl_Per_Events

Request/?query=SELECT+ID,Pictures,Title,Description,MajorEventsID,Per_EventsID,LocationID,MapID,[Cool+stuff],Stream,Audio,LocationY,LocationX,Achnolodgements,Order+FROM+Tbl_Pictures

Request/?query=SELECT+ID,Video,Title,Description,Order,Pictures+FROM+Tbl_Videos
Request/?query=SELECT+ID,Title,Description,Icon,Dynamic+FROM+Tbl_Timeline
Request/?query=SELECT+ID,Event,Description,EventDate,Timeline+FROM+Tbl_MajorEvents
Request/?query=SELECT+ID,Title,Description,Order+FROM+Tbl_CoolStuff
Request/?query=SELECT+Team,Name,Role+FROM+Team
Request/?query=SELECT+ID,Organisation,Contribution,Logo+FROM+Tbl_Sponsors
Request/?query=SELECT+ID,Order,Title,Pictures+FROM+Tbl_Acknowledgements
Request/?query=SELECT+Mapsid,Order,MapName,Description,Picture,Dynamic+FROM+Tbl_Maps