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