Posted By: Roumen () on 'CZprogram' Title: Re: Implementace extends Date: Fri Jan 28 15:34:38 2005 > class vehicle{ > int id, > date reservedStart, > date reservedEnd, > } > > class car extends vehicle{ > CarType type, > String spz > } > > class bicycle extends vehicle{ > BicycleType type, > Color color > } > > jak tohle do relacni db? nebo mam pouzit misto vehicle nejaky rozhrani a > casy rezervace si vytahovat za pomoci tohodle rozhrani? Ja nevim...co tohle? CREATE TABLE VEHICLE ( ID NUMBER(6), RESERVED_START NUMBER(6), RESERVED_END NUMBER(8) ); CREATE TABLE CAR_TYPES ( ID NUMBER(6), TYPE VARCHAR2(60) ); CREATE TABLE CAR ( ID NUMBER(6), VEHICLE NUMBER(6), CAR_TYPE NUMBER(6) SPZ VARCHAR2(10) ); CREATE TABLE BICYCLE_TYPES ( ID NUMBER(6), TYPE VARCHAR2(60) ); CREATE TABLE BICYCLE ( ID NUMBER(6), VEHICLE NUMBER(6), BICYCLE_TYPE NUMBER(6) COLOR VARCHAR2(10) ); Plus muzes: ALTER TABLE CAR ADD ( CONSTRAINT FK$CAR$VEHICLE FOREIGN KEY (VEHICLE) REFERENCES VEHICLES (ID)); Atd pro ostatni... Pochopil sem vubec zadani? ;-) Roumen For more information about me use:http://www.roumen.cz