WSPiPWp5

1-- Drop tables --
2DROP TABLE IF EXISTS master_data CASCADE;
3DROP TABLE IF EXISTS master_data_relations CASCADE;
4DROP TABLE IF EXISTS category CASCADE;
5
6-- Generate tables structure --
7CREATE TABLE master_data(
8	id SERIAL NOT NULL PRIMARY KEY,
9	code TEXT NOT NULL,
10	description TEXT NOT NULL,
11	active BOOLEAN
12);
13
14CREATE TABLE master_data_relations(
15	id SERIAL NOT NULL PRIMARY KEY,
16    master_data_father_id INT NOT NULL,
17	master_data_son_id INT NOT NULL,
18    FOREIGN KEY (master_data_father_id) REFERENCES master_data(id),
19	FOREIGN KEY (master_data_son_id) REFERENCES master_data(id)
20);
21
22INSERT INTO "master_data" ("code","description","active") values ('001','tipos de datos para atributos','true');
23INSERT INTO "master_data" ("code","description","active") values ('002','String','true');
24INSERT INTO "master_data" ("code","description","active") values ('003','Integer','true');
25INSERT INTO "master_data" ("code","description","active") values ('004','Boolean','true');
26INSERT INTO "master_data" ("code","description","active") values ('005','Array','true');
27
28INSERT INTO "master_data_relations" ("master_data_father_id","master_data_son_id") 
29values ((select id from master_data where code = '001'), (select id from master_data where code = '002'));
30
31INSERT INTO "master_data_relations" ("master_data_father_id","master_data_son_id") 
32values	((select id from master_data where code = '001'), (select id from master_data where code = '003'));
33
34INSERT INTO "master_data_relations" ("master_data_father_id","master_data_son_id") 
35values	((select id from master_data where code = '001'), (select id from master_data where code = '004'));
36
37INSERT INTO "master_data_relations" ("master_data_father_id","master_data_son_id") 
38values	((select id from master_data where code = '001'), (select id from master_data where code = '005'));
39/*
40INSERT INTO "master_data_relations" ("master_data_father_id","master_data_son_id") values ('1','3');
41INSERT INTO "master_data_relations" ("master_data_father_id","master_data_son_id") values ('1','4');
42INSERT INTO "master_data_relations" ("master_data_father_id","master_data_son_id") values ('1','5');
43*/