-- Generated by Ora2Pg, the Oracle database Schema converter, version 4.1
-- Copyright 2000-2004 Gilles DAROLD. All rights reserved.
--
-- This program is free software; you can redistribute it and/or modify it under
-- the same terms as Perl itself.

BEGIN TRANSACTION;

CREATE TABLE "tst_vermieter" (
	"vrm_id" bigint NOT NULL,
	"vrm_name" varchar(100)
);
ALTER TABLE "tst_vermieter" ADD PRIMARY KEY ("vrm_id");
CREATE UNIQUE INDEX tst_vrm_pk ON "tst_vermieter" ("vrm_id");

CREATE TABLE "tst_fahrzeuge" (
	"fhz_id" bigint NOT NULL,
	"fhz_name" varchar(100),
	"fhz_vrm_id" bigint
);
ALTER TABLE "tst_fahrzeuge" ADD PRIMARY KEY ("fhz_id");

CREATE TABLE "tst_extras" (
	"ext_id" bigint NOT NULL,
	"ext_name" varchar(100)
);
ALTER TABLE "tst_extras" ADD PRIMARY KEY ("ext_id");

CREATE TABLE "tst_fhz_ext_int" (
	"fei_id" bigint NOT NULL,
	"fei_fhz_id" bigint,
	"fei_ext_id" bigint
);
ALTER TABLE "tst_fhz_ext_int" ADD PRIMARY KEY ("fei_id");
CREATE UNIQUE INDEX tst_fhz_id_ext_id_uk ON "tst_fhz_ext_int" ("fei_ext_id","fei_fhz_id");

ALTER TABLE "tst_fahrzeuge" ADD CONSTRAINT "tst_fhz_vrm_id_fk" FOREIGN KEY ("fhz_vrm_id") REFERENCES "tst_vermieter" ("vrm_id") ON DELETE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE "tst_fhz_ext_int" ADD CONSTRAINT "tst_fei_ext_id_fk" FOREIGN KEY ("fei_ext_id") REFERENCES "tst_extras" ("ext_id") ON DELETE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE "tst_fhz_ext_int" ADD CONSTRAINT "tst_fei_fhz_id_fk" FOREIGN KEY ("fei_fhz_id") REFERENCES "tst_fahrzeuge" ("fhz_id") ON DELETE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE;


CREATE SEQUENCE "seq" INCREMENT 1 MINVALUE 1 MAXVALUE 2147483646 START 41 CACHE 20;

END TRANSACTION;