Hide Zen home . ... sncat2sntab.pl - convert old catalog to table sn . ... CREATE TABLE cats ( id integer PRIMARY KEY, name text ); -- a list of properties of galaxy CREATE TABLE properties ( id integer PRIMARY KEY, name text ); CREATE TABLE galaxy ( id integer PRIMARY KEY, name text ); CREATE TABLE galaxy _property ( gid integer REFERENCES galaxy (id), pid integer REFERENCES properties(id), value float, UNIQUE( gid ,pid) ); CREATE t=# select * from galaxy; id | ...