This table provides expansions of the surface type codes used in the Surface Depths table. In version 2 a primary key constraint has been added.Table.
| No. | Column name | Data type | Notes |
|---|---|---|---|
| 1 | TYPE | Varchar(1) | Primary key |
| 2 | DESCRIPTION | Varchar(20) |
| TYPE | DESCRIPTION |
|---|---|
| F | FAULTED |
| N | NORMAL, CONFORMABLE |
| T | TERMINAL DEPTH |
| U | UNCONFORMABLE |
| B | BIOSTRAT MARKER |
| S | SPUDDED INTO |
| D | DYKE |
| I | INTRUSION (UNDIFF) |
| L | SILL |
| W | SEA BED |