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
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 Event, Categories, Person and Competition. Remarks are linked to these Tables, with a foreign key, which is derived from the primary key of the related Table, prefixed with a letter. (E for Event, C for Categories, P for person, S for Slalom-program).

Table: T020-Run-statustype

Attribute	Type	Length	Remark, example
Status id	counter		Primary key
Status description	text	12
Status sort	numeric	integer

Status type: Table of values

status-id	status-description	status-sort	status-results
-1	Geïnitialiseerd	0	init
0	Nog niet gestart	7	DNS
1	Gestart	1	DNF
2	Gefinished	2	finished
3	Compleet	3	compl.
4	Gekenterd	4	DNF

Table: T021-Results-type

Picklist for dropbox to select results for series 1 or series 1+2

Attribute	Type	Length	Remark, example
resultstype-id	numeric	long	Primary key
resultstype-abbrev	text	15

Results type: Table of values

resultstype-id	resultstype-abbrev
1	Series 1
2	Series 1+2

Table: T022-Results-statustype

Picklist for dropbox to select status for an event result

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

Resulst 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: T030-Role-type

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

Role types: Table of values

role-id	role-name
1	Deelnemer
2	Inschrijvingen
3	Wedstrijdleider
4	Poortrechter
5	Tijdwaarneming

Table: T031-CU-type

Attribute	Type	Length	Remark, example
CU-type-id	counter		Primary key
CU-type-name	text	5

Competing Unit type: Table of values

CU-type-id	CU-type-naam
1	solo
2	duo
3	ploeg

Table: T032-Boat-type

Attribute	Type	Length	Remark, example
Boat type id	integer		Primary key
Boat type name	text	7	Key. example: K1H PN2

Boat type: Table of values

boat-type-name

Polo

Sprint

Fun

Table: T033-Gender

Attribute	Type	Length	Remark, example
gender-id	counter		Primary key
Gender	text	1

Gender: Table of values

Gender	Value
H	Heren
D	Dames
X	Mix

Table: T040-Category

Attribute	Type	Length	Remark, example
Category id	counter		Primary key
Category abbreviation	text	15	Key. example: K-1H PN2
Category name	text	50	Full name. 'K-1 Heren senioren prestatieniveau 2'
Category sort	integer	3	sorts category in preferred order
Gender-id	integer	long	foreing key to Gender
Boat-type-id	integer	long	foreing key to Boat type
Age-class-id	integer	long	foreing key to Age class
cu-type-id	integer	long	Competing unit type id. values: 1 (solo), 2 (tandem) ,5 (team)
series	integer		Number of race series which is required for this category. Normally 2 of 1.
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
Time stamp last change	date/time
archived-category-id	Numeric	long	foreign key to T840-Archived-category

Table: T044-Age-class

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

Age-class: Table of values

class-abbrev	age-min	age-max	omschrijving
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
Starting number	integer	4	range 1 .. 400
Number available	binary	1	y/n

Table: T060-Country

Attribute	Type	Length	Remark, example
Country code	text	2	Primary key ISO-2 country code
Country name	text	35
default-language-id	numeric	long	default language. Foreign key to T065-Language

Country code: Table of values

country-code	country-name
BE	Belgie
CH	Zwitserland
DE	Duitsland
FR	Frankrijk
GB	Engeland
NL	Nederland
US	Verenigde Staten

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 code: Table of values

Language-code	Language-name
Dut	Dutch
Ger	German
Fra	French
Eng	English

Table: T081-SI-temp

Help tabel to calculate startinterval

Attribute	Type	Length	Remark, example
category-id	numeric	long	Foreing key to T040-Category
category-abbrev	text	15	category abbreviation
start-interval	numeric	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
Run-event pointer	numeric	long	pointer to last processed event in T600-Event-buffer
startinterval-init-competition	text	15	Competition from which the start interval of the current competition was initialized
slalom-course-correction-factor	numeric	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	numeric	integer	1 = entry of total penalty points, 2=entry of penalty points per gate
refresh-rate-event-monitoring	numeric	integer	(seconds) (also refresh rate publication screen)
entry-period-closed	boolean		yes = entry period is closed
security-start-numbers	numeric	single	security amount for using the start number displays
person-name-display-order	numeric	integer	specifies the display order of the persons name: 1=first-name;surname, 2=surname;first-name
archived-competition-id	numeric	long	foreign key to T800-Archived-competitions
timing-offset-hh	numeric	integer	time offset between timing clocks - hours
timing-offset-mm	numeric	integer	time offset between timing clocks - minutes
timing-offset-ss	numeric	integer	time offset between timing clocks - seconds
timing-offset-ms	numeric	integer	time offset between timing clocks - milliseconds
timing-accuracy	numeric	long	accuracy of timing. Values 1 = seconds, 10 = 0,1 sec, 100= 0,01 sec, 1000= 0,001sec
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
email-address	text	135	email addres of the organizing club
web-url	hyperlink		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	integer	4	sort item
Program Block name	text	40	e.g. 'Avond slalom'
Starting time	time		Scheduled time to start
End time	time	4	Scheduled time to end
Block type	text	10	Race or Pause

Table: T112-Program-block-item

Helper table to calculate the competition time schedule

Attribute	Type	Length	Remark, example
program-block-id	numeric	long	foreign key to T110-Program-block
event-name	text	50	name of the event
event-number	numeric	integer	event number
event-number-sub	text	3	sub number in case of splitting events
series-number	numeric	integer	series number
start-interval	numeric	long	start interval (sec)
number-participants	numeric	long	number of participants in event
duration-time	date/time		duration of the block item (time format)

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-id	long		foreign key to gate section

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

Table: T130-Gate-section

Attribute	Type	Length	Remark, example
Gate-section-id	counter		Primary key
Gate-section-number	integer	4	Number of the gate section
Gate-section-name	text	50	description of the gate section

The number of gate section vary by the circumstances of the slalom course. Typically a slalom course requires 4 to 8 gate sections. In future the gate section can have a relation to gate judge.

Table: T200-Person

Attribute	Type	Length	Remark, example
Person id	counter		Primary Key
Surname	text	45	Surname – Achternaam
Initials	text	20	incl. tussenvoegsels
tussenvoegsel	text	10	Dutch intermediate part of the name
First name	text	17	Christian name
Year-of-birth	numeric	integer	format: YYYY
age-class-id	numeric	long	foreing key to Age class
gender-id	numeric	long	foreign key to Gender
performance-level	text	1	values: [empty]; 1; 2; 3
license-number	text	8	license number of the kayak association
archived-person-id	numeric	long	foreign key to T820-Archived-person
Time stamp last change	date/time

Table: T210-Adress

Attribute	Type	Length	Remark, example
Person id	numeric	long	Foreign key from Person
Telephone number	text	15
Mobile phone number	text	15
Fax number	text	15
Street / Post office box	text	24
Number	text	9
Postal code	text	6
Country code	text	2
Place	text	24
Email adress	text	30
Time stamp last change	date/time

Table: T220-Official

Attribute	Type	Length	Remark, example
Official id	counter		Primary Key
Person id	numeric	long	Foreign key from Person (Madantory)
Kayak Club id	numeric	long	Foreign key from Kayak club(Madantory)
Role-type-id	numeric	long	Foreign key to T030-Role-type
Time stamp last change	date/time

Table: T230-Participant

Attribute	Type	Length	Remark, example
Competing-unit- id	counter		Foreign key to competing unit (Mandatory)
Person id	numeric	long	Foreign key from Person (Madantory)
Participant-number	numeric	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	numeric	long	primary key
club-id	numeric	long	Foreign key to T300-Club
document-type-id	numeric	long	Foreign key to T242-Document-type
mail-mode-id	numeric	long	Foreign key to T244-Mail-mode
official-id	numeric	long	Foreign key to T220-Official
mail-destination-id	numeric	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	numeric	long	primary key
document-type-name	text	25	name of the document type
document-type-sort	numeric	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

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	numeric	long	foreign key to T242-Document-type
language-id	numeric	long	foreign key to T065-Language

Table: T244-Mail-mode

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

table of values

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

Table: T246-Mail-destination

Attribute	Type	Length	Remark, example
Mail-destination id	numeric	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-abbreviation	text	10
club-name	text	45
nationality	text	2	Country code
language-id	numeric	long	foreign key to T065-Language
home-page-adress	text	40
archived-club-id	numeric	long	foreign key to T830-Archived-club
timestamp-last-change	date/time

Table: T400-Event

Attribute	Type	Length	Remark, example
Event id	counter		Primary key
Progam block id	numeric	long	Foreign key from Program Block.(Optional)
Event-number	nemeric	integer	Event sequence number in competition (sort item)
event-number-sub	text	3	sub-id in case of splitting a race, without changing the race number
event-name	text	50	'K-1 Heren Senioren Prestatieniveau 3'
Series	numeric	integer	Number of series (1 or 2)
start-interval	numeric	integer	startinterval (seconds)
freeze	boolean		indicator whether results are frozen because of publication
series-published	numeric	integer	a indicator for the event results request form which series were last requested
entry-fee	numeric	single	amount of entry fee for this event
entry-fee-late-entry	numeric	single	amount of entry fee for late entries
start-id	numeric	long	foreign key to T420-Start (Ariadne Marathon)
virtual-event	boolean		yes=virtual event
resultstatus-series1	numeric	long	foreign key to T022-Results-statustype
resultstatus-series12	numeric	long	foreign key to T022-Results-statustype

Table: T420-Start

(Ariadne marathon: A start is a start for one or more events a a whole (group start))

Attribute	Type	Length	Remark, example
start-id	counter		internal key
start-timestamp	date/time		date/time of start record
start-name	text	25	name of the start
starttime-hh	numeric	integer	hours part (Start time from backup time entry)
starttime-mm	numeric	integer	minutes part
starttime-ss	numeric	integer	seconds part
starttime-ms	numeric	integer	milli seconds part
offset	yes/no		yes = apply offset time in elapsed time calculation

Table: T450-Category-in-Event

Attribute	Type	Length	Remark, example
Category id	numeric	long	Foreign key from Category (mandatory)
Event id	numeric	long	Foreign key from Event (mandatory)

Table: T500-Competing Unit

Attribute	Type	Length	Remark, example
competing-unit-id	counter		Primary Key.
category id	numeric	long	Foreign Key to T040-Category
event-id	numeric	long	Foreign Key to T400-Event
start-number	integer	4	Start number
kayak-club-id	integer	long	Foreign Key to T300-Kayak-club
competing-unit-name	text	50	alias name for the CU
post-entry	yes/no		whether the entry was a post-entry
entry-cancellation	yes/no		whether the entry was cancelled
ranking	numeric	4	Range 1 .. 9999
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	numeric	long	Foreign key from Competing Unit(Mandatory)
Series number	numeric	integer	1 or 2 . Sort item (Mandatory)
Status-id	numeric	long	Foreign key from Status type (mandatory)
Status-time-stamp	date-time		timestamp of status change
Start-time-stamp	date-time		timestamp start record
starttime-hh	numeric	integer	>=0; <=23 data entry from backup timing system
starttime-mm	numeric	integer	>=0; <=59
starttime-ss	numeric	integer	>=0; <=59
starttime-ms	numeric	integer	>=0; <=999 (milli-seconds)
startevent-id	numeric	long	foreign key to T650-Timing-event
finish-timestamp	date-time		timestamp finish record
finishtime-hh	numeric	integer	>=0; <=23
finishtime-mm	numeric	integer	>=0; <=59
finishtime-ss	numeric	integer	>=0; <=59
finishtime-ms	numeric	integer	>=0; <=999
finishevent-id	numeric	long	foreign key to T650-Timing-event

Design decision (26-09-02): Because of the same type of entry faults at GM2002 and RCC2002, T500-Competing-unit records wil in all cases be acompanied of T510-Run records.

Table: T530-Gate-negotiation

Attribute	Type	Length	Remark, example
Gate-negotiation-id	counter		primary key
Run-id	numeric	long	Foreign key from Run
total	numeric	long	total penalty points *)
1	numeric	integer	penalty points for this gate **)
2	numeric	integer
3	numeric	integer
4	numeric	integer
5	numeric	integer
6	numeric	integer
7	numeric	integer
8	numeric	integer
9	numeric	integer
10	numeric	integer
11	numeric	integer
12	numeric	integer
13	numeric	integer
14	numeric	integer
15	numeric	integer
16	numeric	integer
17	numeric	integer
18	numeric	integer
19	numeric	integer
20	numeric	integer
21	numeric	integer
22	numeric	integer
23	numeric	integer
24	numeric	integer
25	numeric	integer
T	numeric	integer	(Time constraint for teams)

*) 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.

**) Penalty point values must be 0 or even. Penalty points from tandems en teams can have values other than 0,2,50.

Table: T570-Saved-event-results

Attribute	Type	Length	Remark, example
event-id	numeric	long	foreign key to T400-Event
competing-unit-id	numeric	long	foreign key to T500-Competing-unit
series1-elapsed-time	numeric	single
series1-penalty-points	numeric	integer
series1-status-id	numeric	long	foreign key to T020-Status
series2-elapsed-time	numeric	single
series2-penalty-points	numeric	integer
series2-status-id	numeric	long	foreign key to T020-Status

Table: T640-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-number	numeric	integer	the start / finish event number Timy forwards
timing-event-type	numeric	integer	0=start event, 1 = finish event
timing-event-time	text	15	time from Timy in hh:mm:ss,pqrs
timing-event-status	numeric	integer	0=not assigned, 1=assigned, 2=DSQ (disqualified)

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	numeric	integer	the series number in which the gate was judged
gate-judgement-bib	numeric	integer	the bib number for which the gate was judged
gate-judgement-gate	numeric	integer	the gate number which was judged
gate-judgement-penalty	numeric	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	integer		the serial port number to connect to the startpost device
serialport-timy	integer		the serial port number to connect to the Timy timer

Table: T702-Module

Attribute	Type	Length	Remark, example
module-id	counter		internal key
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	numeric	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-name	text	30	name of the Ariadne Table
database-abbrev	text	1	indication of the database where the Table resides: A:= Ariadne-main; C:= Current competition; H:=History database

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.)

Table: T732-menu-item

Attribute	Type	Length	Remark, example
menu-item-id	counter		internal id of menu item
menu-id	numeric	long	foreign key to menu
item-sort	numeric	integer	sort order for menu items
item-level	numeric	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	numeric	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

Table: T740-Control

Attribute	Type	Length	Remark, example
control-id	counter		internal id of the control
control-type	numeric	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
function-id	numeric	long	foreign key to T720-Function
deletion-indicator	boolean		indicator whether the control is outdated, and can be deleted

Table: T800-Archived-competition

Attribute	Type	Length	Remark, example
Archived Competition id	counter		Primary key
Competition-name	text	80	'Genneper Molen 2000'
Competition-name-abbreviation	text	15	'GM2000'
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.

Table: T805-Archived-result

Attribute	Type	Length	Remark, example
Results-id	counter		internal id
Archived-competition-id	numeric	long	Foreign key toT800-Archived-competition
Competition-name-abbrev	text	15	*)
Kayak-club-abbrev	text	10	*)
CU-name	text	60	Name of the competing unit
archived-person-id	numeric	long	Foreign key to T820-Archived-person
Category-id	numeric	long	Foreign key to T040-Category
Category-abbrev	text	15	*)
event-result	numeric	double	Total result over series (incl. penalties)
archived-kayak-club-id	numeric	long	foreign key to T830-Archived-kayak-club

*) The abbreviations are recorded redundantly, to be able to view the results independently of the related Tables. Also, some results are imported, for instance from the Holland Cup rankings, for which no relateds records are available.

Table: T810-Archived-official

Attribute	Type	Length	Remark, example
archived-official id	counter		Primary Key
archived-competition-id	numeric	long	Foreign key to T010-Archived competition
archived-person-id	numeric	long	Foreign key to Person
person-name	text	60	name of the official
archived-kayak-club- id	numeric	long	Foreign key to T300-Kayak-club
kayak-club-abbrev	text	15
role-type-id	numeric	long	Foreign key to T030-Role-type
Time stamp last change	date/time

Table: T820-Archived-person

Attribute	Type	Length	Remark, example
archived-person-id	counter		Primary Key
Name	text	45	Surname – Achternaam
Initials	text	20	incl. tussenvoegsels
tussenvoegsel	text	10	Dutch intermediate part of the name
First name	text	17	Christian name
Year-of-birth	numeric	integer	format: YYYY
age-class-id	numeric	long	foreing key to Age class
gender-id	numeric	long	foreign key to Gender
performance-level	text	1	values: [empty]; 1; 2; 3
license-number	text	8	license number of the kayak association
Time stamp last change	date/time

Table: T830-Archived-kayak-club

Attribute	Type	Length	Remark, example
archived-kayak-club-id	counter		Primary Key
Kayak Club abbreviation	text	10
Kayak Club name	text	45
Nationality	text	2	Country code
Home page adress	text	40
Time stamp last change	date/time

Table: T840-Archived-category

Attribute	Type	Length	Remark, example
Category id	counter		Primary key
Category abbreviation	text	15	Key. example: K-1H PN2
Category name	text	50	Full name. 'K-1 Heren senioren prestatieniveau 2'
Category sort	integer	3	sorts category in preferred order
Gender	text	1	Gender(H, D, X)
Boat-type	text	3	Boat type (e.g. K1, K2, C1, C2)
Age-class	text	3	Age class (S, V1, V2 etc.)
Competing Unit Type	text	1	1 (solo), 2 (tandem) ,3 (team)
Time stamp last change	date/time

Table: T880-Start-interval

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