Southcoast Database


Structure of Databases
There are four main databases in Southcoast Database. The Master,
The Meeting Master, The Race Master and The Horse Master - all relationally connected.
Below are the structures of each.

MASTER

Field  Field Name  Type       Width    Dec    Index  Collate
    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      1
   14  W_800_400   Character      5
** Total **                     104

MEETING MASTER

Field  Field Name  Type       Width    Dec    Index  Collate
    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
    6  M_MAX       Numeric        2
    7  M_R_VALUE   Character      7
    8  M_R_TIME    Character      7
    9  M_WIN_TAB   Numeric        2
   10  M_SEC_TAB   Numeric        2
   11  M_THI_TAB   Numeric        2
** Total **                      72

RACE MASTER

Field  Field Name  Type       Width    Dec    Index  Collate
    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
** Total **                     107

HORSE MASTER

Field  Field Name  Type       Width    Dec    Index  Collate
    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
** Total **                     108


******CLICK HERE TO RETURN TO THE TOP OF THIS PAGE******