... | ... | @@ -37,7 +37,7 @@ This section also includes an example for each table, showing how data might be |
|
|
| tripid | int | 23 |
|
|
|
| siteid | int | 24 |
|
|
|
| sitename | char(128) | "Pingvellir" |
|
|
|
| sitenotes | text | "Notes about site" |
|
|
|
| sitenotes | text | "Notes about site - DROP" |
|
|
|
|
|
|
### *fieldday_sector*
|
|
|
***example:*** `SELECT * FROM fieldday_sector WHERE tripid=23 AND siteid=2;`
|
... | ... | @@ -48,7 +48,7 @@ This section also includes an example for each table, showing how data might be |
|
|
| siteid | int | 24 |
|
|
|
| sectorid | int | 231 |
|
|
|
| sectorname | char(128) | "Pingvellir" |
|
|
|
| sectornotes | text | "Notes about sector" |
|
|
|
| sectornotes | text | "Notes about sector - DROP" |
|
|
|
|
|
|
### *fieldday_spot*
|
|
|
***example:*** `SELECT * FROM fieldday_spot WHERE tripid=23 AND siteid=2 AND sectorid=1;`
|
... | ... | @@ -60,7 +60,7 @@ This section also includes an example for each table, showing how data might be |
|
|
| sectorid | int | 231 |
|
|
|
| spotid | int | 3 |
|
|
|
| spotiamgefolder | char(128) | dir_name |
|
|
|
| spotnotes | text | "Notes about sector" |
|
|
|
| spotnotes | text | "Notes about spot - KEEP" |
|
|
|
|
|
|
### *fieldday_streaming*
|
|
|
| column | type | example |
|
... | ... | |