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