Changeset 38451 for gs3-installations


Ignore:
Timestamp:
2023-11-30T00:13:38+13:00 (6 months ago)
Author:
davidb
Message:

Additional info worked out about Tbl_*.xm tables

File:
1 edited

Legend:

Unmodified
Added
Removed

  • gs3-installations/computing50/trunk/sites/computing50/ConnectProxyExpress.deprecated/README.txt

    r38174 r38451  
    11
    2 
    3 
    4 FROM Tbl_Per_Events -> Its ID becomes a match in Tbl_Per_Events under the field Person[col 2]
     2Tbl_Per_Events -> Its ID becomes a match in Tbl_Per_Events under the field Person[col 2]
    53  e.g. Found [ID=119] with 2nd entry in record <4> == Tbl_People[ID] ALBERT, Sam back in in Tbl_People
    64    [Type+of+Event] -> <25> = Attestation in Tbl_Event
    … …  
    2018 
    2119
    22   MajorEventsID is a <string>, with spaces [e.g., "Maori at Lemnos Island  - Sarpi Camp."]
    23 
     20  (in ACCESSDB) MajorEventsID is a <string>, with spaces [e.g., "Maori at Lemnos Island  - Sarpi Camp."] -- Timeline related?
     21  Actually an int in Tbl_Pictures, For example:
     22    Battle of Messines -- <c>65</c> L139296 in Tbl_Pictures
     23   
    2424  Per_EventsID is an <int> that maps back to Tbl_People ID
    2525 
    … …  
    3131 
    3232
     33Tbl_Per_Events
     34  -- EventID (int)
     35  -- Person (int, ID of the person in Tbl_People)
     36  -- Type_of_Event (int, ID in Tbl_EventTypes)
     37  -- then: EventDate, Description
     38  For example:
     39    <r>
     40      <c>109</c>
     41      <c>1</c>   Tbl_People[ID=1]     => Surname: ALLISON
     42      <c>25</c>  Tbl_EventType[ID=25] => EventType: Attestation
     43      <c />
     44      <c />
     45    </r>
     46
     47
     48
    3349Tbl_EventType
    3450  -- shows up as the Administration Menu in AccessDB
    3551  -- List of icons to show, e.g. Poppy, Wounded, Diary/Letters, Theatres of War
    3652  -- ~ 50% link to icons, others have the Icon field blank (e.g. Attestation)
    37  
     53
     54  <!-- EventTypeid, Order, EventType, Description, Icon --> 
     55  For example:
     56    <r>
     57      <c>1</c>
     58      <c>1</c>
     59      <c>Birth</c>
     60      <c />
     61      <c>C:\Table\Projects\SaluteWairoa\Attachments\Pictures\Icons\Birth.jpg</c>
     62    </r>
     63
     64
    3865Tbl_CoolStuff == Conceptual match with GS Collections
    3966  -- Defines what the collections are, has ID, uses 'Order' to list them
Note: See TracChangeset for help on using the changeset viewer.