Changes for page Data Structures
Last modified by Kerem Yollu on 2025/03/23 11:28
From version 12.4
edited by Kerem Yollu
on 2025/03/23 10:47
on 2025/03/23 10:47
Change comment:
There is no comment for this version
To version 11.2
edited by Kerem Yollu
on 2025/03/22 14:56
on 2025/03/22 14:56
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -1,12 +1,10 @@ 1 1 = Data Structures for KPM and database relations = 2 2 3 3 4 -= CoreEntity Tables =4 += Models = 5 5 6 6 == Address == 7 7 8 -{{diagram/}} 9 - 10 10 {{code language="SQL"}} 11 11 -- Table: public.address 12 12 ... ... @@ -57,39 +57,8 @@ 57 57 IS 'Optional: for geolocation'; 58 58 {{/code}} 59 59 60 -== Reference/LookupTables==58 +== Common Stand alone tables having the same Cols. and pointing to no other table == 61 61 62 -=== Company === 63 - 64 -* company_legal_form 65 -* company_relation 66 -* company_status 67 -* company_types 68 - 69 -=== Project === 70 - 71 -* project_areas 72 -* project_type 73 -* project_company_role 74 -* projects_person_role 75 - 76 -=== Task === 77 - 78 -* task_category 79 -* task_type 80 -* task_status 81 - 82 -=== User === 83 - 84 -* user_role 85 -* user_type 86 - 87 -=== Employee === 88 - 89 -* employee_role 90 -* employee_status 91 -* employee_departement (this one i am not shure, maybe departments should be in company ?) 92 - 93 93 {{code language="sql"}} 94 94 DO $$ 95 95 DECLARE