9 rows


This table stores hyperlinks to jpeg images of sites.


Column Type Size Nulls Auto Default Children Parents Comments
siteimageid serial 10 nextval('ndb.seq_siteimages_siteimageid'::regclass)

An arbitrary Site Image identification number.

siteid int4 10 null
sites.siteid fk_siteimages_sitesC

Site identification number. Field links to the Sites table.

contactid int4 10 null
contacts.contactid fk_siteimages_contactsR

Contact identification number for image attribution.

caption text 2147483647 null

Caption for the image.

credit varchar 255 null

Credit for the image. If null, the credit is formed from the ContactID.

date date 13 null

Date of photograph or image.

siteimage text 2147483647 null

Hyperlink to a URL for the image.

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null


Constraint Name Type Sort Column(s)
siteimages_pkey Primary key Asc siteimageid
ix_siteid_siteimages Performance Asc siteid