Skip to Content

Wiki source code of Data Structures

Version 1.1 by Kerem Yollu on 2025/03/21 15:17
Hide last authors
Kerem Yollu 1.1 1 = Data Structures for KPM and database relations =
2
3
4 = Models =
5
6 == Address ==
7
8 DROP TABLE IF EXISTS public.address;
9
10 CREATE TABLE public.address
11 (
12 uid SERIAL PRIMARY KEY,
13 country CHAR(2) NOT NULL,              ~-~- ISO 3166-1 alpha-2 (e.g., 'CH')
14 region VARCHAR(100),                   ~-~- State or canton
15 city VARCHAR(100) NOT NULL,
16 postcode VARCHAR(20) NOT NULL,
17 street VARCHAR(255) NOT NULL,
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)
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
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.';