CREATE TABLE pupil
(
  pupil_id integer NOT NULL,
  nom_econom_book integer,
  address character varying,
  par_f_name character varying,
  par_s_name character varying,
  par_l_name character varying,
  par_fio character varying,
  pupil_f_name character varying,
  pupil_s_name character varying,
  pupil_l_name character varying,
  pupil_fio character varying,
  birth date,
  data_non_stud character varying,
  pupil_status character varying,
  CONSTRAINT pupil_pkey PRIMARY KEY (pupil_id)
)

insert into pupil (pupil_id, nom_econom_book, address, par_f_name, par_s_name, par_l_name, par_fio, pupil_f_name, pupil_s_name, pupil_l_name, pupil_fio,birth,data_non_stud,pupil_status)
values( 21 ,null,'GreenStreet','Иванов','Иван','Иванович','Иванов Иван Иванович','Иванов','Петр','Иванович','Иванов Петр Иванович','1995-01-01',null,null)

CREATE TABLE pupil_ages
(
  pupil_id integer NOT NULL,
  pupil_age integer NOT NULL,
  numb_class integer,
  class_letter character varying( 1 ),
  teacher_id integer NOT NULL,
  CONSTRAINT pupil_ages_pupil_age_fkey FOREIGN KEY (pupil_age)
      REFERENCES ages (age) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT pupil_ages_pupil_id_fkey FOREIGN KEY (pupil_id)
      REFERENCES pupil (pupil_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT pupil_ages_teacher_id_fkey FOREIGN KEY (teacher_id)
      REFERENCES teacher (teacher_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)