tbl_photolinksdata

1924 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
photoid serial 10 √ nextval('"tbl_PhotoLinksData_photoID_seq"'::regclass)
tbl_ingestion_attachments.canonical_photo_id fk_ingestion_attachment_canonical_photo R
megastructureid int4 10 √ null
tbl_megastructuredata.megastructureid fk_photolinks_megastructure N
macrostructureid int4 10 √ null
tbl_macrostructuredata.macrostructureid fk_photolinks_macrostructure N
mesostructureid int4 10 √ null
tbl_mesostructuredata.mesostructureid fk_photolinks_mesostructure N
microstructureid int4 10 √ null
tbl_microstructuredata.microstructureid fk_photolinks_microstructure N
megareferenceimage bool 1 √ false
macroreferenceimage bool 1 √ false
mesoreferenceimage bool 1 √ false
microreferenceimage bool 1 √ false
sampleid varchar 255 √ null
outcropphoto bool 1 √ false
photomicrograph bool 1 √ false
otherimage bool 1 √ false
thicksection bool 1 √ false
slabimage bool 1 √ false
climage bool 1 √ false
otherdocument bool 1 √ false
photolinkrelative2 varchar 255 √ null
stratsection bool 1 √ false
scale varchar 100 √ null
gigapanimage bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_PhotoLinksData_pkey Primary key Asc photoid

Relationships

Close relationships within degrees of separation