siteimages

9 rows


Description

This table stores hyperlinks to jpeg images of sites.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
siteimageid serial 10 nextval('ndb.seq_siteimages_siteimageid'::regclass)
siteid int4 10 null
sites.siteid fk_siteimages_sitesC
contactid int4 10 null
contacts.contactid fk_siteimages_contactsR
caption text 2147483647 null
credit varchar 255 null
date date 13 null
siteimage text 2147483647 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

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

Relationships