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