DROP TABLE Permit;
DROP TABLE Image;
DROP TABLE Vehicle;
DROP TABLE Keeper;
DROP TABLE Camera;

CREATE TABLE Camera(
   id INTEGER PRIMARY KEY
  ,perim VARCHAR(3)
);

CREATE TABLE Keeper(
   id INTEGER PRIMARY KEY
  ,name VARCHAR(20)
  ,address VARCHAR(25)
);

CREATE TABLE Vehicle(
   id VARCHAR(10) PRIMARY KEY
  ,keeper INTEGER
  ,FOREIGN KEY(keeper) REFERENCES Keeper(id)
);

CREATE TABLE Image(
   camera INTEGER
  ,whn DATE
  ,reg VARCHAR(10)
  ,PRIMARY KEY (camera,whn)
  ,FOREIGN KEY (camera) REFERENCES Camera(id)
  ,FOREIGN KEY (reg) REFERENCES Vehicle(id)
);

CREATE TABLE Permit(
   reg VARCHAR(10)
  ,sDate DATE
  ,lDate DATE
  ,chargeType VARCHAR(10)
  ,PRIMARY KEY (reg,sDate)
  ,FOREIGN KEY (reg) REFERENCES Vehicle(id)
);

GRANT SELECT ON Camera TO PUBLIC;
GRANT SELECT ON Keeper TO PUBLIC;
GRANT SELECT ON Vehicle TO PUBLIC;
GRANT SELECT ON Image TO PUBLIC;
GRANT SELECT ON Permit TO PUBLIC;

CREATE OR REPLACE PUBLIC SYNONYM Camera FOR u0251.Camera;
CREATE OR REPLACE PUBLIC SYNONYM Keeper FOR u0251.Keeper;
CREATE OR REPLACE PUBLIC SYNONYM Vehicle FOR u0251.Vehicle;
CREATE OR REPLACE PUBLIC SYNONYM Image FOR u0251.Image;
CREATE OR REPLACE PUBLIC SYNONYM Permit FOR u0251.Permit;