Changes for page Data Structures

Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -5,10 +5,58 @@
5	5
6	6	== Address ==
7	7
8		-Address table is made so that i can be populated from external source like open address,
9		-
10	10	{{diagram/}}
11	11
	10	+{{code language="SQL"}}
	11	+-- Table: public.address
	12	+
	13	+-- DROP TABLE IF EXISTS public.address;
	14	+
	15	+CREATE TABLE IF NOT EXISTS public.address
	16	+(
	17	+ uid SERIAL PRIMARY KEY,
	18	+ country character(2) COLLATE pg_catalog."default" NOT NULL,
	19	+ region character varying(100) COLLATE pg_catalog."default",
	20	+ city character varying(100) COLLATE pg_catalog."default" NOT NULL,
	21	+ postcode character varying(20) COLLATE pg_catalog."default" NOT NULL,
	22	+ street character varying(255) COLLATE pg_catalog."default" NOT NULL,
	23	+ "number" character varying(20) COLLATE pg_catalog."default",
	24	+ unit character varying(50) COLLATE pg_catalog."default",
	25	+ extra_address character varying(255) COLLATE pg_catalog."default",
	26	+ lon double precision,
	27	+ lat double precision
	28	+)
	29	+
	30	+TABLESPACE pg_default;
	31	+
	32	+ALTER TABLE IF EXISTS public.address
	33	+ OWNER to kpm_rw;
	34	+
	35	+COMMENT ON TABLE public.address
	36	+ 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.';
	37	+
	38	+COMMENT ON COLUMN public.address.uid
	39	+ IS 'Unique ID for each address';
	40	+
	41	+COMMENT ON COLUMN public.address.country
	42	+ IS 'ISO 3166-1 alpha-2 (e.g., ''CH'')';
	43	+
	44	+COMMENT ON COLUMN public.address.region
	45	+ IS 'State or canton';
	46	+
	47	+COMMENT ON COLUMN public.address.unit
	48	+ IS 'Apartment/Suite/Floor/etc.';
	49	+
	50	+COMMENT ON COLUMN public.address.extra_address
	51	+ IS 'Any additional info (optional)';
	52	+
	53	+COMMENT ON COLUMN public.address.lon
	54	+ IS 'Optional: for geolocation';
	55	+
	56	+COMMENT ON COLUMN public.address.lat
	57	+ IS 'Optional: for geolocation';
	58	+{{/code}}
	59	+
12	12	== Lookup Tables without references. ==
13	13
14	14	=== Company ===