Ariadne index page

The Ariadne Data Model

 

  
Contents
1. Introduction
2. Object definition model
3. Conceptual data model
4. Table model
5. Database model
6. Database table descriptions		 author: Gerrit van Dalfsen

6. Database table descriptions

Change history

Date Version Change
Jan2016 5.3 Reviewed and updated
20Jun2010 4.8.5 Tables T026 added.
21Jun2009 4.7.2 Tables T021, T022 added
27Nov2008 4.7.0 Updated
05Aug2006 4.4.0 Time offset added in T100, T420 and T510
13Jun2006 4.4.0 Tables Ariadne Time added
04 Apr 2005 4.3.0 Table T730-Menu removed & related changes , Table T702 added
24 Aug 2004 1.16 Table T480-Swap-log added (to log finish times swaps)
16 Apr 2004 1.15 Table T410-Series changed into T112-Program-block-item
04 Apr 2004 1.14 Attributes of T870-Ranking-scale moved to T800-Archived-competition
11 Dec 2003 1.13 Tables T065-Language and T243-Document-template added
20 Nov 2003 1.12 Archive tables renamed to the T800 tables series
10 May 2003 1.11 Table T420-Start added (for Ariadne Marathon)
17 Apr 2003 1.10 Table T720-Operation-type renamed to T720-Function, Tables T740-Control and T705-Message added
06 Mar 2003 1.9 Tables T820-Archived-person and T830-Archived-kayak-club added
09 feb 2003 1.8 Table T570-Saved-event-results added
27 jan 2003 1.7 Table T310-category-kayak-club deleted
09 Jan 2003 1.6 Table T240, T242, T244, T246 added for the mailing profile
20-Oct-2002 1.5 'Race' changed in 'Event, relation table T230-Participant added

Table: T010-Remark

  Attribute Type Length Remark, example
  remark-id counter   Primary key
  remark memo    

Remarks has relations to Races, Categories, Person and Competition. Remarks are linked to these tables, with a remark-id, which is derived from the primary key of the related table, prefixed with a letter. (E for Race, C for Category, P for person, S for Competition).

Table: T019-Runtype

  Attribute Type Length Remark, example
  runtype-id counter   Primary key
  runtype-abbrev text 4  
  runtype-name text 15  

Run type: Table of values

runtype-id runtype-abbrev runtype-name
1 R1 Run 1
2 R2 Run 2
3 EF 1/8 Finals
4 QF 1/4 Finals
5 SF 1/2 Finals
6 FI Finals

Table: T020-Run-statustype

  Attribute Type Length Remark, example
  status-id counter   Primary key
  status-description text 16  
  status-abbrev text 11  
  status-sort-display number   sorting order for presenting status in selectbox
  status-sort-results number   sorting order of run in the race results
  status-set-select yes/no   yes = select for status set select box
  status-show-runtime yes/no   yes = show run time
  status-show-penalties yes/no   yes = show penalty points
  status-show-runstatus yes/no   yes = show run status
         

Status type: Table of values

status-id status-description status-abbrev    
-2 Not valid nv    
-1 Restart restart    
0 Not started dns    
1 Prepstart sprep    
2 Started started    
3 Split1 split1    
4 Split2 split2    
5 Finished finished    
6 Complete complete    
7 Did not finish DNF    
8 Disqualified DSQ    
9 HorsConcours HC    
10 Park park    
12 No time NT    
20 DNS DNS    

Table: T022-Results-statustype

Picklist for selectbox to select status for a race result

  Attribute Type Length Remark, example
  results-status-id number long Primary key
  results-status-abbrev text 15  
  results-status-description text 25  
  results-status-sort number integer  

Results Statustype: Table of values

results-status-id results-status-abbrev results-status-description
0 niet gestart not started
1 in uitvoering in progresss
2 voorlopig unofficial
3 officieel official
4 herzien revised

Table: T023-Series-type

  Attribute Type Length Remark, example
  seriestype-id counter   Primary key
  seriestype-abbrev text 15  
  seriestype-name text 15  
  seriestype-sort number integer  
  runtype-id number long  
  results-type number integer  
  results-name number 15  

Series type: Table of values

seriestype-id seriestype-abbrev seriestype-name seriestype-sort runtype-id results-type results-name
1 slmR1 slm Run 1 20 1 1 Run 1
2 slmR2 slm Run 2 21 2 2 Runs 1+2
3 slmH1 slm Heat 1 22 1 1 Heat 1
4 slmH2 slm Heat 2 23 2 2 Heat 1+2
5 slmSF slm SemiF 24 5 1 Semifinals
6 slmFI slm Final 25 6 1 Finals

Table: T024-Sports-discipline

  Attribute Type Length Remark, example
  sports-discipline-id number long Primary key
  sports-discipline-abbrev text 5  
  sports-discipline-name text 25  
  sports-dicipline--sort number integer  
  number-base-runs number integer nbr T510-Runs to be created when adding CU
  results-calculation number integer 1= single or best of results, 2=som of results
  penalty-processing yes/no   yes=penalties processing
  time-format number integer 1 = seconds, 2 = hhmmss
         

Sports discipline : Table of values

sports-discipline-id sports-discipline-abbrev sports-discipline-name sports-discipline-sort number-base-runs results-calculation penalty-processing time-format
1 mar marathon 10 1 1 no 2
2 slm slalom 1 2 2 yes 1
3 wws white water sprint 21 2 1 no 1
4 wwr white water race 20 1 1 no 2
9 sski surfski 41 1 1 no 2
11 bx boaterX 25 1 1 no 1

Table: T025-Timing-event-status-type

  Attribute Type Length Remark, example
  timingevent-status-id number long Primary key
  timingevent-status-code text 20  
  timingevent--status-description text 25  
  timingevent--status-sort number integer  

Timing-event-status-type: Table of values

timingevent-status-id timingevent-status-code timingevent-status-description  
0 - not processed 1
1 as assigned 2
2 nv not valid 3
3 res restart 4
4 ras re assigned 5
5 park parked 6
6 notag unknown tag 7

Table: T026-Course-type

Picklist for dropbox to select course type for a race

  Attribute Type Length Remark, example
  course-type-id number long Primary key
  course-type-name text 15  

Course-type: Table of values

course-type-id course-type-name  
1 slalom  
2 10km  
3 20km  
4 14km  
5 5km  
6 wwsprint  

Table: T027-Run-eventtype

  Attribute Type Length Remark, example
  run-eventtype-id number long Primary key
  run-eventype-abbrev text 15  

Run-eventtype: Table of values

run-eventtype-id run-eventtype-abbrev  
10 start  
11 split1  
12 split2  
15 lap  
20 finish  

Table: T028-Timing-channel

  Attribute Type Length Remark, example
  timing-channel-id number long Primary key
  timing-channel-name text 15  
  timing-channel-code text 2  
  run-eventtype-id number integer foreing key to T027-Run-eventtype
  active yes/no   yes = used for results
  toid yes/no   yes = time stamp has timed object id

Timing-channel Table of values

timing-channel-id timing-channel-name timing-channel-code run-eventtype-id active toid
10 timy start C0 10 yes no
11 timy split 1 C2 11 yes no
20 timy finish C1 20 yes no
110 cam start A0 10 no yes
120 cam finish A1 20 no yes
310 pc start P0 10 yes no
311 pc split 1 P2 11 yes no
320 pc finish P1 20 yes no

Table: T029-Race-type

  Attribute Type Length Remark, example
  race-type-id number long Primary key
  sports-discpline-id number long foreign key to T024
  stage-id number long 1=heat,3=1/8final,4=1/4final,5=1/2final,6=final
  race-type-name text 16  
  run1 number integer runtype-id run1
  run2 number integer runtype-id run2
  result-type number integer 1=one run result, 2=two run result
  calculation-type number integer 0=run,1=best of two, 2=sum of two
  time-type number integer 1=seconds,2=hhmmss
  rank-run-status number integer runstatus for ranking
  promotable yes/no   yes=promotable
  column1-results-header text 20 text results header column 1
  column2-results-header text 20 text results header column 2

Race type Table of values

race-type-id sports-dicipline-id stage-id race-type-name run1 run2 result-type calculation-type time-type rank-result-status promotable column1-results-header column2-results-header
10 1 1 1 Run 1 0 1 0 2 5 no Run  
20 2 1 1 Run 1 0 1 0 1 6 no Run  
21 2 1 2 Runs 1 2 2 1 1 6 yes Run 1 Run 2
22 2 5 1/2Finals 5 0 1 0 1 6 yes Semi finals  
23 2 6 Finals 6 0 1 0 1 6 no Finals  
40 4 1 1 Run 1 0 1 0 2 5 no Run  
                         
                         

Table: T030-Role-type

  Attribute Type Length Remark, example
  role-type-id text 15 key
  role-type-name text 50 'teamleader', 'judge'
  role-type-sort number integer sort number for presenting role types in desired order

Role types: Table of values

role-id role-name
2 Club contact
3 Entries contact
4 Team leader
5 Gate judge

Table: T031-CU-type

  Attribute Type Length Remark, example
  CU-type-id counter   Primary key
  CU-type-name text 7 name of competing unit type. Example k1; k2; c1;c2;team,
  CU-type-participants number integer number of participants in this CU-type
  CU-penalty-lines number integer number of penalty records per CU

Competing Unit type: Table of values

CU-type-id CU-type-name CU-type-participants CU-penalty-lines
1 solo 1 1
2 duo 2 1
3 team 3 3
4 r4 4 1

Table: T032-Boat-type

  Attribute Type Length Remark, example
  boat type id integer   Primary key
  boat type name text 7 name of boat type e.g. k1; k2; c1;c2; ...
  boat-type-sort number integer  

Boat type: Table of values

boat-type-id boat-type-name
1 K1
2 K2
3 C1
4 C2
6 Polo
7 Sprint
8 Fun
9 3K1
10 3C1
11 3C2
12 Topo2
13 Raft4

Table: T033-Gender

  Attribute Type Length Remark, example
  gender-id counter   Primary key
  gender-abbrev text 1  
  gender-name text 10  

Gender: Table of values

gender-id gender-abbrev gender-name
1 H Heren
2 D Dames
3 X Mix

Table: T040-Category

  Attribute Type Length Remark, example
  category id counter   Primary key
  sports-discipline-id number long foreign key to T024-Sports-discipline
  category-abbrev text 15 Key. example: K-1H PN2
  category-name text 50 Full name. 'K-1 Heren senioren prestatieniveau 2'
  category-sort number integer sorts category in preferred order
  course-type-id number long foreing key to T026-Course-type
  gender-id number long foreing key to T033-Gender
  boat-type-id number long foreing key to T032-Boat type
  age-class-id number long foreing key to T044-Age class
  cu-type-id number long foreing key to T031-CU-type
  nbr-persons number integer number of persons in CU
  nbr-penalty-scores number integer number of penalty scores / lines per CU
  series number integer Number of series for a category
  start-interval number integer default start interval (sec)
  include for judge count yes/no   'y' means that members for this category are counted in order to determine the assignment of gate judge tasks to clubs.
  archive-results yes/no   when Yes, the results for this category are achived in the archiving process
  entry-fee number single entry fee for this category
  entry-fee-late-entry number single  
  time stamp last change date/time    
  archived-category-id number long foreign key to T840-Archived-category

  Table: T044-Age-class

  Attribute Type Length Remark, example
  age-class id counter   Primary key
  age-class-sort integer   sorting order
  age-class-abbreviation text 15 Key. example: SCHa
  age-min integer   (years)
  age-max integer   (years)
  age-class-description text 30  

Age-class: Table of values

age-class-abbrev age-min age-max age-class-description
Ja 17 18 Junioren A
Jb 15 16 Junioren B
SCHa 13 14 Scholieren A
SCHb 11 12 Scholieren B
SCHc 0 10 Scholieren C
V1 32 39 Veteranen 1
V2 40 49 Veteranen 2
V3 50 99 Veteranen 3
~ 0 99 geen klasse
V 32 99 Veteranen
J 15 18 Junioren
S 19 31 Senioren
SCH 0 14 Scholieren

Table: T050-Start-Number

  Attribute Type Length Remark, example
  start number integer 4 range 1 .. 400
  number available yes/no   y/n

Table: T060-Country

  Attribute Type Length Remark, example
  country-id autonumber   Primary key
  country-iso2 text 2 ISO-2 country code
  country-iso3 text 3 ISO-3 country code
  country-ioc text 3 country codes used by IOC. ref: http://en.wikipedia.org/wiki/List_of_IOC_country_codes
  country name text 25  
  default-language-id number long default language. Foreign key to T065-Language

Country: Table of values

country-id country-iso2 country-iso3 country-ioc country-name
1 NL NLD NED Nederland
2 DE DEU GER Germany
3 BE BEL BEL Belgium
4 FR FRA FRA France
5 UK GBR GBR Great Britain
6 CH CHE SUI Zwitserland
7 US USA USA United States

Table: T065-Language

  Attribute Type Length Remark, example
  language-id counter long Primary key
  language-code text 3 Three letter code, eg. Dut, Eng, Ger, Fra
  language-name text 15  

Language: Table of values

language-id language-code language-name
1 Nld Nederlands
2 Ger German
3 Fra French
4 Eng English

Table: T081-SI-temp

Help table to calculate startinterval

  Attribute Type Length Remark, example
  category-id number long Foreing key to T040-Category
  category-abbrev text 15 category abbreviation
  start-interval number integer average start interval (sec)

Table: T100-Current-competition

  Attribute Type Length Remark, example
  current Competition id counter Primary key
  competition-name text 80 'Genneper Molen 2000'
  competition-name-abbrev text 15 'GM2000'
  competition-start-date date/time    
  penalty-pointer number long pointer to the last processed record in T660-Gate-judgementr
  startinterval-init-competition text 15 Competition from which the start interval of the current competition was initialized
  slalom-course-correction-factor number single correction factor in which differences are expressed of the current course, and the course of the competition from which the start interval was initialized.
  default-penalty-entry number integer 1 = entry of total penalty points, 2=entry of penalty points per gate
  refresh-rate-event-monitoring number integer (seconds) (also refresh rate publication screen)
  entry-period-closed boolean   yes = entry period is closed
  entries-closing-date date/time   last date entries can be entered
  person-name-display-order number integer specifies the display order of the persons name: 1=first-name;surname, 2=surname;first-name
  archived-competition-id number long foreign key to T800-Archived-competitions
  menu-name text 30 Menu title, to appear in the menu
  organizing-club-name text 30 Club which organizes the competition
  address text 24 post addres of the club
  postcode text 7 post code of the address
  city text 24 city of the address
  country-code text 2 country code. (iso2). picklist in T060-Country
  contact-person text 50 name of the organizing club contact person
  email-address text 135 email addres of the organizing club
  web-url text 50 url of the website of the organizing club
  bank-account text 60 bank name and account of the organizing club

Table: T110-Program Block

  Attribute Type Length Remark, example
  program-block-id counter   Primary key
  program-block-number number integer sort item
  program-block-name text 40 e.g. 'Avond slalom'
  start-date date/time   Scheduled time to start
  start-time date/time    
  end-time date/time   Scheduled time to end
  virtual-block yes/no   yes=virtual block
  competition-id number long foreign key to T100-Current-competition
  individual-starttime yes/no   yes=indiviual starttime on startlist
  sports-discipline-id number long foreign key to T024-Sports-discpline

Table: T115-Course

  Attribute Type Length Remark, example
  course-id counter   Primary key
  course-name text 25  
  course-description text 50  
  course-length number long  
  course-type-id number long foreign to T026-Course-type
  course-touch-penalty number integer penalty points for touching gate (2 or5 points)

Table: T120-Gate

  Attribute Type Length Remark, example
  gate-id counter   Primary key
  gate-number integer 4 Number of the gate (specifies the negotiation order)
  negotiation-direction text 4 values 'up'; 'down'; 'team'
  gate-section-number number long values 1,2,3,..,9
  course-id number long foreign key to T115-Course

Number of gates vary per slalom competition. Typically a slalom course has 18 - 22 gates.

Table: T200-Person

  Attribute Type Length Remark, example
  person id counter   Primary Key
  surname text 45 persons family name
  initials text 20 person initials
  tussenvoegsel text 10 Dutch intermediate part of the name
  first-name text 17 Christian name
  year-of-birth number integer format: YYYY
  age-class-id number long foreing key to T044-Age-class
  gender-id number long foreign key to T033-Gender
  performance-level text 1 values: [empty]; 1; 2; 3
  license-number text 8 license number of the kayak association
  archived-person-id number long foreign key to T820-Archived-person
  time-stamp-last-change date/time    

Table: T210-Address

  Attribute Type Length Remark, example
  address id number long foreign key from Person (prefix P), club-post-adress (prefix KP), club-club-adress (prefix KC)
  telephone-number text 15  
  mobile-phone-number text 15  
  fax-number text 15  
  streetname text 24  
  number text 9 house number
  postal-code text 6  
  country-code text 2  
  place text 24  
  email-address text 50  
  time-stamp-last-change date/time    

Table: T220-Official

  Attribute Type Length Remark, example
  official id counter   Primary Key
  person id number long Foreign key from T200-Person (Madantory)
  club id number long Foreign key from T300-Club (Madantory)
  role-type-id number long Foreign key to T030-Role-type
  time-stamp-last-change date/time    
  archived-official-id number long Foreign key to T810-Archived-official

Table: T230-Participant

  Attribute Type Length Remark, example
  competing-unit- id number long Foreign key from T500-Competing-unit (Mandatory)
  person id number long Foreign key from T200-Person (Madantory)
  participant-number number integer value: 1,2,3. Determinates the presenting order of persons in a competing unit.

Table: T240-Mailing-instruction

  Attribute Type Length Remark, example
  mailing-instruction-id number long primary key
  club-id number long Foreign key to T300-Club
  document-type-id number long Foreign key to T242-Document-type
  mail-mode-id number long Foreign key to T244-Mail-mode
  official-id number long Foreign key to T220-Official
  mail-destination-id number long Foreign key to T246-Mail-destination
  mailing-send boolean yes/no if yes the mailing has been send
  mailing-date date   date when mailing was send

Table: T242-Document-type

  Attribute Type Length Remark, example
  document-type-id number long primary key
  document-type-name text 25 name of the document type
  document-type-sort number integer sorting order of document types in selection lists

table of values

document-type-id document-type-name remark
1 uitnodiging invitation
2 inschrijfbevestiging entry confirmation
3 wedstrijduitslag event results
4 factuur inschrijvingen entry fees invoice

Table: T243-Document-template

  Attribute Type Length Remark, example
  document-template-id counter long primary key
  document-template-name text 25 name of the document template
  document-template-file-name text 55 file name of the document template
  document-type-id number long foreign key to T242-Document-type
  language-id number long foreign key to T065-Language

Table: T244-Mail-mode

  Attribute Type Length Remark, example
  mail-mode id number long primary key
  mail-mode-description text 25 Description of mail mode (e.g. papermail or email)
  mail-mode-sort number integer  

table of values

mail-mode-id mail-mode-description remark
1 post paper mail
2 email electronic mail
3 fax fax mail
4 hand out  

Table: T246-Mail-destination

  Attribute Type Length Remark, example
  mail-destination id number long primary key
  mail-destination-description text 25 Description of type of mail destination (e.g. club address or contact person address)

table of values

mail-destination-id mail-destination-description remark
1 contactperson send to address of the contact person
2 vereniging send to address of the kayak club

Table: T300-Club

  Attribute Type Length Remark, example
  club id counter   Primary Key
  club-abbrev text 10  
  club-name text 45  
  country-id number long fereign key to T060-Country
  language-id number long foreign key to T065-Language
  home-page-address text 40  
  archived-club-id number long foreign key to T830-Archived-club
  timestamp-last-change date/time    

Table: T400-Race

  Attribute Type Length Remark, example
  race- id counter   Primary key
  root-race-id number long foreign key to T400-Race. Is the id of the root race of x-finals
  progam-block-id number long Foreign key to T110-Program-block.(Optional)
  race-type-id number long Foreign key to T029-Race-type
  race-number number integer Race sequence number in competition (sort item)
  race-number-sub text 3 sub-id in case of splitting a race, without changing the race number
  race-sort number integer  
  race-name text 50 'K-1 Heren Senioren Prestatieniveau 3'
  show-results yes/no   yes=show in results list
  virtual-race yes/no   yes=virtual race
  course-id number long foreign key to T115-Course
  start-id number long foreign key to T420-Start (only marathon)

Table: T410-Series

  Attribute Type Length Remark, example
  series- id counter   Primary key
  seriestype-id number long foreign key to T023-Series-type
  race-id number long foreign key to T400-Race.
  scheduled-start-time date/time    
  scheduled-end-time date/time    
  spare-minutes number integer spare minutes before a series
  time-series-published date/time   time series results published
  start-interval number integer in seconds
  results-status-id number long foreign key to T022-Result-statustype
  freeze yes/no   yes=results frozen in T620-Saved-results

Table: T420-Start

(Only in Ariadne marathon)

  Attribute Type Length Remark, example
  start-id counter   internal key
  start-number number integer  
  start-name text 25  
  scheduled-startdate date/time   date of start
  scheduled-starttime date/time   time of start
  series-number number integer  
  runningtime yes/no   yes = use this start for running time display
  start-status-id number long foreign key to T020-Run-statustype
  status-timestamp date/time    
         

Table: T422-Start-event

  Attribute Type Length Remark, example
  start-event-id counter    
  start-id number long Foreign key to T420-Start
  start-timestamp date/time    
  start-time-hh number integer  
  start-time-mm number integer  
  start-time-ss number integer  
  start-time-ms number integer  
  active yes/no   yes = used for results
  timing-channel-code text 2  
  timing-event-id number long foreign key to T650-Timing-event
         

Table: T450-Category-in-race

  Attribute Type Length Remark, example
  category-id number long Foreign key from T040-Category (mandatory)
  race-id number long Foreign key from T400-Race (mandatory)

Table: T500-Competing Unit

  Attribute Type Length Remark, example
  competing-unit-id counter   Primary Key.
  category-id number long Foreign Key to T040-Category
  start-number integer 4 Start number
  club-id integer long Foreign Key to T300-Club
  competing-unit-name text 50 alias name for the CU
  late-entry yes/no   whether the entry was a post-entry
  ranking number 4 Range 1 .. 9999
  entry-cancellation yes/no   whether the entry was cancelled
  placeholder yes/no   A temporary CU to reserve a Bib or to set apart run results. Does not show in startlists of results.

Table: T510-Run

  Attribute Type Length Remark, example
  run-id counter   Primary key
  competing-unit Id number long Foreign key to T500-Competing-unit (Mandatory)
  runtype-id number long Foreign key to T019-Runtype
  ranking number integer  
  scheduled-start-time date/time    
  status-id number integer Foreign key to T020-Run-statustype
  status-time-stamp date-time    

Table: T512-Run-event

  Attribute Type Length Remark, example
  run-event-id counter   Primary key
  run-id number long Foreign key to T510-Run
  run-eventtype-id number long foreign key to T027-Run-eventtype
  run-timestamp date/time   timestamp of runevent record
  run-time-hh number integer hours
  run-time-mm number integer minutes
  run-time-ss number integer seconds
  run-time-ms number integer milli seconds
  active yes/no   Yes = used for results publishing
  timing-channel-code text 2  
  timing-event-id number long foreign key to T650-Timing-event

Table: T530-Gate-negotiation

  Attribute Type Length Remark, example
  run-id number long Foreign key from T510-Run
  participant-number number integer for teams. single cu always 1
  penalty-gate-count number integer count of how many gates have been judged
  penalty-complete yes/no   yes = judging complete
  penalty-points number integer total penalty points
  G1 number integer penalty points for this gate
  G2 number integer  
  G3 number integer  
  G4 number integer  
  G5 number integer  
  G6 number integer  
  G7 number integer  
  G8 number integer  
  G9 number integer  
  G10 number integer  
  G11 number integer  
  G12 number integer  
  G13 number integer  
  G14 number integer  
  G15 number integer  
  G16 number integer  
  G17 number integer  
  G18 number integer  
  G19 number integer  
  G20 number integer  
  G21 number integer  
  G22 number integer  
  G23 number integer  
  G24 number integer  
  G25 number integer  
  GT number integer (Time constraint for teams)
  time-stamp-penalties-complete date/time    
  penalty-check-printed yes/no   indicator whether penalty check form has been printed
  penaly-checked yes/no   indicator whether penalty has been checked

*) either total, either penalty points per gate must be entered. If both are entered, they will be counted both on the results reports, giving double penalty points values.

Table: T620-Saved-results

  Attribute Type Length Remark, example
  result-id counter   primary key
  race-id number long foreign key to T400-Race
  series-id number long foreign key to T410-Series
  competing-unit-id number long foreign key to T500-Competing-unit
  run-id number long foreign key to T510-Run
  seriestype-id number long foreign key to T023-Series-type
  split1time number single  
  run-time number single  
  penalty-points number integer  
  status-id number long foreign key to T020-run-status-type
  archived-result-id number long foreign key to T805-Archived-result
  G1 number integer penalties gate 1
  G2 number integer penalties gate 2
  G3 number integer penalties gate 3
  G4 number integer penalties gate 4
  G5 number integer penalties gate 5
  G6 number integer penalties gate 6
  G7 number integer penalties gate 7
  G8 number integer penalties gate 8
  G9 number integer penalties gate 9
  G10 number integer penalties gate 10
  G11 number integer penalties gate 11
  G12 number integer penalties gate 12
  G13 number integer penalties gate 13
  G14 number integer penalties gate 14
  G15 number integer penalties gate 15
  G16 number integer penalties gate 16
  G17 number integer penalties gate 17
  G18 number integer penalties gate 18
  G19 number integer penalties gate 19
  G20 number integer penalties gate 20
  G21 number integer penalties gate 21
  G22 number integer penalties gate 22
  G23 number integer penalties gate 23
  G24 number integer penalties gate 24
  G25 number integer penalties gate 25
  GT number integer team gate

Table: T650-Timing-event

Table to record timing events from the Alge Timy timeclock.

  Attribute Type Length Remark, example
  timing-event-id counter   primary key
  timing-event-status-id number integer foreign key to T025-Timing-event-status-type
  timing-channel-code text 2 channel that delivered timing event
  timing-event-hh number integer timing event hours
  timing-event-mm number integer timing event minutes
  timing-event-ss number integer timing event seconds
  timing-event-ms number integer timing event milliseconds
  timing-event-timestamp date/time   timestamp of record entry
  timing-event-message text 23 event message (from Timy)

Table: T660-Gate-judgement

Table to collect gate judgements from Ariadne terminal.

  Attribute Type Length Remark, example
  gate-judgement-id counter   primary key
  gate-judgement-run number integer the series number in which the gate was judged
  gate-judgement-bib number integer the bib number for which the gate was judged
  gate-judgement-participant number long participant number in team
  gate-judgement-gate number integer the gate number which was judged
  gate-judgement-penalty number integer the judgement of the gate negotiation (penalty points)
  gate-judgement-processed yes/no   indicator that the gate judgement was processed by Ariadne
  timestamp date/time   the timestamp the gate judgement was received by Ariadne

Table: T700-Ariadne-system

  Attribute Type Length Remark, example
  ariadne-version text 6 version number
  menu-number integer   number of the menu to load (1,2,3)
  serialport-startpost text 5 the serial port number to connect to the startpost device
  serialport-timy text 5 the serial port number to connect to the Timy timer
  polling-interval-penalty-processing number integer seconds
  url-ariadne-internet-results-local text 120  
  url-ariadne-internet-results-internet text 120  
  internet-select yes/no   yes (true; -1) =internet; no(false;0)=local

Table: T702-Module

  Attribute Type Length Remark, example
  module-id counter   internal key
  module-code text 3 code for the module (CC = current competetion, AR=archive)
  module-name text 20 name of the module
  module-database text 40 name of the database of the module

Table: T705-Message

  Attribute Type Length Remark, example
  message-id counter 6 internal key
  message-nbr number integer message number
  message-text text 150 message text other language
  message-text-english text 150 message text in English

Table: T710-Table

  Attribute Type Length Remark, example
  table-id counter    
  module-id number long foreign key to T702-Module
  table-name text 30 name of the Ariadne Table

T710-Table is used to re-establish the link of the linked Tables at start up.

Table: T720-Function

  Attribute Type Length Remark, example
  function-id counter   internal id of teh function
  object-type text 1 code for object type; F:=Form; R:=Report; M:=Macro
  object-name text 50 name of the object to start (form-name, report-name etc.)
  function-number text 6 number of the software function according to the technical documentation

Table: T732-menu-item

  Attribute Type Length Remark, example
  menu-item-id counter   internal id of menu item
  item-sort number integer sort order for menu items
  item-level number integer specifies menu-level-number: 1,2,3,4.. 10
  image-key text 10 image-key in ImageList of TreeView
  item-text text 50 item text to appear on the menu (current language)
  item-text-english text 50 item text in English
  expanded yes/no   whether the menu node needs to be displayed expanded
  function-id number long foreign key to Operation-type
  menu-1 yes/no   if selected, item is displayed in menu 1
  menu-2 yes/no   if selected, item is displayed in menu 2
  menu-3 yes/no   if selected, item is displayed in menu 3
  item-text-dutch text 50 item text in Dutch
         
   

Table: T740-Control

  Attribute Type Length Remark, example
  control-id counter   internal id of the control
  control-type number integer Access control type id
  control-name text 100 name of the control in Ariadne
  caption memo   caption text in current language
  caption-english memo   English caption text
  caption-dutch memo   Dutch caption text
  function-id number long foreign key to T720-Function
  deletion-indicator boolean   indicator whether the control is outdated, and can be deleted

Table: T742-Control-type

  Attribute Type Length Remark, example
  control-type-id number integer Access control type id
  control-type-name text 25 name of the control in Ariadne

Table: T750-Help-page

  Attribute Type Length Remark, example
  help-page-id counter   internal key
  help-page-number text 10 indentification number for help pages
  help-page-description text 80 description of the help page
  language-id number long foreign key to T065-Language
  help-page-file-name text 40 the html file name with the content of the help page
  help-page-available tes/no   yes = help page available

Table: T800-Archived-competition

  Attribute Type Length Remark, example
  archived-competition-id counter   Primary key
  competition-name-abbrev text 15 example: 'GM2000'
  competition-name text 80 example: 'Genneper Molen 2000'
  competition-start-date date/time    
  ranking-scale-0-point integer   result (seconds) which makes the 0 point
  ranking-scale-100-point integer   result (seconds) which makes the 100 point
  ariadne-version text 6 version number of Ariadne which was used for this competition.
  current-competition-id number long temporary foreign key to T100-Competition

Table: T805-Archived-result

  Attribute Type Length Remark, example
  archived-result-id counter   internal id
  archived-competition-id number long Foreign key toT800-Archived-competition
  CU-name text 60 Name of the competing unit
  archived-person-id number long Foreign key to T820-Archived-person
  event-result number double Total result over series (including penalties)
  archived-club-id number long foreign key to T830-Archived-club
  archived-category-id number long Foreign key to T840-Archived-category
  result-id number long temporary foreign key to T620-Saved-results

Table: T810-Archived-official

  Attribute Type Length Remark, example
  archived-official id counter   Primary Key
  archived-competition-id number long Foreign key to T010-Archived competition
  archived-person-id number long Foreign key to Person
  role-type-id number long Foreign key to T030-Role-type
  archived-club- id number long foreign key to T830-Archived-club
  time-stamp-last-change date/time    
  official-id number long temporary foreign key to T220-Official

Table: T820-Archived-person

  Attribute Type Length Remark, example
  archived-person-id counter   Primary Key
  surname text 45 family name
  nitials text 20  
  tussenvoegsel text 10 Dutch intermediate part of the name
  first-name text 17 Christian name
  year-of-birth number integer format: YYYY
  age-class-id number long foreing key to T044-Age-class
  gender-id number long foreign key to T033-Gender
  performance-level text 1 values: [empty]; 1; 2; 3
  license-number text 8 racing license number of the sports association
  time-stamp-last-change date/time    
  person-id number long temporary foreign key to T200-Person

Table: T830-Archived-club

  Attribute Type Length Remark, example
  archived-club-id counter   Primary Key
  club-abbreviation text 10  
  club-name text 45  
  nationality text 2 Country code
  home-page-address text 40  
  time-stamp-last-change date/time    
  club-id number long temporary foreign key to T300-Club

Table: T840-Archived-category

  Attribute Type Length Remark, example
  archived-category id counter   Primary key
  category-abbrev text 15 Key. example: K-1H PN2
  category-name text 50 Full name. 'K-1 Heren senioren prestatieniveau 2'
  gender-id number long foreign key to T033-Gender
  boat-type-id number long foreign key to T032-Boat-type
  age-class-id number long foreign key to T044-Age-type
  cu-type-id number long foreign key to T031-CU-type
  series number integer number of series is a category
  sports-discipline-id number long foreign key to T024-Sports-discipline
  time-stamp-last-change date/time    
  category-id number long temporary foreign key to T040-Category

Table: T880-Start-interval

  Attribute Type Length Remark, example
  start-interval-id counter   Primary key
  archived-competition-id number long foreing key to T800-Archived-competition
  archived-category-id integer long foreign key to T840-Archived-category
  start-interval number integer average start interval (sec)