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