Wiki source code of Data Structures

Version 2.1 by Kerem Yollu on 2025/03/21 15:18

author	version	line-number	content
		1	= Data Structures for KPM and database relations =
		2
		3
		4	= Models =
		5
		6	== Address
		7	{{code language="SQL" layout="LINENUMBERS"}}DROP TABLE IF EXISTS public.address;
		8
		9	CREATE TABLE public.address
		10	(
		11	uid SERIAL PRIMARY KEY,
		12	country CHAR(2) NOT NULL, -- ISO 3166-1 alpha-2 (e.g., 'CH')
		13	region VARCHAR(100), -- State or canton
		14	city VARCHAR(100) NOT NULL,
		15	postcode VARCHAR(20) NOT NULL,
		16	street VARCHAR(255) NOT NULL,
		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)
		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
		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}} ==

Applications