Wiki source code of Data Structures

Version 2.2 by Kerem Yollu on 2025/03/21 15:20

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

Applications