--
-- f_attributedependencies
--
DROP TABLE IF EXISTS f_attributedependencies;

create table f_attributedependencies (
    pktablename     varchar(64) not null,
    pkcolumnnames   varchar(1056),
    fktablename     varchar(64) not null,
    fkcolumnnames   varchar(1056),
    fkcardinality   integer not null,
    identitycolumn  varchar(64),
    ordertype       char(1)
);

COMMENT ON TABLE f_attributedependencies IS 'Definition of attribute dependencies.';

-- Add dependency for navigating from a feature to its class and schema name

insert into f_attributedependencies
( pktablename, pkcolumnnames, fktablename, fkcolumnnames, fkcardinality )
values
( 'F_FEATURE', 'CLASSID', 'F_CLASSDEFINITION', 'CLASSID', 1 );

