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