status=# \d data
                                  Table "public.data"
   Column   |            Type             |                 Modifiers
------------+-----------------------------+--------------------------------------------
 id         | integer                     | not null default nextval('data_seq'::text)
 updated    | timestamp without time zone |
 entered    | timestamp without time zone |
 machine_id | integer                     |
 datas      | character varying(512)[]    |
Indexes:
    "data_pkey" primary key, btree (id)
    "idx_d_entered" btree (entered)
    "idx_d_machine_id" btree (machine_id)
Foreign-key constraints:
    "machine_id" FOREIGN KEY (machine_id) REFERENCES machines(id)
Triggers:
    data_datestamp BEFORE INSERT OR UPDATE ON data FOR EACH ROW EXECUTE PROCEDURE datestamp_e()

status=# \d data_values
              Table "public.data_values"
   Column    |            Type             | Modifiers
-------------+-----------------------------+-----------
 updated     | timestamp without time zone |
 entered     | timestamp without time zone |
 data_id     | integer                     |
 template_id | integer                     |
 value       | character varying(512)      |
Indexes:
    "idx_data_values_data_id" btree (data_id)
    "idx_dv_template_id" btree (template_id)
Foreign-key constraints:
    "data_id" FOREIGN KEY (data_id) REFERENCES data(id)
    "template_id" FOREIGN KEY (template_id) REFERENCES datatemplate_intervals(id)
Triggers:
    data_values_datestamp BEFORE INSERT OR UPDATE ON data_values FOR EACH ROW EXECUTE PROCEDURE 
datestamp_e()

status=# \d datatemplate_intervals
                                  Table "public.datatemplate_intervals"
   Column    |            Type             |                          Modifiers 
-------------+-----------------------------+--------------------------------------------------------------
 id          | integer                     | not null default 
nextval('datatemplate_intervals_seq'::text)
 updated     | timestamp without time zone |
 entered     | timestamp without time zone |
 machine_id  | integer                     |
 template_id | integer                     |
 interval    | integer                     |
Indexes:
    "datatemplate_intervals_pkey" primary key, btree (id)
    "idx_di_machine_id" btree (machine_id)
    "idx_di_template_id" btree (template_id)
Foreign-key constraints:
    "machine_id" FOREIGN KEY (machine_id) REFERENCES machines(id)
    "template_id" FOREIGN KEY (template_id) REFERENCES datatemplates(id)
Triggers:
    datatemplate_intervals_datestamp BEFORE INSERT OR UPDATE ON datatemplate_intervals FOR EACH 
ROW EXECUTE PROCEDURE datestamp_e()