1 CREATE TABLE available_planet_tags (
5 CREATE TABLE planet_tags (
6 pid INTEGER NOT NULL REFERENCES planets (pid)
7 ,tag CITEXT NOT NULL REFERENCES available_planet_tags (tag)
8 ,uid INTEGER REFERENCES users (uid)
9 ,time TIMESTAMPTZ NOT NULL DEFAULT NOW()
10 ,PRIMARY KEY (pid,uid,tag)