didim
Tables (75)
Address
- id — BIGINT — NOT NULL
- road_address — VARCHAR(255)
- lot_number_address — VARCHAR(20)
- detail_address — VARCHAR(255)
- building_register_pk — VARCHAR(255)
AdjacentBuilding
- lot_number — VARCHAR(20)
- structure_usage — VARCHAR(255)
- floors — VARCHAR(255)
- separation_distance — VARCHAR(255)
- remarks — TEXT
AerialWorkPlan
- id — BIGINT — Primary key — NOT NULL
- work_plan_site_name — VARCHAR(255)
- work_plan_work_date — DATETIME
- work_plan_equipment_name — VARCHAR(255)
- work_plan_insurance — VARCHAR(255)
- work_plan_company_name — VARCHAR(255)
- work_plan_specification — VARCHAR(255)
- work_plan_inspection_validity — VARCHAR(255)
- work_plan_work_commander — VARCHAR(255)
- work_plan_model — VARCHAR(50)
- work_plan_usage_period — VARCHAR(255)
- work_plan_operator_qualification — VARCHAR(255)
- work_plan_registration_number — VARCHAR(20)
- work_plan_work_location — VARCHAR(255)
- work_plan_operator_name — VARCHAR(255)
- work_plan_registered_company — VARCHAR(255)
- work_plan_worker_training_date — DATETIME
- work_plan_signal_person_name — VARCHAR(255)
- work_plan_max_work_range_work_height — VARCHAR(255)
- work_plan_max_work_range_work_radius — VARCHAR(255)
- work_plan_max_work_range_max_work_load — VARCHAR(255)
- work_plan_max_work_range_max_workers — VARCHAR(255)
- work_plan_pre_survey_surveyor — VARCHAR(255)
- work_plan_pre_survey_reinforcement_judgment — VARCHAR(255)
- work_plan_reference_images — TEXT
BDPImage
- id — BIGINT — NOT NULL
- url — TEXT
- description — TEXT
- comment — VARCHAR(255)
BasePlateThicknessReview
- id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50)
- specification — VARCHAR(255)
- crane — VARCHAR(255)
- design_bearing_capacity — VARCHAR(255)
- base_plate_thickness_review — VARCHAR(255)
- review_standard — VARCHAR(255)
BuildingOverview
- id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50)
- lot_number — VARCHAR(20)
- site_area — VARCHAR(255)
- building_area — VARCHAR(255)
- demolition_floor_area — VARCHAR(255)
- structure — VARCHAR(255)
- floors — VARCHAR(255)
- max_height — VARCHAR(255)
BuildingSummary
- id — BIGINT — Primary key — NOT NULL
- building_name_content — TEXT
- building_name_dong_name — VARCHAR(255)
- location_content — VARCHAR(255)
- total_floor_area_content — TEXT
- floors_basement — VARCHAR(255)
- floors_above_ground — VARCHAR(255)
- floors_rooftop — VARCHAR(255)
- structural_type_reinforced_concrete — VARCHAR(50)
- structural_type_steel — VARCHAR(50)
- structural_type_masonry — VARCHAR(50)
- structural_type_wood — VARCHAR(50)
- structural_type_other — VARCHAR(50)
- extension_horizontal — VARCHAR(255)
- extension_vertical — VARCHAR(255)
- protrusion_canopy — VARCHAR(255)
- protrusion_balcony — VARCHAR(255)
- protrusion_other — VARCHAR(255)
Company
- id — BIGINT — Primary key — NOT NULL
- company_name — VARCHAR(255)
- company_contact — VARCHAR(20)
- representative — VARCHAR(255)
- corporate_reg_number — NUMERIC(10,2)
- site_manager — VARCHAR(255)
- site_manager_contact — VARCHAR(20)
Complaint
- id — BIGINT — Primary key — NOT NULL
- content — TEXT
- images — TEXT
ConcreteStrength
- id — BIGINT — Primary key — NOT NULL
- floor — VARCHAR(255)
- survey_location_col_x — VARCHAR(255)
- survey_location_col_y — VARCHAR(255)
- member_name — VARCHAR(255)
- strike_average — VARCHAR(255)
- strike_direction — VARCHAR(255)
- strike_correction — VARCHAR(255)
- standard_hardness — VARCHAR(255)
- age_coefficient — VARCHAR(255)
- estimated_strength_material_institute — VARCHAR(255)
- estimated_strength_architecture_institute — VARCHAR(255)
- estimated_strength_us_army — VARCHAR(255)
- estimated_strength_estimated — VARCHAR(255)
- remarks — TEXT
DemolitionMethod
- id — BIGINT — Primary key — NOT NULL
- building_scale — VARCHAR(255)
- structural_type — VARCHAR(50)
- building_height — VARCHAR(255)
- pedestrian_road_adjacent — VARCHAR(255)
- demolition_scope — VARCHAR(255)
- main_equipment — VARCHAR(255)
- method_overview_interior_exterior — VARCHAR(255)
- method_overview_roof_level — VARCHAR(50)
- method_overview_high_rise — VARCHAR(255)
- method_overview_low_rise — VARCHAR(255)
- method_overview_basement — VARCHAR(255)
- method_overview_jack_support_floors — VARCHAR(255)
- method_overview_waste_transport — VARCHAR(255)
DemolitionOrder
- id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50)
- specification — VARCHAR(255)
- load_calculation — VARCHAR(255)
- safety_review — VARCHAR(255)
DemolitionPlan
- demolition_reason — VARCHAR(255)
- demolition_period_start_date — DATETIME
- demolition_period_end_date — DATETIME
- demolition_scope_floors — VARCHAR(255)
- demolition_scope_height — VARCHAR(255)
- demolition_scope_ad_tower — VARCHAR(255)
- demolition_method — VARCHAR(255)
DemolitionProcess
- id — BIGINT — Primary key — NOT NULL
- eqp_lding_flr_plan_flow — VARCHAR(255)
- eqp_lding_cross_sec_view_flow — VARCHAR(255)
- grnd_dismantling_flr_plan_flow — VARCHAR(255)
- grnd_dismantling_cross_sec_view_flow — VARCHAR(255)
- basmnt_demo_flr_plan_flow — VARCHAR(255)
- basmnt_demo_cross_sec_view_flow — VARCHAR(255)
- lrg_spac_struct_flr_plan_flow — VARCHAR(255)
- lrg_spac_struct_cross_sec_view_flow — VARCHAR(255)
- ovrturn_blast_dem_flow — VARCHAR(255)
DemolitionRelation
- category — VARCHAR(50)
- existence — VARCHAR(255)
- type — VARCHAR(50)
- interference — VARCHAR(255)
- remarks — TEXT
DesignLoad
- id — BIGINT — Primary key — NOT NULL
- usage_ — VARCHAR(255)
- dead_load_category — VARCHAR(50)
- dead_load_thk — VARCHAR(255)
- dead_load_kn_m — VARCHAR(255)
- live_load — VARCHAR(255)
- dl_ll — VARCHAR(255)
DetailedSurvey
- id — BIGINT — Primary key — NOT NULL
- survey_item — VARCHAR(255)
- survey_result — VARCHAR(255)
- action_plan — VARCHAR(255)
Displacement
- building_direction — VARCHAR(255)
- survey_location_col_x — VARCHAR(255)
- survey_location_col_y — VARCHAR(255)
- target_height — VARCHAR(255)
- direction — VARCHAR(255)
- measured_value — VARCHAR(255)
- displacement_amount — INT
- evaluation_grade — VARCHAR(50)
DustControlPlan
- id — BIGINT — Primary key — NOT NULL
- content — TEXT
- onsite_plan_images — TEXT
- onsite_plan_application_standard — VARCHAR(255)
- onsite_plan_features — VARCHAR(255)
- onsite_plan_wheel_washing_time — DATETIME
- onsite_plan_manpower_allocation — VARCHAR(255)
- offsite_spray_facility_plan — VARCHAR(255)
Equipment
- equipment_name — VARCHAR(255)
- specification — VARCHAR(255)
- quantity — INT
- usage_ — VARCHAR(255)
- remarks — TEXT
ExcavatorPlan
- id — BIGINT — Primary key — NOT NULL
- equipment_plan_company_name — VARCHAR(255)
- equipment_plan_manager — VARCHAR(255)
- equipment_plan_work_type — VARCHAR(50)
- equipment_plan_work_location — VARCHAR(255)
- equipment_plan_work_period — VARCHAR(255)
- equipment_plan_total_work_amount — INT
- equipment_plan_speed_limit — VARCHAR(255)
- equipment_plan_work_commander — VARCHAR(255)
- equipment_plan_signal_method — VARCHAR(255)
- equipment_plan_guide_location_1 — VARCHAR(255)
- equipment_plan_guide_location_2 — VARCHAR(255)
- equipment_plan_route_start_point — NUMERIC(10,2)
- equipment_plan_route_end_point — NUMERIC(10,2)
- equipment_plan_ppe_supply — VARCHAR(255)
- equipment_plan_work_method_sequence — VARCHAR(255)
FireSafety
- id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50)
- type — VARCHAR(50)
InvestigationResult
- id — BIGINT — Primary key — NOT NULL
- survey_item — VARCHAR(255)
- survey_result — VARCHAR(255)
MobileCrane
- id — BIGINT — Primary key — NOT NULL
- lifting_equipment_specification — VARCHAR(255)
- lifting_equipment_weight — VARCHAR(255)
- load_specification — VARCHAR(255)
- load_weight — VARCHAR(255)
- building_height — VARCHAR(255)
- boom_length — VARCHAR(255)
- separation_distance — VARCHAR(255)
- crane_max_lifting_load — VARCHAR(255)
- load_calculation — VARCHAR(255)
- safety_review_result — VARCHAR(255)
NoiseVibrationControl
- id — BIGINT — Primary key — NOT NULL
- content — TEXT
- countermeasure_by_stage — INT
NoiseVibrationPlan
- id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50)
- detail_content — TEXT
OverturningReview
- id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50)
- specification — VARCHAR(255)
- load_calculation — VARCHAR(255)
- stability_review — VARCHAR(255)
PlanWriter
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- qualification_number — VARCHAR(20)
- office_name — VARCHAR(255)
- report_number — VARCHAR(20)
- office_address — VARCHAR(255)
- office_contact — VARCHAR(20)
- review_deadline_start_date — DATETIME
- review_deadline_end_date — DATETIME
- writing_fee — VARCHAR(255)
PublicFacilityProtection
- id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50)
- existence — VARCHAR(255)
- protection_plan — VARCHAR(255)
- remarks — TEXT
ReinforcementStatus
- floor — VARCHAR(255)
- survey_location_col_x — VARCHAR(255)
- survey_location_col_y — VARCHAR(255)
- member_name — VARCHAR(255)
- measurement_location — VARCHAR(255)
- reinforcement — VARCHAR(255)
- cover_thickness — VARCHAR(255)
- remarks — TEXT
- image — TEXT
RoadStatus
- id — BIGINT — Primary key — NOT NULL
- road_width — VARCHAR(255)
- road_location — VARCHAR(255)
- sidewalk_location — VARCHAR(255)
- remarks — TEXT
SafetyInspection
- inspection_date — DATETIME
- inspection_location — VARCHAR(255)
- supervisor — VARCHAR(255)
- supervisor_signature — VARCHAR(255)
- demolition_worker — VARCHAR(255)
- demolition_worker_signature — VARCHAR(255)
- safety_checklist — VARCHAR(255)
- writing_method — VARCHAR(255)
SafetyMeasure
- id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50)
- safety_measure — VARCHAR(255)
SiteCleanUpPlan
- id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50)
- detail_content — TEXT
SlingSafetyReview
- id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50)
- specification — VARCHAR(255)
- load_calculation — VARCHAR(255)
- stability_review — VARCHAR(255)
SprayPlan
- id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50)
- detail_content — TEXT
- reference_images — TEXT
StructuralSafetyReview
- id — BIGINT — NOT NULL
- build_site_insp_loc_map — VARCHAR(255)
- build_site_insp_img — VARCHAR(255)
- build_site_insp_res_data — VARCHAR(255)
TemporaryStorage
- category — VARCHAR(50)
- existence — VARCHAR(255)
- operation_plan — VARCHAR(255)
- remarks — TEXT
TemporaryStructure
- type — VARCHAR(50)
- member_specification — VARCHAR(255)
- member_spacing_vertical — VARCHAR(255)
- member_spacing_horizontal — VARCHAR(255)
- wall_joint_spacing_vertical — VARCHAR(255)
- wall_joint_spacing_horizontal — VARCHAR(255)
- max_height — VARCHAR(255)
- screen_type — VARCHAR(50)
UndergroundBuilding
- category — VARCHAR(50)
- existence — VARCHAR(255)
- separation_distance — VARCHAR(255)
- action_required — VARCHAR(255)
- remarks — TEXT
UndergroundFacility
- category — VARCHAR(50)
- related_agency — VARCHAR(255)
- phone_number — VARCHAR(20)
- remarks — TEXT
UndergroundStructure
- id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50)
- existence — VARCHAR(255)
- action_plan — VARCHAR(255)
- action_status — VARCHAR(50)
- remarks — TEXT
- reference_images — TEXT
WasteClassification
- id — BIGINT — Primary key — NOT NULL
- type — VARCHAR(50)
- disposal_company — VARCHAR(255)
- disposal_vehicle — VARCHAR(255)
- cover_existence — VARCHAR(255)
- transport_action — VARCHAR(255)
- related_photos — VARCHAR(255)
WasteDischargePlan
- id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50)
- location — VARCHAR(255)
- size — INT
- count — INT
- remarks — TEXT
- reduction_measure — VARCHAR(255)
WasteManagementDetail
- id — BIGINT — Primary key — NOT NULL
- construction_waste_type — VARCHAR(50)
- discharge_amount — INT
- transport_transporter — VARCHAR(255)
- transport_transport_amount — INT
- disposal_company_name — VARCHAR(255)
- disposal_disposal_amount — INT
WasteManagementPlan
- type — VARCHAR(50)
- discharge_amount — INT
- transport_transporter — VARCHAR(255)
- transport_transport_amount — INT
- disposal_disposal_type — VARCHAR(50)
- disposal_company_name — VARCHAR(255)
- disposal_disposal_method — VARCHAR(255)
- disposal_disposal_amount — INT
WasteProcess
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- stage_category — VARCHAR(50)
- stage_detail_content — TEXT
admin
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
bdp_draft
- id — BIGINT — Primary key — NOT NULL
- bdp_drafter_id — BIGINT
- company_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- represent_number — VARCHAR(20)
- represent_email — VARCHAR(100)
- location — VARCHAR(255)
- road_address — VARCHAR(255)
- lot_number_address — VARCHAR(20)
- address_detail — VARCHAR(255)
- latitude — NUMERIC(10,8)
- longitude — NUMERIC(11,8)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
bdp_drafter
- id — BIGINT — Primary key — NOT NULL
- third_class_service_id — BIGINT
- user_id — BIGINT
- is_checked — CHAR(1)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
- address_detail — VARCHAR(255)
- latitude — NUMERIC(10,8)
- longitude — NUMERIC(11,8)
bdp_metadata
- id — BIGINT — Primary key — NOT NULL
- status — VARCHAR(50)
- site_name — VARCHAR(255)
- site_location — VARCHAR(255)
- user_id — BIGINT
- approve_user_id — BIGINT
- data_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
- submitted_at — DATETIME
- reviewed_at — DATETIME
bdp_review_opinion
- id — BIGINT — Primary key — NOT NULL
- review_round_id — BIGINT
- reviewer_registry_id — BIGINT
- token — VARCHAR(64) — NOT NULL
- reviewer_name — VARCHAR(50)
- reviewer_specialty — VARCHAR(50)
- opinion — TEXT
- decision — VARCHAR(20)
- submitted_at — DATETIME
- created_at — DATETIME — NOT NULL
bdp_review_round
- id — BIGINT — Primary key — NOT NULL
- bdp_metadata_id — BIGINT
- round_no — INT — NOT NULL
- requested_by — BIGINT
- requested_at — DATETIME — NOT NULL
- final_decision — VARCHAR(20)
- decided_at — DATETIME
- created_at — DATETIME — NOT NULL
bdp_status_history
- id — BIGINT — Primary key — NOT NULL
- bdp_metadata_id — BIGINT
- from_status — VARCHAR(50)
- to_status — VARCHAR(50) — NOT NULL
- change_type — VARCHAR(50) — NOT NULL
- review_round_id — BIGINT
- changed_by — BIGINT
- reason — TEXT
- changed_at — DATETIME — NOT NULL
bdp_temps
- _id — BIGINT — Primary key
- general_info — VARCHAR(255)
- building_surroundings_survey — VARCHAR(255)
- demolition_target_survey — VARCHAR(255)
- hazardous_material_survey — VARCHAR(255)
- underground_facility_action_plan — VARCHAR(255)
- demolition_method_selection — VARCHAR(255)
- demolition_equipment_plan — VARCHAR(255)
- temporary_structure_plan — VARCHAR(255)
- demolition_work_sequence — VARCHAR(255)
- structural_safety_plan — VARCHAR(255)
- safety_management_plan — VARCHAR(255)
- environmental_management_plan — VARCHAR(255)
- waste_management_plan — VARCHAR(255)
- site_cleanup — VARCHAR(255)
- __v — VARCHAR(255)
bdps
- _id — BIGINT — Primary key
- general_info — VARCHAR(255)
- building_surroundings_survey — VARCHAR(255)
- demolition_target_survey — VARCHAR(255)
- hazardous_material_survey — VARCHAR(255)
- underground_facility_action_plan — VARCHAR(255)
- demolition_method_selection — VARCHAR(255)
- demolition_equipment_plan — VARCHAR(255)
- temporary_structure_plan — VARCHAR(255)
- demolition_work_sequence — VARCHAR(255)
- structural_safety_plan — VARCHAR(255)
- safety_management_plan — VARCHAR(255)
- environmental_management_plan — VARCHAR(255)
- waste_management_plan — VARCHAR(255)
- site_cleanup — VARCHAR(255)
- __v — VARCHAR(255)
data_3d
- pk — VARCHAR(255)
- fileKey — TEXT
- fileName — TEXT
- fileDescription — TEXT
- file_type — TEXT
- coordinate — VARCHAR(255)
- upload_status — VARCHAR(50)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
department
- id — BIGINT — Primary key — NOT NULL
- company_id — BIGINT
- higher_department_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- chief_name — VARCHAR(255)
- represent_number — VARCHAR(20)
- represent_email — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
feature_tile
- id — BIGINT — NOT NULL
- tileRoot — VARCHAR(255)
- coordinate — VARCHAR(255)
- sandan_company_pk — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
first_class_policy
- id — BIGINT — Primary key — NOT NULL
- service_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
first_class_service
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- is_location — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
log
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT
- description — TEXT
- result — VARCHAR(255)
- state — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
metadata_b3dm
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- upload_status — VARCHAR(50)
- coordinate — VARCHAR(255)
- root_uri — TEXT
- uploader_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
other_class_policy
- id — BIGINT — Primary key — NOT NULL
- service_id — BIGINT
- higher_class_policy_id — BIGINT
- circular_higher_class_policy_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
other_class_service
- id — BIGINT — Primary key — NOT NULL
- higher_class_service_id — BIGINT
- circular_higher_class_service_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- is_location — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
policy
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- first_class_policy — VARCHAR(255)
- second_class_policy — VARCHAR(255)
- third_class_policy — VARCHAR(255)
- other_class_policy — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
region_code
- code — VARCHAR(10) — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL
- is_active — CHAR(1)
- sort_order — INT
- created_at — DATETIME — NOT NULL
reviewer_registry
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- specialty — VARCHAR(50)
- region_code — VARCHAR(10)
- registry_year — INT — NOT NULL
- linked_user_id — BIGINT
- external_id — VARCHAR(50)
- is_active — CHAR(1)
- created_at — DATETIME — NOT NULL
second_class_policy
- id — BIGINT — Primary key — NOT NULL
- service_id — BIGINT
- higher_class_policy_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
second_class_service
- id — BIGINT — Primary key — NOT NULL
- higher_class_service_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- is_location — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
sign_in_out_log
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT
- ip_address — VARCHAR(255)
- jwt_token — VARCHAR(255)
- state — VARCHAR(255)
- description — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
third_class_policy
- id — BIGINT — Primary key — NOT NULL
- service_id — BIGINT
- higher_class_policy_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
third_class_service
- id — BIGINT — Primary key — NOT NULL
- higher_class_service_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- is_location — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
user
- id — BIGINT — Primary key — NOT NULL
- affiliated_company_id — BIGINT
- affiliated_department_id — BIGINT
- account — INT
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(20)
- email — VARCHAR(100)
- rank — VARCHAR(255)
- profile_image_uri — TEXT
- policy — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
user_role
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT
- role — VARCHAR(20) — NOT NULL
- bdp_metadata_id — BIGINT
- created_at — DATETIME — NOT NULL