CREATE TABLE persons () INHERITS (contragents);

CREATE TABLE public.contragents
(
  id integer NOT NULL DEFAULT nextval('contragents_id_seq'::regclass),
  title_name character varying(100) NOT NULL,
  CONSTRAINT contragents_id_pk PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE public.contragents
  OWNER TO postgres;

CREATE TABLE public.organiations
(
-- Унаследована from table contragents:  id integer NOT NULL DEFAULT nextval('contragents_id_seq'::regclass),
-- Унаследована from table contragents:  title_name character varying(100) NOT NULL,
  activity_type_id integer NOT NULL DEFAULT 0,
  CONSTRAINT organizations_id_pk PRIMARY KEY (id)
)
INHERITS (public.contragents)
WITH (
  OIDS=FALSE
);
ALTER TABLE public.organiations
  OWNER TO postgres;

CREATE TABLE public.persons
(
-- Унаследована from table contragents:  id integer NOT NULL DEFAULT nextval('contragents_id_seq'::regclass),
-- Унаследована from table contragents:  title_name character varying(100) NOT NULL,
  sex boolean NOT NULL DEFAULT true,
  CONSTRAINT persons_id_pk PRIMARY KEY (id)
)
INHERITS (public.contragents)
WITH (
  OIDS=FALSE
);
ALTER TABLE public.persons
  OWNER TO postgres;

CREATE TABLE public.buildings
(
  id integer NOT NULL DEFAULT nextval('buildings_id_seq'::regclass),
  owner_id integer NOT NULL DEFAULT 0,
  CONSTRAINT buildings_id_pk PRIMARY KEY (id),
  CONSTRAINT owner_id_fk FOREIGN KEY (owner_id)
      REFERENCES public.contragents (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE public.buildings
  OWNER TO postgres;