postgresql> CREATE TABLE "indicators" ( id SERIAL UNIQUE, name VARCHAR(20) NOT NULL, param1 VARCHAR(10), param2 VARCHAR(10), param3 VARCHAR(10), param4 VARCHAR(10), param5 VARCHAR(10), description VARCHAR(30), PRIMARY KEY (id) ); postgresql> INSERT INTO indicators VALUES (7, 'PPO', 9, 4, 2, NULL, NULL, 'PPO'); postgresql> CREATE TABLE "ppo_data" ( id_attached INTEGER, date DATE NOT NULL, data1 NUMERIC(10, 5) NOT NULL, data2 NUMERIC(10, 5), PRIMARY KEY (id_attached, date) ); postgresql> INSERT INTO ppo_data VALUES (7, '20061120', 23, 34);