04-startlist.sql (765B)
1 CREATE TABLE public.startlist ( 2 id bigint NOT NULL, 3 created_at timestamp with time zone DEFAULT now(), 4 heat bigint NOT NULL, 5 athlete bigint NOT NULL 6 ); 7 8 ALTER TABLE public.startlist ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( 9 SEQUENCE NAME public.startlist_id_seq 10 START WITH 1 11 INCREMENT BY 1 12 NO MINVALUE 13 NO MAXVALUE 14 CACHE 1 15 ); 16 17 ALTER TABLE ONLY public.startlist 18 ADD CONSTRAINT startlist_pkey PRIMARY KEY (heat, athlete); 19 20 ALTER TABLE ONLY public.startlist 21 ADD CONSTRAINT startlist_athlete_fkey FOREIGN KEY (athlete) REFERENCES public.athletes(id) ON DELETE CASCADE; 22 23 ALTER TABLE ONLY public.startlist 24 ADD CONSTRAINT startlist_heat_fkey FOREIGN KEY (heat) REFERENCES public.heats(id) ON DELETE CASCADE;