A Paste by Anonymous

1

CREATE TABLE CA (name char(50) not null,              code char(20),          rulestr char(50),          description text,          primary key(name)); CREATE TABLE WE1REP (representation char(50) not null,              primary key(representation)); CREATE TABLE WE1REPRESENTED (name char(50) not null,                  representation char(50) not null,                  primary key(name, representation),                  foreign key(name) references CA,                  foreign key(representation) references WE1REP);