Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
encounterid |
int4 |
10 |
√ |
|
null |
|
|
toppid |
varchar |
20 |
√ |
|
null |
|
|
speciescode |
varchar |
2 |
√ |
|
null |
|
|
animalid |
varchar |
40 |
√ |
|
null |
|
|
gender |
varchar |
20 |
√ |
|
null |
|
|
identifyingfeatures |
varchar |
255 |
√ |
|
null |
|
|
nickname |
varchar |
40 |
√ |
|
null |
|
|
red |
int4 |
10 |
√ |
|
null |
|
|
green |
int4 |
10 |
√ |
|
null |
|
|
blue |
int4 |
10 |
√ |
|
null |
|
|
speciesname |
varchar |
80 |
√ |
|
null |
|
|
genus |
varchar |
80 |
√ |
|
null |
|
|
species |
varchar |
80 |
√ |
|
null |
|
|
taxongroup |
varchar |
80 |
√ |
|
null |
|
|
workinggroup |
varchar |
80 |
√ |
|
null |
|
|
abreviation |
varchar |
20 |
√ |
|
null |
|
|
concatname |
text |
2147483647 |
√ |
|
null |
|
|
projectid |
int4 |
10 |
√ |
|
null |
|
|
name |
varchar |
80 |
√ |
|
null |
|
|
casecomment |
text |
2147483647 |
√ |
|
null |
|
|
ownerid |
int4 |
10 |
√ |
|
null |
|
|
contactid |
int4 |
10 |
√ |
|
null |
|
|
provisional |
bool |
1 |
√ |
|
null |
|
|
tripid |
int4 |
10 |
√ |
|
null |
|
|
conditionsid |
int4 |
10 |
√ |
|
null |
|
|
locationid |
int4 |
10 |
√ |
|
null |
|
|
encountertypeid |
int4 |
10 |
√ |
|
null |
|
|
agentid |
int4 |
10 |
√ |
|
null |
|
|
datetime |
timestamptz |
35,6 |
√ |
|
null |
|
|
encountercomment |
text |
2147483647 |
√ |
|
null |
|
|
handlingtime |
time |
15,6 |
√ |
|
null |
|
|
masskg |
float4 |
8,8 |
√ |
|
null |
|
|
masstypeid |
int4 |
10 |
√ |
|
null |
|
|
lengthcm |
float4 |
8,8 |
√ |
|
null |
|
|
lengthtypeid |
int4 |
10 |
√ |
|
null |
|
|
annimalcondition |
text |
2147483647 |
√ |
|
null |
|
|
injuries |
varchar |
255 |
√ |
|
null |
|
|
distinguishingfeaturess |
varchar |
255 |
√ |
|
null |
|
|
dnasampled |
bool |
1 |
√ |
|
null |
|
|
transfercaptainid |
int4 |
10 |
√ |
|
null |
|
|
transfervesselid |
int4 |
10 |
√ |
|
null |
|
|
caudallength |
float4 |
8,8 |
√ |
|
null |
|
|
precaudallength |
float4 |
8,8 |
√ |
|
null |
|
|
curvedforklength |
float4 |
8,8 |
√ |
|
null |
|
|
halfgirthcm |
float4 |
8,8 |
√ |
|
null |
|
|
easeuptoboat |
varchar |
40 |
√ |
|
null |
|
|
bait |
varchar |
40 |
√ |
|
null |
|
|
numberofhooks |
float4 |
8,8 |
√ |
|
null |
|
|
fishingdepth |
float4 |
8,8 |
√ |
|
null |
|
|
linetest |
varchar |
40 |
√ |
|
null |
|
|
leadertest |
varchar |
40 |
√ |
|
null |
|
|
soakfighttime |
time |
15,6 |
√ |
|
null |
|
|
pullstarttime |
time |
15,6 |
√ |
|
null |
|
|
setstarttime |
time |
15,6 |
√ |
|
null |
|
|
surgerytime |
time |
15,6 |
√ |
|
null |
|
|
surgerycomment |
text |
2147483647 |
√ |
|
null |
|
|
surgeryboatid |
int4 |
10 |
√ |
|
null |
|
|
hooktype |
varchar |
40 |
√ |
|
null |
|
|
departcoast |
date |
13 |
√ |
|
null |
|
|
buttonsuture1 |
varchar |
80 |
√ |
|
null |
|
|
buttonsuture2 |
varchar |
80 |
√ |
|
null |
|
|
closingsuture |
varchar |
80 |
√ |
|
null |
|
|
Analyzed at Wed Dec 27 13:25 PST 2017
|