Skip to Content

Changes for page Data Structures

Last modified by Kerem Yollu on 2025/03/23 11:28
From version 2.1
edited by Kerem Yollu
on 2025/03/21 15:18
Change comment: There is no comment for this version
To version 11.1
edited by Kerem Yollu
on 2025/03/22 14:50
Change comment: There is no comment for this version

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,1 @@
1 -Kynsight.Projects.KPM.Data Structure And Models.WebHome
1 +xwiki:Kynsight.Projects.KPM.Data Structures.Data Structure And Models.WebHome
Content
... ... @@ -3,9 +3,10 @@
3 3  
4 4  = Models =
5 5  
6 -== Address
7 -{{code language="SQL" layout="LINENUMBERS"}}DROP TABLE IF EXISTS public.address;
6 +== Address ==
8 8  
8 +* {{code language="sql" layout="LINENUMBERS"}}DROP TABLE IF EXISTS public.address;
9 +
9 9  CREATE TABLE public.address
10 10  (
11 11   uid SERIAL PRIMARY KEY,
... ... @@ -27,4 +27,32 @@
27 27   OWNER to kpm_rw;
28 28  
29 29  COMMENT ON TABLE public.address
30 - IS 'addresses table, instead of making use of addresses for ever company, customer and co... Prefer to make addresses table and then assign it to a company or a user etc.';{{/code}} ==
31 + IS 'addresses table, instead of making use of addresses for ever company, customer and co... Prefer to make addresses table and then assign it to a company or a user etc.';{{/code}}
32 +
33 +== Common Stand alone tables having the same Cols. and pointing to no other table ==
34 +
35 +{{code language="sql"}}
36 +DO $$
37 +DECLARE
38 + tname TEXT;
39 +BEGIN
40 + FOREACH tname IN ARRAY ARRAY'company_legal_form','company_relation','company_status','company_type',
41 + 'task_status', 'task_type', 'task_category',
42 + 'user_role', 'user_type',
43 + 'project_type','project_areas', 'project_person_roles', 'project_company_role']
44 + LOOP
45 + EXECUTE format('
46 + CREATE TABLE IF NOT EXISTS public.%I (
47 + uid SERIAL PRIMARY KEY,
48 + name VARCHAR(100) NOT NULL,
49 + description VARCHAR(255),
50 + creation_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
51 + updated_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
52 + );
53 + ALTER TABLE public.%I OWNER TO kpm_rw;
54 + ', tname, tname);
55 + END LOOP;
56 +END$$;
57 +{{/code}}
58 +
59 +== ==