To Define a Non-Graphical Sub-Feature
-
Create the table with no geometry column, one ID, and one foreign key.
CREATE TABLE NO_GRAPHIC (ID NUMBER PRIMARY KEY, LinkedID NUMBER, Name VARCHAR2(50));
-
Create the foreign key constraint defining the non-graphical sub-feature.
ALTER TABLE NO_GRAPHIC ADD CONSTRAINT NoO_GRAPHIC_CABLEFK FOREIGN KEY(LinkedID) REFERENCES CabCABLE) ON DELETE CASCADE;