infosites

esq_test=> \d+ infosite Table "public.infosite" Column | Type | Modifiers | Storage | Stats target | Description -----------------+-----------------------------+-------------------------------------------------------+---------+--------------+------------- id | integer | not null default nextval('infosite_id_seq'::regclass) | plain | | doc | date | | plain | | periodStart | date | | plain | | periodEnd | date | | plain | | A1 | real | not null | plain | | A2 | real | not null | plain | | B1 | real | not null | plain | | C1 | real | not null | plain | | C2 | real | not null | plain | | C3 | real | not null | plain | | D1 | real | not null | plain | | E1 | real | not null | plain | | E2 | real | not null | plain | | E3 | real | not null | plain | | F1 | real | not null | plain | | F2 | real | not null | plain | | G1 | real | not null | plain | | G2 | real | not null | plain | | G3 | real | not null | plain | | G4 | real | not null | plain | | G5 | real | not null | plain | | G6 | real | not null | plain | | H1 | real | not null | plain | | H2 | real | not null | plain | | I1 | real | not null | plain | | I2 | real | not null | plain | | J1 | real | not null | plain | | K1 | real | not null | plain | | K2 | real | not null | plain | | usdPrice | real | not null | plain | | eurPrice | real | not null | plain | | valid | boolean | | plain | | jpyPrice | real | not null | plain | | currencyId | integer | | plain | | languageId | integer | | plain | | plantId | integer | | plain | | updatedDate | timestamp without time zone | not null default now() | plain | | lastUpdatedById | integer | | plain | | Indexes: "infosite_pkey" PRIMARY KEY, btree (id) "valid-idx" btree (valid) Foreign-key constraints: "fk_22d7aa9bc489a01eb14ff852cb8" FOREIGN KEY ("languageId") REFERENCES language(id) "fk_4da6817abecd9e4cac3f262e6bb" FOREIGN KEY ("lastUpdatedById") REFERENCES "user"(id) "fk_5e9f8c027f358109908e8b1d168" FOREIGN KEY ("currencyId") REFERENCES currency(id) "fk_8ba59ca6d3b1b7562a695d85dae" FOREIGN KEY ("plantId") REFERENCES plant(id) Referenced by: TABLE "is_comment" CONSTRAINT "fk_66fc8248fe7b89c82719828013b" FOREIGN KEY ("infositeId") REFERENCES infosite(id) TABLE "labor" CONSTRAINT "fk_8791f10f9b651884cc4c60e8b7d" FOREIGN KEY ("infositeId") REFERENCES infosite(id) TABLE "staff" CONSTRAINT "fk_f83bfc6576b086f1758d8e55ab4" FOREIGN KEY ("infositeId") REFERENCES infosite(id) esq_test=>