LIMS
Tables (13)
analysis (Untitled8)
- template (Key) — UUID — Primary key — NOT NULL
- batch (Key2) — integer — Primary key — NOT NULL
- row (Key3) — integer — Primary key — NOT NULL
- request(code) (Key5) — character — Foreign key → request.code — NOT NULL
- patient(id) (Key23) — bigint — Foreign key → request.patient(id) — NOT NULL
- create_time (Field3) — timestamp
- patient (Field4) — bigint
- serial (Field6) — character
- value (Field7) — json
- result (Field8) — character
- sort (Field9) — character
batch (Untitled9)
- template (Key) — UUID — Primary key — NOT NULL
- idx (Key2) — integer — Primary key — NOT NULL
- user(id) (Key3) — character — Foreign key → user.id — NOT NULL
- create_time (Field2) — timestamp
- exec_date (Field4) — date
- title (Field5) — character
- state (Field6) — character
- value (Field7) — json
file (Untitled10)
- id (Key) — UUID — Primary key — NOT NULL
- template (Field) — UUID
- idx (Field2) — bigint
- code (Field3) — character
- analysis (Field4) — integer
- column (Field5) — UUID
- create_time (Field6) — timestamp
- update_time (Field7) — timestamp
- name (Field8) — character
- extension (Field9) — character
- size (Field10) — bigint
- bytes (Field11) — bytea
- column2 (Field12) — UUID
- type (Field13) — character
patient (Untitled3)
- id (Key) — bigint — Primary key — NOT NULL
- serial (Field) — character
- patient_code (Field2) — character
- patient_name (Field3) — character
- sample_type1 (Field4) — character
- sample_type2 (Field5) — character
- sample_type3 (Field6) — character
- customer_code (Field7) — character
- customer_name (Field8) — character
- customer_pid (Field9) — character
- remark (Field10) — character
- barcode (Field11) — bigint
- id_lis (Field12) — bigint
- customer_code2 (Field13) — character
- customer_name (Field14) — character
plugin (Untitled11)
- id (Key) — UUID — Primary key — NOT NULL
- sheet (Field) — UUID
- name (Field2) — character
- description (Field3) — character
- slot (Field4) — integer
- exec (Field5) — integer
- order (Field6) — character
- color (Field7) — character
- colorbg (Field8) — character
- icon (Field9) — character
- type (Field10) — character
recept (Untitled2)
- work (Key3) — uuid — Primary key — NOT NULL
- code (Key4) — character — Foreign key → request.code — NOT NULL
- patient(id) (Key22) — bigint — Foreign key → request.patient(id) — NOT NULL
- user (Key) — character — Foreign key → user.id — NOT NULL
- create_time (Field) — timestamp
- idx (Field2) — integer
- serial (Field5) — character
- value (Field4) — json
request (Untitled)
- code (Key) — character — Primary key — NOT NULL
- patient(id) (Key2) — bigint — Foreign key → patient.id — NOT NULL
- name (Field)
- labemp (Field2) — integer
- date_req (Field3) — timestamp
- date_start (Field4) — timestamp
- date_due (Field5) — timestamp
- tat (Field6) — integer
- is_registered (Field7) — boolean
- sync_time (Field8) — timestamp
- is_canceled (Field9) — boolean
- is_deleted (Field10) — boolean
- date_sampling (Field11) — timestamp
request_code (Untitled4)
- Key — character — Primary key — NOT NULL
- name (Field) — character
- work (Field2) — character
- synonym (Field3) — character
- color (Field4) — character
sheet (Untitled6)
- id (Key) — uuid — Primary key — NOT NULL
- name (Field) — character
- fixed_coloumns_left (Field2) — smallint
- page_size (Field3) — smallint
- order_column (Field4) — character
- asc (Field5) — boolean
tuple (Untitled12)
- template (Key) — UUID — Primary key — NOT NULL
- batch (Field) — integer
- analysis (Field2) — integer
- column (Field3) — UUID
- create_time (Field4) — timestamp
- serial (Field5) — character
- value (Field6) — json
- tmp (Field7) — integer
- sort (Field8) — character
- tuple (Field9) — character
user (Untitled7)
- id (Key) — character — Primary key — NOT NULL
- department (Field) — character
- name (Field2) — character
- group (Field3) — UUID
- password (Field4) — character
- email (Field5) — character
- key (Field6) — UUID
- serial (Field7) — character
- state (Field8) — character
user_group (Untitled13)
- id (Key) — UUID — Primary key — NOT NULL
- name (Field) — character
worklist (Untitled5)
- work (Key) — uuid — Primary key — NOT NULL
- idx (Key2) — integer — Primary key — NOT NULL
- user (Key4) — character — Foreign key → user.id — NOT NULL
- create_time (Field) — character
- state (Field2) — character
- title (Field3) — character
- value (Field4) — jsonb