document_response

Tables (5)

customer

  • id — SERIAL — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • region — VARCHAR(10) — NOT NULL

device_inspection_log

  • id — SERIAL — Primary key — NOT NULL
  • device_installation_id (id2) — INTEGER — Foreign key → device_installation.id — NOT NULL
  • check_date — DATE
  • check_content — TEXT
  • inspector_name — VARCHAR(100)
  • firmware_controller — VARCHAR(50)
  • firmware_readerboard — VARCHAR(50)
  • gain_value — VARCHAR(20)
  • p4_value — VARCHAR(20)
  • p5_value — VARCHAR(20)
  • p6_value — VARCHAR(20)
  • p7_value — VARCHAR(20)

device_installation

  • id — SERIAL — Primary key — NOT NULL
  • installation_location_id (id2) — INTEGER — Foreign key → installation_location.id — NOT NULL
  • install_date — DATE
  • antenna_type — VARCHAR(50)
  • controller_type — VARCHAR(50)
  • antenna_lane_count — VARCHAR(20)
  • filter_type — VARCHAR(50)
  • footplate_yn — VARCHAR(10)
  • footplate_version — VARCHAR(50)
  • remarks — TEXT

installation_location

  • id — SERIAL — Primary key — NOT NULL
  • site_id (id2) — INTEGER — Foreign key → site.id — NOT NULL
  • location_detail — VARCHAR(100) — NOT NULL
  • partner_id (Field) — INTEGER

site

  • id — SERIAL — Primary key — NOT NULL
  • customer_id (id2) — INTEGER — Foreign key → customer.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL