DATABASE "db1"
  TYPE "access"
  DB_SPECIFIC "include_tables=collar,survey,translation,styles,geology,sample,weathering"
  TABLE collar
    DB_SPECIFIC "include_fields=hole_id,y,x,z,max_depth,hole_path,date_drilled,drilling_co,geologist,hole_type,prospect"
    FIELD hole_id
      TYPE character( 12)
      VALIDATION "SSI_edit_style=upper~SSI_length=12"
    FIELD y
      TYPE real( 11,  3)
      VALIDATION "SSI_edit_style=r8~SSI_bounds=-999999.000000 9999999.000000~SSI_decimals=3~SSI_length=11"
    FIELD x
      TYPE real( 11,  3)
      VALIDATION "SSI_edit_style=r8~SSI_bounds=-999999.000000 9999999.000000~SSI_decimals=3~SSI_length=11"
    FIELD z
      TYPE real( 11,  3)
      VALIDATION "SSI_edit_style=r8~SSI_bounds=-999999.000000 9999999.000000~SSI_decimals=3~SSI_length=11"
    FIELD max_depth
      TYPE real( 11,  3)
      VALIDATION "SSI_edit_style=r8~SSI_bounds=0.000000 9999.000000~SSI_decimals=3~SSI_length=11"
    FIELD hole_path
      TYPE character(  6)
      VALIDATION "SSI_edit_style=mixed~SSI_decimals=3~SSI_length=6"
      NULLS
    FIELD hole_type
      TYPE character(  5)
      VALIDATION "SSI_edit_style=mixed~SSI_decimals=3~SSI_length=5"
      NULLS
    FIELD geologist
      TYPE character(  5)
      VALIDATION "SSI_edit_style=mixed~SSI_decimals=3~SSI_length=5"
      NULLS
    FIELD prospect
      TYPE character( 12)
      VALIDATION "SSI_edit_style=mixed~SSI_decimals=3~SSI_length=12"
      NULLS
    FIELD date_drilled
      TYPE datetime
      VALIDATION "SSI_edit_style=datetime~SSI_decimals=3~SSI_length=24"
      NULLS
    FIELD drilling_co
      TYPE character( 10)
      VALIDATION "SSI_edit_style=mixed~SSI_decimals=3~SSI_length=10"
      NULLS
    INDEX PrimaryKey   UNIQUE
      ASC hole_id
  TABLE geology
    DB_SPECIFIC "include_fields=hole_id,depth_from,depth_to,samp_id,rock,y_from,x_from,z_from,y_to,x_to,z_to"
    FIELD hole_id
      TYPE character( 12)
      VALIDATION "SSI_edit_style=upper~SSI_length=12"
    FIELD depth_from
      TYPE real( 11,  3)
      VALIDATION "SSI_edit_style=r8~SSI_bounds=0.000000 9999.000000~SSI_decimals=2~SSI_length=7"
    FIELD samp_id
      TYPE character( 10)
      VALIDATION "SSI_edit_style=mixed~SSI_decimals=3~SSI_length=10"
      NULLS
    FIELD depth_to
      TYPE real( 11,  3)
      VALIDATION "SSI_edit_style=r8~SSI_bounds=0.000000 9999.000000~SSI_decimals=2~SSI_length=7"
    FIELD rock
      TYPE character(  5)
      VALIDATION "SSI_edit_style=mixed~SSI_decimals=3~SSI_length=5"
      NULLS
    FIELD y_from
      TYPE real( 11,  3)
      CALCULATED y(hole_id,depth_from)
    FIELD x_from
      TYPE real( 11,  3)
      CALCULATED x(hole_id,depth_from)
    FIELD z_from
      TYPE real( 11,  3)
      CALCULATED z(hole_id,depth_from)
    FIELD y_to
      TYPE real( 11,  3)
      CALCULATED y(hole_id,depth_to)
    FIELD x_to
      TYPE real( 11,  3)
      CALCULATED x(hole_id,depth_to)
    FIELD z_to
      TYPE real( 11,  3)
      CALCULATED z(hole_id,depth_to)
    INDEX geology   UNIQUE
      ASC hole_id
      ASC depth_from
  TABLE sample
    DB_SPECIFIC "include_fields=hole_id,depth_from,depth_to,samp_id,gold,gold_rpt,y_from,x_from,z_from,y_to,x_to,z_to"
    FIELD hole_id
      TYPE character( 12)
      VALIDATION "SSI_edit_style=upper~SSI_length=12"
    FIELD depth_from
      TYPE real( 11,  3)
      VALIDATION "SSI_edit_style=r8~SSI_bounds=0.000000 9999.000000~SSI_decimals=2~SSI_length=7"
    FIELD samp_id
      TYPE character( 10)
      VALIDATION "SSI_edit_style=mixed~SSI_decimals=3~SSI_length=10"
      NULLS
    FIELD depth_to
      TYPE real( 11,  3)
      VALIDATION "SSI_edit_style=r8~SSI_bounds=0.000000 9999.000000~SSI_decimals=2~SSI_length=7"
    FIELD gold
      TYPE real( 11,  3)
      VALIDATION "SSI_edit_style=r8~SSI_decimals=3~SSI_length=11"
      NULLS
    FIELD gold_rpt
      TYPE real( 11,  3)
      VALIDATION "SSI_edit_style=r8~SSI_decimals=3~SSI_length=11"
      NULLS
    FIELD y_from
      TYPE real( 11,  3)
      CALCULATED y(hole_id,depth_from)
    FIELD x_from
      TYPE real( 11,  3)
      CALCULATED x(hole_id,depth_from)
    FIELD z_from
      TYPE real( 11,  3)
      CALCULATED z(hole_id,depth_from)
    FIELD y_to
      TYPE real( 11,  3)
      CALCULATED y(hole_id,depth_to)
    FIELD x_to
      TYPE real( 11,  3)
      CALCULATED x(hole_id,depth_to)
    FIELD z_to
      TYPE real( 11,  3)
      CALCULATED z(hole_id,depth_to)
    INDEX sample   UNIQUE
      ASC hole_id
      ASC depth_from
  TABLE styles
    FIELD table_name
      TYPE character( 18)
      VALIDATION "SSI_edit_style=lower~SSI_length=18"
    FIELD field_name
      TYPE character( 18)
      VALIDATION "SSI_edit_style=lower~SSI_length=18"
    FIELD style_type
      TYPE character(  1)
      VALIDATION "SSI_edit_style=upper~SSI_set=;C;N;D~SSI_length=1"
    FIELD code
      TYPE character( 20)
      VALIDATION "SSI_edit_style=mixed~SSI_length=20"
      NULLS
    FIELD from_value
      TYPE character( 23)
      VALIDATION "SSI_edit_style=mixed~SSI_length=23"
      NULLS
    FIELD to_value
      TYPE character( 23)
      VALIDATION "SSI_edit_style=mixed~SSI_length=23"
      NULLS
    FIELD graphics_colour
      TYPE character( 32)
      VALIDATION "SSI_edit_style=mixed~SSI_length=32"
    FIELD plotting_colour
      TYPE character( 32)
      VALIDATION "SSI_edit_style=mixed~SSI_length=32"
    FIELD graphics_pattern
      TYPE character(  5)
      VALIDATION "SSI_edit_style=mixed~SSI_set=;solid;##;||;==;//;\\\\;::;<><>;[][]~SSI_length=5"
    FIELD plotting_pattern
      TYPE character( 16)
      VALIDATION "SSI_edit_style=mixed~SSI_length=16"
    FIELD line_colour
      TYPE character( 32)
      VALIDATION "SSI_edit_style=mixed~SSI_length=32"
    FIELD line_style
      TYPE character( 32)
      VALIDATION "SSI_edit_style=mixed~SSI_length=32"
    FIELD line_weight
      TYPE integer(  4)
      VALIDATION "SSI_edit_style=i4~SSI_bounds=1 9~SSI_length=4"
    FIELD marker_style
      TYPE character( 16)
      VALIDATION "SSI_edit_style=mixed~SSI_set=;*;X;+;.;O;@;(*);(.);(+);(x);(O);[];[*];[.];[x];<>;<*>;<.>;<+>;/\\;/*\\;/.\\;|>;|*>;|.>;<|;<*|;<.|;\\/;\\*/;\\./;#;++;/ \\;/_\\;/__\\;/_^_\\;|;/;\\;Y;Z~SSI_length=16"
    FIELD marker_size
      TYPE real(  4,  2)
      VALIDATION "SSI_edit_style=r8~SSI_bounds=0.01 9~SSI_decimals=2~SSI_length=4"
    INDEX styles_idx_field_name  duplicates
      ASC field_name
    INDEX styles_idx_table_name  duplicates
      ASC table_name
  TABLE survey
    DB_SPECIFIC "include_fields=hole_id,depth,dip,azimuth,y,x,z"
    FIELD hole_id
      TYPE character( 12)
      VALIDATION "SSI_edit_style=upper~SSI_length=12"
    FIELD depth
      TYPE real( 11,  3)
      VALIDATION "SSI_edit_style=r8~SSI_bounds=0.000000 9999.000000~SSI_decimals=2~SSI_length=7"
    FIELD dip
      TYPE real( 11,  3)
      VALIDATION "SSI_edit_style=r8~SSI_bounds=-90.000000 90.000000~SSI_decimals=2~SSI_length=6"
    FIELD azimuth
      TYPE real( 11,  3)
      VALIDATION "SSI_edit_style=r8~SSI_bounds=0.000000 360.000000~SSI_decimals=2~SSI_length=6"
    FIELD y
      TYPE real( 11,  3)
      CALCULATED y(hole_id,depth)
    FIELD x
      TYPE real( 11,  3)
      CALCULATED x(hole_id,depth)
    FIELD z
      TYPE real( 11,  3)
      CALCULATED z(hole_id,depth)
    INDEX survey   UNIQUE
      ASC hole_id
      ASC depth
  TABLE translation
    DB_SPECIFIC "include_fields=table_name,field_name,code,num_equiv,description"
    FIELD table_name
      TYPE character( 18)
      VALIDATION "SSI_edit_style=mixed~SSI_length=18"
    FIELD field_name
      TYPE character( 18)
      VALIDATION "SSI_edit_style=mixed~SSI_length=18"
    FIELD code
      TYPE character(  6)
      VALIDATION "SSI_edit_style=mixed~SSI_length=6"
    FIELD num_equiv
      TYPE real( 11,  3)
      VALIDATION "SSI_edit_style=r8~SSI_bounds=0.000000 0.000000~SSI_decimals=2~SSI_length=8"
    FIELD description
      TYPE character( 32)
      VALIDATION "SSI_edit_style=mixed~SSI_length=32"
      NULLS
    INDEX PrimaryKey   UNIQUE
      ASC table_name
      ASC field_name
      ASC code
  TABLE weathering
    DB_SPECIFIC "include_fields=hole_id,depth_to,weathering,y_to,x_to,z_to"
    FIELD hole_id
      TYPE character( 12)
      VALIDATION "SSI_edit_style=upper~SSI_length=12"
    FIELD depth_to
      TYPE real( 11,  3)
      VALIDATION "SSI_edit_style=r8~SSI_bounds=0.000000 9999.000000~SSI_decimals=2~SSI_length=7"
    FIELD weathering
      TYPE character(  6)
      VALIDATION "SSI_edit_style=mixed~SSI_decimals=3~SSI_length=6"
      NULLS
    FIELD y_to
      TYPE real( 11,  3)
      CALCULATED y(hole_id,depth_to)
    FIELD x_to
      TYPE real( 11,  3)
      CALCULATED x(hole_id,depth_to)
    FIELD z_to
      TYPE real( 11,  3)
      CALCULATED z(hole_id,depth_to)
    INDEX weatheri   UNIQUE
      ASC hole_id
      ASC depth_to
