There are four main databases in Southcoast Database for the data in Australia and New Zealand. The Master, The Meeting Master, The Race Master and The Horse Master – all relationally connected. There are also a number of other tables which house the barrier trials, comments, average times for each track etc. (note- Hong Kong uses a different structure. For more info, ask)
Below are the structures of each of the four main tables.
MASTER (WORKRACE)
Field Field Name Type Width
1 W_DATE Date 8
2 W_RACE_NO Numeric 2
3 W_HORSE Character 24
4 W_TRACK Character 4
5 W_WGHT_CAR Character 4
6 W_AP_CLAIM Character 4
7 W_BEAT_MAR Character 4
8 W_JOCKEY Character 20
9 W_MONY_WON Character 15
10 W_BAR_POS Numeric 2
11 W_FIN_POS Numeric 2
12 W_BOOK_PRI Character 5
13 W_WGHT_RAT Numeric 4
14 W_800_400 Character 5
15 W_FLUCTS Character 20
16 W_TRAINER Character 20
MEETING MASTER
Field Field Name Type Width
1 M_DATE Date 8
2 M_TRACK Character 4
3 M_STATE Character 3
4 M_MET_TYPE Character 1
5 M_CLUB Character 33
RACE MASTER
Field Field Name Type Width
1 R_DATE Date 8
2 R_RACE_NO Numeric 2
3 R_TRACK Character 4
4 R_DISTANCE Character 5
5 R_GROUP Character 3
6 R_TR_COND Character 1
7 R_CLASS Character 12
8 R_RACE_NAM Character 29
9 R_AGE Character 5
10 R_SEX Character 4
11 R_RACE_TYP Character 6
12 R_LIM_WGHT Character 4
13 R_MAX Numeric 2
14 R_VALUE Character 7
15 R_TIME Character 7
16 R_WIN_TAB Numeric 2
17 R_SEC_TAB Numeric 2
18 R_THI_TAB Numeric 2
19 R_SEC_TIME Character 10
HORSE MASTER
Field Field Name Type Width
1 H_HORSE Character 24
2 H_DATE Date 8
3 H_SIRE_WIN Character 24
4 H_DAM_WIN Character 24
5 H_WIN_AGE Numeric 2
6 H_WIN_SEX Character 1
7 H_TRAINER Character 24
