CREATE TABLE "relativesType" (
  id int4 NOT NULL DEFAULT nextval('"relativesType_id_seq"'::regclass),
  "relativeName" char( 30 ) NOT NULL,
  CONSTRAINT pk_relative PRIMARY KEY (id)
) 

CREATE TABLE members (
  id int4 NOT NULL DEFAULT nextval('members_id_seq'::regclass),
  account_id int4 NOT NULL,
  "memberNo" int2 NOT NULL,
  family char( 20 ) NOT NULL,
  name char( 20 ) NOT NULL,
  "fatherName" char( 20 ) NOT NULL,
  birthday date NOT NULL,
  sex bool NOT NULL,
  "relative" int4 NOT NULL,
  inn int8,
  "pensionPolicy" int8,
  address char( 11 ) NOT NULL,
  "birthDocNo" int4,
  "birthDocDate" date,
  nationality int4,
  education int4,
  "educationType" int4,
  "regDate" date NOT NULL,
  "prevAddress" char( 11 ),
  CONSTRAINT pk_members PRIMARY KEY (id),
  CONSTRAINT fk_account_id FOREIGN KEY (account_id)
      REFERENCES accounts (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE,
  CONSTRAINT "fk_relativeType" FOREIGN KEY ("relative")
      REFERENCES "relativesType" (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE SET NULL
)

select * from relativesType

select * from relativesType

select * from "relativesType"