Wiki source code of Data Structures

Version 4.2 by Kerem Yollu on 2025/03/21 15:34

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

Applications