CREATE TABLE identifier_list
(
  id integer NOT NULL DEFAULT nextval('seq_identifier_list'::regclass),
  comment character varying(255),
  CONSTRAINT identifier_list_pkey PRIMARY KEY (id)
)

CREATE TABLE name_list
(
  id integer NOT NULL DEFAULT nextval('seq_name_list'::regclass),
  name character varying(255) NOT NULL,
  CONSTRAINT name_list_pkey PRIMARY KEY (id)
)

CREATE TABLE identifier_list_x_name_list
(
  identifier_list_id integer NOT NULL,
  name_list_id integer NOT NULL,
  CONSTRAINT identifier_list_x_name_list_pkey PRIMARY KEY (identifier_list_id, name_list_id),
  CONSTRAINT identifier_list_x_name_list_identifier_list_id_fkey FOREIGN KEY (identifier_list_id)
      REFERENCES identifier_list (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE,
  CONSTRAINT identifier_list_x_name_list_name_list_id_fkey FOREIGN KEY (name_list_id)
      REFERENCES name_list (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE NO ACTION
)