Ariadne - Technical description
A040 |
Clubs |
1. Description
Screen F300-Clubs displays an overview of the known (canoe/kayak) clubs in the Ariadne database. On screen F310-Club-details club data can be maintained, and clubs can be added and deleted.
2. Access path
 F000-Menu |
|
 F300-Clubs |
|
| F310-Club-details |
|
| F220-Officials |
|
| F240-Mailing-profile |
|
| F210-Address |
|
| F010-Remark |
|
| F810-Archived-officials |
3. Screen shot: F300-Club
4. Function structure
| Form | Control | (Sub)form | Query | Table | Attribute |
| F300-Clubs | Q304-Clubs | T300-Club Q501-Number-of-entries-club |
|||
| Q501-Number-of-entries-club | T300-Club T500-Competing-unit |
||||
| Listbox CurrentCompetition |
Q100-Current-competition | T100-Current-competition | |||
| Button ButtonClubDetails |
F310-Club-details |
ClubId *) | |||
| Button ButtonEntries |
F500-Entries-per-club | ClubId *) | |||
| Button ButtonAdd |
F310-Club-details | ClubId = -1 **) | |||
| Button ButtonClose |
*) navigating between forms with this public variable.
**) ClubId = -1 means new club
| Form | Control | Subform | Query | Table | Attribute |
| F310-Club-details | Q300-Club | T300-Club | |||
| dropbox nationality |
T060-Country | country-code | |||
| subform Officials |
F220-Officials | club-id | |||
| subform MailingProfile |
F240-Mailing-profile | club-id | |||
| subform Address |
F210-Address | address-id (1) | |||
| subform remarks-sub |
F010-Remarks | remark-id (2) | |||
| subform ArchivedOfficials |
F810-Archived-officials | club-id | |||
| Button ButtonEntries |
F500-Entries-kayak-club | ClubId *) | |||
| Button ButtonClose |
|||||
| Event | Action | Query | Table | Attribute | |
| on delete | delete related remark and address records |
(1) Club address is linked to club-id met prefix K
(2) Remarks is linked club-id met prefix K
Mailing profile
With the mailing profile, per club, per document type the addressee and the destination address can be specified. The data model below shows the related tables.
The mailing profile is official / person specific, and need to be actualized with each new competition. (e.g. per competition the roles can be fullfilled by other persons, who prefer the mail te be send in other mail modes (email, papermail ).
| Form | Control | Subform | Query | Table | Attribute |
| F240-Mailing-profile | Q240-Mailing-instructions | T240-Mailing-instruction | |||
| dropbox document-type-id |
Q242-Document-type | T242-Document-type | document-type-id | ||
| dropbox official-id |
Q224-Officials-F240 *) | T030-Role-type T200-Person T220-Official |
official-id | ||
| dropbox mail-mode-id |
Q244-Mail-mode | T244-Mail-mode | mail-mode-id | ||
| dropbox mail-destination-id |
Q246-Mail-destination | T246-Mail-destination | mail-destination-id |
*) need to be requeried, every time the kayak club changes on the form
| Form | Control | Subform | Query | Table | Attribute |
| F220-Officials | Q222-Officials | T220-Official | |||
| dropbox person-id |
Q205-Person-select | T033-Gender T044-Age-class T200-Person |
person-id | ||
| dropbox role-type-id |
Q030-Role-type | role-type-id | |||
| Button ButtonPerson |
F200-Person |
| Form | Control | Subform | Query | Table | Attribute |
| F810-Archived-officials | Q810-Archived-officials | T030-Role-type T800-Archived-competition T200-Person T810-Archived-official |
kayak-club-id | ||
| button ButtonCopyToCurrent |
action: copies the archived person-id and role-type-id to the current competition |
Change history
| date | version | change |
| jan2016 | A5.4 | reviewed and updated |
| 27 jan 2003 | 1.7 | Sub form Archived officials added, copy button added. |
| 09 jan 2003 | 1.6 | Club location address removed. The kayak club keeps one mail address. Mailing profile added. Officials moved from independed form to tab-page |
| 01-10-02 | 1.5 | Ariadne 4.1, text converted to html |