AT GENERATORS

CREATE TABLE at_generators (
  id               dintkey,
  generatorname    dtablename NOT NULL,
  editiondate      deditiondate,
  editorkey        dintkey
);
 
COMMIT;
 
ALTER TABLE at_generators ADD CONSTRAINT at_pk_generators
  PRIMARY KEY(id);
 
ALTER TABLE AT_GENERATORS ADD CONSTRAINT AT_FK_GENERATORS_EDITORKEY
  FOREIGN KEY (EDITORKEY) REFERENCES GD_PEOPLE (CONTACTKEY) ON UPDATE CASCADE;
 
CREATE UNIQUE INDEX at_x_generators_en
  ON at_generators (generatorname);