oc_memories


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('oc_memories_id_seq'::regclass)
datetaken timestamp 22 NULL::timestamp without time zone
fileid int8 19 null
dayid int4 10 null
isvideo bool 1 false
mtime int8 19 null
w int4 10 0
h int4 10 0
objectid varchar 64 '0'::character varying
exif text 2147483647 ''::text
video_duration int4 10 0
liveid varchar 128 ''::character varying
orphan bool 1 false
lat numeric 8,6 NULL::numeric
lon numeric 9,6 NULL::numeric
mapcluster int4 10 null
epoch int8 19 0
buid varchar 32 ''::character varying
parent int8 19 0

Indexes

Constraint Name Type Sort Column(s)
oc_memories_pkey Primary key Asc id
memories_dayid_index Performance Asc dayid
memories_fileid_index Must be unique Asc fileid
memories_isvideo_idx Performance Asc isvideo
memories_lat_lon_index Performance Asc/Asc lat + lon
memories_mapcluster_index Performance Asc mapcluster
memories_objectid_index Performance Asc objectid
memories_pdf_idx Performance Asc/Asc/Asc parent + dayid + fileid

Relationships