Wiki source code of Data Structures
Version 9.1 by Kerem Yollu on 2025/03/22 14:48
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
1.1 | 1 | = Data Structures for KPM and database relations = |
| 2 | |||
| 3 | |||
| 4 | = Models = | ||
| 5 | |||
| |
2.2 | 6 | == Address == |
| |
1.1 | 7 | |
| |
9.1 | 8 | * {{code language="sql" layout="LINENUMBERS"}}DROP TABLE IF EXISTS public.address; |
| 9 | |||
| |
1.1 | 10 | CREATE TABLE public.address |
| 11 | ( | ||
| 12 | uid SERIAL PRIMARY KEY, | ||
| |
2.1 | 13 | country CHAR(2) NOT NULL, -- ISO 3166-1 alpha-2 (e.g., 'CH') |
| 14 | region VARCHAR(100), -- State or canton | ||
| |
1.1 | 15 | city VARCHAR(100) NOT NULL, |
| 16 | postcode VARCHAR(20) NOT NULL, | ||
| 17 | street VARCHAR(255) NOT NULL, | ||
| |
2.1 | 18 | number VARCHAR(20), |
| 19 | unit VARCHAR(50), -- Apartment/Suite/Floor/etc. | ||
| 20 | extra_address VARCHAR(255), -- Additional info | ||
| 21 | lon DOUBLE PRECISION, -- Longitude (optional) | ||
| 22 | lat DOUBLE PRECISION -- Latitude (optional) | ||
| |
1.1 | 23 | ) |
| 24 | |||
| 25 | TABLESPACE pg_default; | ||
| 26 | |||
| 27 | ALTER TABLE IF EXISTS public.address | ||
| 28 | OWNER to kpm_rw; | ||
| 29 | |||
| 30 | COMMENT ON TABLE public.address | ||
| |
2.2 | 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}} |
| |
3.2 | 32 | |
| |
9.1 | 33 | == Common table having the same Cols. an pointing to no other table == |
| |
3.2 | 34 | |
| |
9.1 | 35 | == == |