facility

Tables (18)

admin_notes

  • id — int(11) — Primary key — NOT NULL
  • facility_id — varchar(20) — Foreign key → facility_info.facility_id — NOT NULL
  • note_content — text — NOT NULL
  • title — varchar(255) — NOT NULL
  • created_at — datetime

categories

  • code — varchar(2) — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL

check_form_types

  • form_type_code — varchar(50) — Primary key — NOT NULL
  • form_name — varchar(100) — NOT NULL
  • description — text

check_item_master

  • item_code — varchar(50) — Primary key — NOT NULL
  • category — enum('safety','structure') — NOT NULL
  • description — text

facility_info

  • facility_id — varchar(20) — Primary key — NOT NULL
  • category_code — varchar(2) — Foreign key → categories.code
  • facility_name — varchar(100)
  • location — varchar(255)
  • use_date — date
  • foundation_type_id — int(11) — Foreign key → foundation_types.id
  • structure_type_id — int(11) — Foreign key → structure_types.id
  • final_grade — varchar(1)

facility_note

  • id — int(11) — Primary key — NOT NULL
  • facility_id — varchar(20) — Foreign key → facility_info.facility_id — NOT NULL
  • note — text
  • created_at — timestamp

field_matching

  • id — int(11) — Primary key — NOT NULL
  • match_text — varchar(255) — NOT NULL
  • field_name — varchar(255) — NOT NULL

files

  • id — int(11) — Primary key — NOT NULL
  • note_id — int(11) — Foreign key → admin_notes.id
  • file_name — varchar(255)
  • file_path — varchar(255)
  • uploaded_at — datetime

foundation_types

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL

general_check

  • row_index — int(11) — Primary key — NOT NULL
  • col_index — int(11) — Primary key — NOT NULL
  • value — text
  • facility_id — varchar(20) — Foreign key → facility_info.facility_id
  • check_form_type — varchar(50) — Foreign key → check_form_types.form_type_code
  • check_date — date

safety_check

  • id — int(11) — Primary key — NOT NULL
  • facility_id — varchar(20) — Foreign key → facility_info.facility_id — NOT NULL
  • item_code — varchar(50) — Foreign key → check_item_master.item_code — NOT NULL
  • content — text
  • grade — char(1)
  • created_at — timestamp

safety_contents

  • id — int(11) — Primary key — NOT NULL
  • item_code — varchar(50) — Foreign key → check_item_master.item_code — NOT NULL
  • content — text — NOT NULL

safety_image

  • id — int(11) — Primary key — NOT NULL
  • facility_id — varchar(20) — Foreign key → facility_info.facility_id
  • item_code — varchar(50) — Foreign key → check_item_master.item_code
  • image_path — varchar(255)
  • description — text

structure_check

  • id — int(11) — Primary key — NOT NULL
  • facility_id — varchar(20) — Foreign key → facility_info.facility_id — NOT NULL
  • item_code — varchar(50) — Foreign key → check_item_master.item_code — NOT NULL
  • content — text
  • grade — char(1)
  • created_at — timestamp

structure_check_items

  • row_index — int(11) — Primary key — NOT NULL
  • col_index — int(11) — Primary key — NOT NULL
  • value — text
  • facility_id — varchar(20) — Foreign key → facility_info.facility_id
  • check_form_type — varchar(50) — Foreign key → check_form_types.form_type_code
  • check_date — date

structure_contents

  • id — int(11) — Primary key — NOT NULL
  • item_code — varchar(50) — Foreign key → check_item_master.item_code — NOT NULL
  • content — text — NOT NULL

structure_image

  • id — int(11) — Primary key — NOT NULL
  • facility_id — varchar(20) — Foreign key → facility_info.facility_id
  • item_code — varchar(50) — Foreign key → check_item_master.item_code
  • image_path — varchar(255)
  • description — text

structure_types

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL