ssdoctors/Podman_compose_BigData
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
main
Podman_compose_BigData/spacs.sql
birdhead 913b76f946 init
2025-10-16 21:15:12 +09:00

625 lines
25 KiB
SQL
Raw Permalink Blame History

--
-- 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
--
Reference in New Issue View Git Blame Copy Permalink