create-join.sql

create table sa_upper (
 id_sup       integer               primary key,
 sup_season   smallint              ,
 sup_sa_code  character varying(10) ,
 sup_mat_code character varying(4)  ,
 sup_clr_code character varying(3));

create table sa_lining (
 id_sli       integer               primary key,
 sli_season   smallint              ,
 sli_sa_code  character varying(10) ,
 sli_mat_code character varying(4)  ,
 sli_clr_code character varying(3));

create table sa_insole (
 id_sin       integer               primary key,
 sin_season   smallint              ,
 sin_sa_code  character varying(10) ,
 sin_mat_code character varying(4)  ,
 sin_clr_code character varying(3));

create table public.sa_outsole (
 id_sou       integer               primary key,
 sou_season   smallint              ,
 sou_sa_code  character varying(10) ,
 sou_mat_code character varying(4)  ,
 sou_clr_code character varying(3));
 
create table upper_target (
 id_up       smallint,
 nup         integer ,
 up_mat_code text);

create table lining_target (
 id_li       smallint,
 nup         integer ,
 li_mat_code text);

create table outsole_target (
 id_ou       smallint,
 nup         integer ,
 ou_mat_code text);

create table insole_target (
 id_in       smallint,
 nup         integer ,
 in_mat_code text);