Database Structures

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

South coast Database-South coast Services