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