Skip to content

Latest commit

 

History

History
56 lines (52 loc) · 4.77 KB

DEVELOP.md

File metadata and controls

56 lines (52 loc) · 4.77 KB
Raw

PostgreSQL Tables

pacsfiles_pacs

                                                           Table "public.pacsfiles_pacs"
   Column   |         Type          | Collation | Nullable |             Default              | Storage  | Compression | Stats target | Description
------------+-----------------------+-----------+----------+----------------------------------+----------+-------------+--------------+-------------
 id         | bigint                |           | not null | generated by default as identity | plain    |             |              |
 identifier | character varying(20) |           | not null |                                  | extended |             |              |
Indexes:
    "pacsfiles_pacs_pkey" PRIMARY KEY, btree (id)
    "pacsfiles_pacs_identifier_fc12db8a_like" btree (identifier varchar_pattern_ops)
    "pacsfiles_pacs_identifier_key" UNIQUE CONSTRAINT, btree (identifier)
Referenced by:
    TABLE "pacsfiles_pacsfile" CONSTRAINT "pacsfiles_pacsfile_pacs_id_a6922e71_fk" FOREIGN KEY (pacs_id) REFERENCES pacsfiles_pacs(id) DEFERRABLE INITIALLY DEFERRED
Access method: heap

pacsfiles_pacsfile

                                                              Table "public.pacsfiles_pacsfile"
      Column       |           Type           | Collation | Nullable |             Default              | Storage  | Compression | Stats target | Description
-------------------+--------------------------+-----------+----------+----------------------------------+----------+-------------+--------------+-------------
 id                | bigint                   |           | not null | generated by default as identity | plain    |             |              |
 creation_date     | timestamp with time zone |           | not null |                                  | plain    |             |              |
 fname             | character varying(512)   |           | not null |                                  | extended |             |              |
 PatientID         | character varying(100)   |           | not null |                                  | extended |             |              |
 PatientName       | character varying(150)   |           | not null |                                  | extended |             |              |
 StudyInstanceUID  | character varying(100)   |           | not null |                                  | extended |             |              |
 StudyDescription  | character varying(400)   |           | not null |                                  | extended |             |              |
 SeriesInstanceUID | character varying(100)   |           | not null |                                  | extended |             |              |
 SeriesDescription | character varying(400)   |           | not null |                                  | extended |             |              |
 pacs_id           | bigint                   |           | not null |                                  | plain    |             |              |
 PatientAge        | integer                  |           |          |                                  | plain    |             |              |
 PatientBirthDate  | date                     |           |          |                                  | plain    |             |              |
 PatientSex        | character varying(1)     |           | not null |                                  | extended |             |              |
 Modality          | character varying(15)    |           | not null |                                  | extended |             |              |
 ProtocolName      | character varying(64)    |           | not null |                                  | extended |             |              |
 StudyDate         | date                     |           | not null |                                  | plain    |             |              |
 AccessionNumber   | character varying(100)   |           | not null |                                  | extended |             |              |
Indexes:
    "pacsfiles_pacsfile_pkey" PRIMARY KEY, btree (id)
    "pacsfiles_pacsfile_AccessionNumber_530efc42" btree ("AccessionNumber")
    "pacsfiles_pacsfile_AccessionNumber_530efc42_like" btree ("AccessionNumber" varchar_pattern_ops)
    "pacsfiles_pacsfile_PatientID_65a17c84" btree ("PatientID")
    "pacsfiles_pacsfile_PatientID_65a17c84_like" btree ("PatientID" varchar_pattern_ops)
    "pacsfiles_pacsfile_StudyDate_5821d7cf" btree ("StudyDate")
    "pacsfiles_pacsfile_fname_475c1816_like" btree (fname varchar_pattern_ops)
    "pacsfiles_pacsfile_fname_key" UNIQUE CONSTRAINT, btree (fname)
    "pacsfiles_pacsfile_pacs_id_a6922e71" btree (pacs_id)
Foreign-key constraints:
    "pacsfiles_pacsfile_pacs_id_a6922e71_fk" FOREIGN KEY (pacs_id) REFERENCES pacsfiles_pacs(id) DEFERRABLE INITIALLY DEFERRED
Access method: heap