CREATE TABLE container.ac_moving
(
  id serial NOT NULL,
  container_id integer NOT NULL,
  otpravka_id integer NOT NULL,
  vozvrat_id integer,
  CONSTRAINT moving_pkey PRIMARY KEY (id),
  CONSTRAINT container1 FOREIGN KEY (container_id)
      REFERENCES container.ac_container (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT shape2 FOREIGN KEY (otpravka_id)
      REFERENCES container.ac_shape (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE RESTRICT,
  CONSTRAINT shape3 FOREIGN KEY (vozvrat_id)
      REFERENCES container.ac_shape (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE RESTRICT
)

CREATE TABLE container.ac_shape
(
  id serial NOT NULL,
  shape_num character varying(50) NOT NULL,
  shape_type character(3) NOT NULL,
  d date NOT NULL,
  transport_id integer NOT NULL, -- 1-жд 2-автотранспорт
  num_transp character varying(50),
  num_naclad character varying(50),
  num_part character varying(50),
  contragent_id integer NOT NULL,
  status character(1) DEFAULT 'Y'::bpchar,
  buyer_id integer,
  CONSTRAINT shape_pkey PRIMARY KEY (id),
  CONSTRAINT contragent3 FOREIGN KEY (contragent_id)
      REFERENCES container.ac_contragent (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE RESTRICT,
  CONSTRAINT shape_type CHECK (shape_type = ANY (ARRAY['otv'::bpchar, 'voz'::bpchar])),
  CONSTRAINT transport CHECK (transport_id = ANY (ARRAY[1, 2]))
)