CREATE TABLE Cards
(id integer identity(1,1) primary key,
name varchar(30),
indeks varchar(20) unique );

insert into Cards values ('SUROWIEC','OryginalnyIndex1')
insert into Cards values ('BUTELKA','OryginalnyIndex2')
insert into Cards values ('KAPSLE','OryginalnyIndex3')
insert into Cards values ('ETYKIETA','OryginalnyIndex4')
insert into Cards values ('MATERIAŁY_MARKETINGOWE','OryginalnyIndex5')
insert into Cards values ('KARTON','OryginalnyIndex6')
insert into Cards values ('PALETA','OryginalnyIndex7')
insert into Cards values ('ETYKIETA','OryginalnyIndex8')
insert into Cards values ('DODATKOWE_ELEMENTY','OryginalnyIndex9')
insert into Cards values ('WYROB_GOTOWY','OryginalnyIndex10')
insert into Cards values ('PLYN','OryginalnyIndex11')
insert into Cards values ('BARWNIK','OryginalnyIndex12')
insert into Cards values ('KRATKA','OryginalnyIndex13')
insert into Cards values ('WYROB_KONFEKCJONOWANY','OryginalnyIndex14')
insert into Cards values ('INNY_RODZAJ_ZAMKNIECIA','OryginalnyIndex15')

CREATE TABLE Specifications
(id integer identity(1,1) primary key,
name varchar(30),
id_card integer,
type varchar(10) );

alter table Specifications
add constraint id_card_fk1 foreign key (id_card) references Cards(id)

insert into Specifications values('GESTOSC',1,'LICZBA')
insert into Specifications values('ALERGRNY1',1,'TEKST')
insert into Specifications values('ALERGENY2',1,'TEKST')
insert into Specifications values('ALERGENY3',1,'TEKST')
insert into Specifications values('ETYKIETOWANIE',1,'LICZBA')
insert into Specifications values('GMO',1,'YESNO')
insert into Specifications values('WYMIARY',2,'TEKST')
insert into Specifications values('WAGA',2,'TEKST')
insert into Specifications values('RYSUNEK',2,'TEKST')
insert into Specifications values('KOD_KRESKOWY',2,'LICZBA')
insert into Specifications values('WYMIARY',3,'TEKST')
insert into Specifications values('WAGA',3,'LICZBA')
insert into Specifications values('INDEKS',3,'TEKST')
insert into Specifications values('WAGA',4,'LICZBA')
insert into Specifications values('INDEKS',4,'TEKST')
insert into Specifications values('RODZAJ_SUROWCA',5,'TEKST')
insert into Specifications values('INDEKS',5,'TEKST')
insert into Specifications values('KOD_KRESKOWY',6,'LICZBA')
insert into Specifications values('RODZAJ_SUROWCA',6,'TEKST')
insert into Specifications values('INDEKS',6,'TEKST')
insert into Specifications values('RODZJA_PALETY',7,'TEKST')
insert into Specifications values('WAGA',7,'LICZBA')
insert into Specifications values('INDEKS',7,'TEKST')
insert into Specifications values('WYMIARY',7,'TEKST')
insert into Specifications values('ZGRZEWKI',10,'LICZBA')
insert into Specifications values('TOLERANCJA',10,'LICZBA')
insert into Specifications values('NAPELNIENIE',10,'TEKST')
insert into Specifications values('OPIS_PROMOCJI',10,'TEKST')
insert into Specifications values('PELNA_NAZWA',10,'TEKST')
insert into Specifications values('GESTOSC',11,'TEKST')
insert into Specifications values('FILTRACJA',11,'TEKST')
insert into Specifications values('WYGLAD',11,'TEKST')
insert into Specifications values('UWAGI',11,'TEKST')
insert into Specifications values('ZBIORNIKI',11,'TEKST')
insert into Specifications values('NAZWA',12,'TEKST')
insert into Specifications values('KOD_E-XXX',12,'TEKST')
insert into Specifications values('NAZWA',13,'TEKST')
insert into Specifications values('WAGA',13,'LICZBA')
insert into Specifications values('INDEKS',13,'TEKST')
insert into Specifications values('OPIS',14,'TEKST')
insert into Specifications values('NAZWA',14,'LICZBA')
insert into Specifications values('MOC',14,'LICZBA')
insert into Specifications values('INDEKS',14,'TEKST')
insert into Specifications values('WAGA',15,'LICZBA')

CREATE TABLE CardsData
(id integer identity(1,1) primary key,
id_card integer,
name varchar(20) );

alter table CardsData
add constraint id_card_fk2 foreign key (id_card) references Cards(id)

CREATE TABLE SpecificationsData
(id integer identity(1,1) primary key,
id_cardData integer,
id_specification integer,
number_value float(10),
text_value varchar(20),
yesno_value bit);

alter table SpecificationsData
add constraint id_cardData_fk1 foreign key (id_cardData) references CardsData(id)
alter table SpecificationsData
add constraint id_specification_fk foreign key (id_specification) references Specifications(id)

CREATE TABLE Structure(
id integer identity(1,1) primary key,
id_cardStructure integer,
id_card integer);

ALTER TABLE Structure
add constraint id_card_fk3 foreign key (id_cardStructure) references Cards(id)
ALTER TABLE Structure
add constraint id_card_fk4 foreign key (id_card) references Cards(id)

CREATE TABLE StructureData(
id integer identity(1,1) primary key,
id_cardDataStructure integer,
id_structure integer,
id_cardData integer);

ALTER TABLE StructureData
add constraint id_cardData_fk2 foreign key (id_cardDataStructure) references CardsData(id)
ALTER TABLE StructureData
add constraint id_cardData_fk3 foreign key (id_cardData) references CardsData(id)
ALTER TABLE StructureData
add constraint id_structure foreign key (id_structure) references Structure(id)

insert into Structure values (10,2)
insert into Structure values (10,3)
insert into Structure values (10,4)
insert into Structure values (10,8)
insert into Structure values (10,8)
insert into Structure values (10,8)
insert into Structure values (10,6)
insert into Structure values (10,7)
insert into Structure values (10,11)

insert into Structure values (14,10)
insert into Structure values (14,6)
insert into Structure values (14,7)
insert into Structure values (14,13)
insert into Structure values (14,8)
insert into Structure values (14,9)
insert into Structure values (14,5)