AT NAMESPACE FILE LINK

CREATE GLOBAL TEMPORARY TABLE at_namespace_file_link (
  filename      dtext255 NOT NULL,
  uses_xid      dintkey,
  uses_dbid     dintkey,
  uses_name     dtext255 NOT NULL,
 
  CONSTRAINT at_pk_namespace_file_link
    PRIMARY KEY (filename, uses_xid, uses_dbid),
  CONSTRAINT at_fk_namespace_file_link_fn
    FOREIGN KEY (filename) REFERENCES at_namespace_file (filename)
      ON UPDATE CASCADE
      ON DELETE CASCADE
)
  ON COMMIT DELETE ROWS;