Skip to Content

Changes for page Data Structures

Last modified by Kerem Yollu on 2025/03/23 11:28
From version 4.2
edited by Kerem Yollu
on 2025/03/21 15:34
Change comment: Updated parent field.
To version 10.1
edited by Kerem Yollu
on 2025/03/22 14:48
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -3,9 +3,8 @@
3 3  
4 4  = Models =
5 5  
6 -* (((
7 7  == Address ==
8 -)))
7 +
9 9  * {{code language="sql" layout="LINENUMBERS"}}DROP TABLE IF EXISTS public.address;
10 10  
11 11  CREATE TABLE public.address
... ... @@ -31,9 +31,30 @@
31 31  COMMENT ON TABLE public.address
32 32   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}}
33 33  
33 +== Common table having the same Cols. an pointing to no other table ==
34 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}}
35 35  
36 -* (((
37 -== Company ==
38 -)))
39 -*
59 +== ==