-- -- PostgreSQL database dump -- -- Dumped from database version 14.8 -- Dumped by pg_dump version 14.10 (Ubuntu 14.10-0ubuntu0.22.04.1) SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- Name: SImage; Type: TABLE; Schema: public; Owner: spacs -- CREATE TABLE public."SImage" ( id integer NOT NULL, name text DEFAULT ''::text NOT NULL, value integer NOT NULL ); ALTER TABLE public."SImage" OWNER TO spacs; -- -- Name: SImage_id_seq; Type: SEQUENCE; Schema: public; Owner: spacs -- CREATE SEQUENCE public."SImage_id_seq" AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public."SImage_id_seq" OWNER TO spacs; -- -- Name: SImage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spacs -- ALTER SEQUENCE public."SImage_id_seq" OWNED BY public."SImage".id; -- -- Name: _prisma_migrations; Type: TABLE; Schema: public; Owner: spacs -- CREATE TABLE public._prisma_migrations ( id character varying(36) NOT NULL, checksum character varying(64) NOT NULL, finished_at timestamp with time zone, migration_name character varying(255) NOT NULL, logs text, rolled_back_at timestamp with time zone, started_at timestamp with time zone DEFAULT now() NOT NULL, applied_steps_count integer DEFAULT 0 NOT NULL ); ALTER TABLE public._prisma_migrations OWNER TO spacs; -- -- Name: s_image; Type: TABLE; Schema: public; Owner: spacs -- CREATE TABLE public.s_image ( index integer NOT NULL, created_datetime character varying(14) DEFAULT to_char(now(), 'YYYYMMDDhhmmss'::text), image_instance_uid character varying(256) DEFAULT ''::character varying NOT NULL, file_location character varying(1024) DEFAULT ''::character varying NOT NULL, acquisition_number integer NOT NULL, image_number integer NOT NULL, patient_index integer NOT NULL, study_index integer NOT NULL, series_index integer NOT NULL ); ALTER TABLE public.s_image OWNER TO spacs; -- -- Name: s_image_index_seq; Type: SEQUENCE; Schema: public; Owner: spacs -- CREATE SEQUENCE public.s_image_index_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.s_image_index_seq OWNER TO spacs; -- -- Name: s_image_index_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spacs -- ALTER SEQUENCE public.s_image_index_seq OWNED BY public.s_image.index; -- -- Name: s_order; Type: TABLE; Schema: public; Owner: spacs -- CREATE TABLE public.s_order ( index integer NOT NULL, created_datetime character varying(14) DEFAULT to_char(now(), 'YYYYMMDDhhmmss'::text), study_reserve_datetime character varying(14) DEFAULT to_char(now(), 'YYYYMMDDhhmmss'::text), order_modality character varying(16) DEFAULT ''::character varying, order_name character varying(64) DEFAULT ''::character varying, order_code character varying(64) DEFAULT ''::character varying, order_status character varying(16) DEFAULT ''::character varying, order_reason character varying(256) DEFAULT ''::character varying, accession_number bigint DEFAULT 0, physician_name character varying(64) DEFAULT ''::character varying, order_department character varying(64) DEFAULT ''::character varying, study_complete_date character varying(14) DEFAULT NULL::character varying, status_flag character varying(1) DEFAULT 'Y'::character varying, patient_index bigint NOT NULL ); ALTER TABLE public.s_order OWNER TO spacs; -- -- Name: s_order_index_seq; Type: SEQUENCE; Schema: public; Owner: spacs -- CREATE SEQUENCE public.s_order_index_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.s_order_index_seq OWNER TO spacs; -- -- Name: s_order_index_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spacs -- ALTER SEQUENCE public.s_order_index_seq OWNED BY public.s_order.index; -- -- Name: s_patient; Type: TABLE; Schema: public; Owner: spacs -- CREATE TABLE public.s_patient ( index integer NOT NULL, created_datetime character varying(14) DEFAULT to_char(now(), 'YYYYMMDDhhmmss'::text), patient_name character varying(64) DEFAULT ''::character varying NOT NULL, patient_id character varying(128) DEFAULT ''::character varying NOT NULL, patient_uid character varying(128) DEFAULT ''::character varying, patient_sex character varying(8) DEFAULT ''::character varying, patient_birth_date character varying(8) DEFAULT ''::character varying, patient_age character varying(4) DEFAULT ''::character varying, patient_location character varying(8) DEFAULT ''::character varying ); ALTER TABLE public.s_patient OWNER TO spacs; -- -- Name: s_patient_index_seq; Type: SEQUENCE; Schema: public; Owner: spacs -- CREATE SEQUENCE public.s_patient_index_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.s_patient_index_seq OWNER TO spacs; -- -- Name: s_patient_index_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spacs -- ALTER SEQUENCE public.s_patient_index_seq OWNED BY public.s_patient.index; -- -- Name: s_series; Type: TABLE; Schema: public; Owner: spacs -- CREATE TABLE public.s_series ( index integer NOT NULL, created_datetime character varying(14) DEFAULT to_char(now(), 'YYYYMMDDhhmmss'::text), series_instance_uid character varying(256) DEFAULT ''::character varying NOT NULL, series_description character varying(256) DEFAULT ''::character varying NOT NULL, series_report character varying(4096) DEFAULT ''::character varying NOT NULL, modality character varying(16) DEFAULT ''::character varying NOT NULL, patient_index integer NOT NULL, study_index integer NOT NULL ); ALTER TABLE public.s_series OWNER TO spacs; -- -- Name: s_series_index_seq; Type: SEQUENCE; Schema: public; Owner: spacs -- CREATE SEQUENCE public.s_series_index_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.s_series_index_seq OWNER TO spacs; -- -- Name: s_series_index_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spacs -- ALTER SEQUENCE public.s_series_index_seq OWNED BY public.s_series.index; -- -- Name: s_study; Type: TABLE; Schema: public; Owner: spacs -- CREATE TABLE public.s_study ( index integer NOT NULL, created_datetime character varying(14) DEFAULT to_char(now(), 'YYYYMMDDhhmmss'::text), study_instance_uid character varying(256) DEFAULT ''::character varying NOT NULL, study_description character varying(256) DEFAULT ''::character varying NOT NULL, study_report character varying(4096) DEFAULT ''::character varying NOT NULL, study_date character varying(8) DEFAULT ''::character varying NOT NULL, study_time character varying(6) DEFAULT ''::character varying NOT NULL, order_index integer NOT NULL, patient_index integer NOT NULL ); ALTER TABLE public.s_study OWNER TO spacs; -- -- Name: s_study_index_seq; Type: SEQUENCE; Schema: public; Owner: spacs -- CREATE SEQUENCE public.s_study_index_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.s_study_index_seq OWNER TO spacs; -- -- Name: s_study_index_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spacs -- ALTER SEQUENCE public.s_study_index_seq OWNED BY public.s_study.index; -- -- Name: SImage id; Type: DEFAULT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public."SImage" ALTER COLUMN id SET DEFAULT nextval('public."SImage_id_seq"'::regclass); -- -- Name: s_image index; Type: DEFAULT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public.s_image ALTER COLUMN index SET DEFAULT nextval('public.s_image_index_seq'::regclass); -- -- Name: s_order index; Type: DEFAULT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public.s_order ALTER COLUMN index SET DEFAULT nextval('public.s_order_index_seq'::regclass); -- -- Name: s_patient index; Type: DEFAULT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public.s_patient ALTER COLUMN index SET DEFAULT nextval('public.s_patient_index_seq'::regclass); -- -- Name: s_series index; Type: DEFAULT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public.s_series ALTER COLUMN index SET DEFAULT nextval('public.s_series_index_seq'::regclass); -- -- Name: s_study index; Type: DEFAULT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public.s_study ALTER COLUMN index SET DEFAULT nextval('public.s_study_index_seq'::regclass); -- -- Data for Name: SImage; Type: TABLE DATA; Schema: public; Owner: spacs -- COPY public."SImage" (id, name, value) FROM stdin; 2 test2 2 3 test3 3 4 test4 4 1 test11 1 5 test5 5 \. -- -- Data for Name: _prisma_migrations; Type: TABLE DATA; Schema: public; Owner: spacs -- COPY public._prisma_migrations (id, checksum, finished_at, migration_name, logs, rolled_back_at, started_at, applied_steps_count) FROM stdin; 586a87d8-29f7-4f39-9c27-711e4768f2fd d47653fd619c9200de79be046d103ff8533322bc8106665291f20ce18d3d18ab 2023-06-04 20:30:17.821879+09 20230604113017_init \N \N 2023-06-04 20:30:17.811107+09 1 \. -- -- Data for Name: s_image; Type: TABLE DATA; Schema: public; Owner: spacs -- COPY public.s_image (index, created_datetime, image_instance_uid, file_location, acquisition_number, image_number, patient_index, study_index, series_index) FROM stdin; 1 20230608100617 1.2.34.5678.20230608103818.1.1.4 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.1.1.4_4.dcm 0 4 1 1 1 2 20230608100649 1.2.34.5678.20230608103818.1.1.5 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.1.1.5_5.dcm 0 5 1 1 1 3 20230608100650 1.2.34.5678.20230608103818.1.1.6 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.1.1.6_6.dcm 0 6 1 1 1 4 20230608100650 1.2.34.5678.20230608103818.1.1.7 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.1.1.7_7.dcm 0 7 1 1 1 5 20230608100650 1.2.34.5678.20230608103818.1.1.8 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.1.1.8_8.dcm 0 8 1 1 1 6 20230608100651 1.2.34.5678.20230608103818.1.1.9 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.1.1.9_9.dcm 0 9 1 1 1 7 20230608100651 1.2.34.5678.20230608103818.1.1.10 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.1.1.10_10.dcm 0 10 1 1 1 8 20230608100651 1.2.34.5678.20230608103818.1.1.11 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.1.1.11_11.dcm 0 11 1 1 1 9 20230608100651 1.2.34.5678.20230608103818.1.1.12 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.1.1.12_12.dcm 0 12 1 1 1 10 20230608100652 1.2.34.5678.20230608103818.1.1.13 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.1.1.13_13.dcm 0 13 1 1 1 11 20230608100653 1.2.34.5678.20230608103818.1.1.14 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.1.1.14_14.dcm 0 14 1 1 1 12 20230608100638 1.2.34.5678.20230608103818.2.1.1 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.1_1.dcm 0 1 2 2 2 13 20230608100639 1.2.34.5678.20230608103818.2.1.2 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.2_2.dcm 0 2 2 2 2 14 20230608100640 1.2.34.5678.20230608103818.2.1.3 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.3_3.dcm 0 3 2 2 2 15 20230608100640 1.2.34.5678.20230608103818.2.1.4 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.4_4.dcm 0 4 2 2 2 16 20230608100640 1.2.34.5678.20230608103818.2.1.5 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.5_5.dcm 0 5 2 2 2 17 20230608100641 1.2.34.5678.20230608103818.2.1.6 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.6_6.dcm 0 6 2 2 2 18 20230608100641 1.2.34.5678.20230608103818.2.1.7 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.7_7.dcm 0 7 2 2 2 19 20230608100643 1.2.34.5678.20230608103818.2.1.8 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.8_8.dcm 0 8 2 2 2 20 20230608100643 1.2.34.5678.20230608103818.2.1.9 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.9_9.dcm 0 9 2 2 2 21 20230608100643 1.2.34.5678.20230608103818.2.1.10 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.10_10.dcm 0 10 2 2 2 22 20230608100643 1.2.34.5678.20230608103818.2.1.11 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.11_11.dcm 0 11 2 2 2 23 20230608100643 1.2.34.5678.20230608103818.2.1.12 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.12_12.dcm 0 12 2 2 2 24 20230608100643 1.2.34.5678.20230608103818.2.1.13 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.13_13.dcm 0 13 2 2 2 25 20230608100643 1.2.34.5678.20230608103818.2.1.14 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.14_14.dcm 0 14 2 2 2 26 20230608100643 1.2.34.5678.20230608103818.2.1.15 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.15_15.dcm 0 15 2 2 2 27 20230608100643 1.2.34.5678.20230608103818.2.1.16 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.16_16.dcm 0 16 2 2 2 28 20230608100643 1.2.34.5678.20230608103818.2.1.17 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.17_17.dcm 0 17 2 2 2 29 20230608100643 1.2.34.5678.20230608103818.2.1.18 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.2.1.18_18.dcm 0 18 2 2 2 30 20230608100648 1.2.34.5678.20230608103818.3.1.1 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.3.1.1_1.dcm 0 1 3 3 3 31 20230608100649 1.2.34.5678.20230608103818.3.1.2 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.3.1.2_2.dcm 0 2 3 3 3 32 20230608100650 1.2.34.5678.20230608103818.3.1.3 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.3.1.3_3.dcm 0 3 3 3 3 33 20230608100650 1.2.34.5678.20230608103818.3.1.4 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.3.1.4_4.dcm 0 4 3 3 3 34 20230608100650 1.2.34.5678.20230608103818.3.1.5 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.3.1.5_5.dcm 0 5 3 3 3 35 20230608100651 1.2.34.5678.20230608103818.3.1.6 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.3.1.6_6.dcm 0 6 3 3 3 36 20230608100652 1.2.34.5678.20230608103818.3.1.7 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.3.1.7_7.dcm 0 7 3 3 3 37 20230608100653 1.2.34.5678.20230608103818.3.1.8 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.3.1.8_8.dcm 0 8 3 3 3 38 20230608100653 1.2.34.5678.20230608103818.3.1.9 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.3.1.9_9.dcm 0 9 3 3 3 39 20230608100654 1.2.34.5678.20230608103818.3.1.10 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.3.1.10_10.dcm 0 10 3 3 3 40 20230608100655 1.2.34.5678.20230608103818.3.1.11 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.3.1.11_11.dcm 0 11 3 3 3 41 20230608100656 1.2.34.5678.20230608103818.3.1.12 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.3.1.12_12.dcm 0 12 3 3 3 42 20230608100657 1.2.34.5678.20230608103818.3.1.13 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.3.1.13_13.dcm 0 13 3 3 3 43 20230608100657 1.2.34.5678.20230608103818.3.1.14 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.3.1.14_14.dcm 0 14 3 3 3 44 20230608100658 1.2.34.5678.20230608103818.3.1.15 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.3.1.15_15.dcm 0 15 3 3 3 45 20230608100609 1.2.34.5678.20230608103818.4.1.1 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.4.1.1_1.dcm 0 1 4 4 4 46 20230608100611 1.2.34.5678.20230608103818.4.1.2 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.4.1.2_2.dcm 0 2 4 4 4 47 20230608100611 1.2.34.5678.20230608103818.4.1.3 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.4.1.3_3.dcm 0 3 4 4 4 48 20230608100611 1.2.34.5678.20230608103818.4.1.4 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.4.1.4_4.dcm 0 4 4 4 4 49 20230608100613 1.2.34.5678.20230608103818.4.1.5 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.4.1.5_5.dcm 0 5 4 4 4 50 20230608100613 1.2.34.5678.20230608103818.4.1.6 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.4.1.6_6.dcm 0 6 4 4 4 51 20230608100613 1.2.34.5678.20230608103818.4.1.7 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.4.1.7_7.dcm 0 7 4 4 4 52 20230608100613 1.2.34.5678.20230608103818.4.1.8 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.4.1.8_8.dcm 0 8 4 4 4 53 20230608100613 1.2.34.5678.20230608103818.4.1.9 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.4.1.9_9.dcm 0 9 4 4 4 54 20230608100613 1.2.34.5678.20230608103818.4.1.10 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.4.1.10_10.dcm 0 10 4 4 4 55 20230608100613 1.2.34.5678.20230608103818.4.1.11 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.4.1.11_11.dcm 0 11 4 4 4 56 20230608100613 1.2.34.5678.20230608103818.4.1.12 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.4.1.12_12.dcm 0 12 4 4 4 57 20230608100613 1.2.34.5678.20230608103818.4.1.13 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.4.1.13_13.dcm 0 13 4 4 4 58 20230608040617 1.2.34.5678.20230608103818.6.1.1 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.1_1.dcm 0 1 5 5 5 59 20230608040618 1.2.34.5678.20230608103818.6.1.2 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.2_2.dcm 0 2 5 5 5 60 20230608040619 1.2.34.5678.20230608103818.6.1.3 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.3_3.dcm 0 3 5 5 5 61 20230608040619 1.2.34.5678.20230608103818.6.1.4 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.4_4.dcm 0 4 5 5 5 62 20230608040619 1.2.34.5678.20230608103818.6.1.5 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.5_5.dcm 0 5 5 5 5 63 20230608040619 1.2.34.5678.20230608103818.6.1.6 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.6_6.dcm 0 6 5 5 5 64 20230608040620 1.2.34.5678.20230608103818.6.1.7 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.7_7.dcm 0 7 5 5 5 65 20230608040620 1.2.34.5678.20230608103818.6.1.8 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.8_8.dcm 0 8 5 5 5 66 20230608040620 1.2.34.5678.20230608103818.6.1.9 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.9_9.dcm 0 9 5 5 5 67 20230608040621 1.2.34.5678.20230608103818.6.1.10 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.10_10.dcm 0 10 5 5 5 68 20230608040621 1.2.34.5678.20230608103818.6.1.11 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.11_11.dcm 0 11 5 5 5 69 20230608040621 1.2.34.5678.20230608103818.6.1.12 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.12_12.dcm 0 12 5 5 5 70 20230608040621 1.2.34.5678.20230608103818.6.1.13 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.13_13.dcm 0 13 5 5 5 71 20230608040621 1.2.34.5678.20230608103818.6.1.14 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.14_14.dcm 0 14 5 5 5 72 20230608040621 1.2.34.5678.20230608103818.6.1.15 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.15_15.dcm 0 15 5 5 5 73 20230608040621 1.2.34.5678.20230608103818.6.1.16 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.16_16.dcm 0 16 5 5 5 74 20230608040621 1.2.34.5678.20230608103818.6.1.17 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.17_17.dcm 0 17 5 5 5 75 20230608040622 1.2.34.5678.20230608103818.6.1.18 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.18_18.dcm 0 18 5 5 5 76 20230608040622 1.2.34.5678.20230608103818.6.1.19 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.19_19.dcm 0 19 5 5 5 77 20230608040622 1.2.34.5678.20230608103818.6.1.20 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.20_20.dcm 0 20 5 5 5 78 20230608040622 1.2.34.5678.20230608103818.6.1.21 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.21_21.dcm 0 21 5 5 5 79 20230608040622 1.2.34.5678.20230608103818.6.1.22 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.22_22.dcm 0 22 5 5 5 80 20230608040623 1.2.34.5678.20230608103818.6.1.23 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.23_23.dcm 0 23 5 5 5 81 20230608040623 1.2.34.5678.20230608103818.6.1.24 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.24_24.dcm 0 24 5 5 5 82 20230608040623 1.2.34.5678.20230608103818.6.1.25 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.25_25.dcm 0 25 5 5 5 83 20230608040623 1.2.34.5678.20230608103818.6.1.26 Storage\\2023\\06\\08\\ES_1.2.34.5678.20230608103818.6.1.26_26.dcm 0 26 5 5 5 \. -- -- Data for Name: s_order; Type: TABLE DATA; Schema: public; Owner: spacs -- COPY public.s_order (index, created_datetime, study_reserve_datetime, order_modality, order_name, order_code, order_status, order_reason, accession_number, physician_name, order_department, study_complete_date, status_flag, patient_index) FROM stdin; \. -- -- Data for Name: s_patient; Type: TABLE DATA; Schema: public; Owner: spacs -- COPY public.s_patient (index, created_datetime, patient_name, patient_id, patient_uid, patient_sex, patient_birth_date, patient_age, patient_location) FROM stdin; 1 20230608100617 Test^Hilbert^^ 20230608103818101 M 2 20230608100638 Test^Hilbert^^ 20230608103818102 M 3 20230608100648 Test^Hilbert^^ 20230608103818103 M 4 20230608100609 Test^Hilbert^^ 20230608103818104 M 5 20230608040617 Test^Hilbert^^ 20230608103818106 M \. -- -- Data for Name: s_series; Type: TABLE DATA; Schema: public; Owner: spacs -- COPY public.s_series (index, created_datetime, series_instance_uid, series_description, series_report, modality, patient_index, study_index) FROM stdin; 1 20230608100617 1.2.34.5678.20230608103818.1.1 ksuaghoahsglahglsahg ES 1 1 2 20230608100638 1.2.34.5678.20230608103818.2.1 ksuaghoahsglahglsahg ES 2 2 3 20230608100648 1.2.34.5678.20230608103818.3.1 ksuaghoahsglahglsahg ES 3 3 4 20230608100609 1.2.34.5678.20230608103818.4.1 ksuaghoahsglahglsahg ES 4 4 5 20230608040617 1.2.34.5678.20230608103818.6.1 ksuaghoahsglahglsahg ES 5 5 6 20230608100638 1.2.34.5678.20230608103818.1.2 ksuaghoahsglahglsahg ES 1 1 \. -- -- Data for Name: s_study; Type: TABLE DATA; Schema: public; Owner: spacs -- COPY public.s_study (index, created_datetime, study_instance_uid, study_description, study_report, study_date, study_time, order_index, patient_index) FROM stdin; 1 20230608100617 1.2.34.5678.20230608103818.1 20230608 103833 20 1 2 20230608100638 1.2.34.5678.20230608103818.2 20230608 105033 20 2 3 20230608100648 1.2.34.5678.20230608103818.3 20230608 105043 20 3 4 20230608100609 1.2.34.5678.20230608103818.4 20230608 105104 20 4 5 20230608040617 1.2.34.5678.20230608103818.6 20230608 163012 20 5 \. -- -- Name: SImage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spacs -- SELECT pg_catalog.setval('public."SImage_id_seq"', 5, true); -- -- Name: s_image_index_seq; Type: SEQUENCE SET; Schema: public; Owner: spacs -- SELECT pg_catalog.setval('public.s_image_index_seq', 83, true); -- -- Name: s_order_index_seq; Type: SEQUENCE SET; Schema: public; Owner: spacs -- SELECT pg_catalog.setval('public.s_order_index_seq', 1, false); -- -- Name: s_patient_index_seq; Type: SEQUENCE SET; Schema: public; Owner: spacs -- SELECT pg_catalog.setval('public.s_patient_index_seq', 5, true); -- -- Name: s_series_index_seq; Type: SEQUENCE SET; Schema: public; Owner: spacs -- SELECT pg_catalog.setval('public.s_series_index_seq', 5, true); -- -- Name: s_study_index_seq; Type: SEQUENCE SET; Schema: public; Owner: spacs -- SELECT pg_catalog.setval('public.s_study_index_seq', 5, true); -- -- Name: SImage SImage_pkey; Type: CONSTRAINT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public."SImage" ADD CONSTRAINT "SImage_pkey" PRIMARY KEY (id); -- -- Name: _prisma_migrations _prisma_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public._prisma_migrations ADD CONSTRAINT _prisma_migrations_pkey PRIMARY KEY (id); -- -- Name: s_image s_image_pkey; Type: CONSTRAINT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public.s_image ADD CONSTRAINT s_image_pkey PRIMARY KEY (index); -- -- Name: s_order s_order_pkey; Type: CONSTRAINT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public.s_order ADD CONSTRAINT s_order_pkey PRIMARY KEY (index); -- -- Name: s_patient s_patient_pkey; Type: CONSTRAINT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public.s_patient ADD CONSTRAINT s_patient_pkey PRIMARY KEY (index); -- -- Name: s_series s_series_pkey; Type: CONSTRAINT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public.s_series ADD CONSTRAINT s_series_pkey PRIMARY KEY (index); -- -- Name: s_study s_study_pkey; Type: CONSTRAINT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public.s_study ADD CONSTRAINT s_study_pkey PRIMARY KEY (index); -- -- Name: s_study fk_patient_index; Type: FK CONSTRAINT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public.s_study ADD CONSTRAINT fk_patient_index FOREIGN KEY (patient_index) REFERENCES public.s_patient(index) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: s_series fk_patient_index; Type: FK CONSTRAINT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public.s_series ADD CONSTRAINT fk_patient_index FOREIGN KEY (patient_index) REFERENCES public.s_patient(index) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: s_image fk_patient_index; Type: FK CONSTRAINT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public.s_image ADD CONSTRAINT fk_patient_index FOREIGN KEY (patient_index) REFERENCES public.s_patient(index) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: s_image fk_series_index; Type: FK CONSTRAINT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public.s_image ADD CONSTRAINT fk_series_index FOREIGN KEY (series_index) REFERENCES public.s_series(index) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: s_image fk_study_index; Type: FK CONSTRAINT; Schema: public; Owner: spacs -- ALTER TABLE ONLY public.s_image ADD CONSTRAINT fk_study_index FOREIGN KEY (study_index) REFERENCES public.s_study(index) ON UPDATE CASCADE ON DELETE CASCADE; -- -- PostgreSQL database dump complete --