Could you add
Colour int
to Division please
|
|2.2.1.77|create table DocumentType(DocumentTypeID char(20) primary key, "Description" char(50), "Class" char(1));
alter table OLEDocument add DocumentTypeID char(20);
ALTER TABLE "pears"."oledocument" ADD FOREIGN KEY "DocumentType" ( "DocumentTypeID" ) REFERENCES "pears"."DocumentType" ( "DocumentTypeID" ) ON DELETE SET NULL;
|