search

hr-integrate / documentation

This repository is used for documentation of meetings and software (might be moved outside of this repository in the future)
0 stars 0 forks source link

Analyze legacy db structure for different user types #1

Open cocey opened 4 months ago

cocey commented 4 months ago

hr_profiles table

it seems all profiles (mentor and mentee) kept in this table.

SELECT * FROM `hr_profiles` PROCEDURE ANALYSE()
Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
thomas_batsching_hri.hr_profiles.ID 2 1946 1 4 0 0 1029.0411 560.5982
thomas_batsching_hri.hr_profiles.password 005db6e68355131b1f457ed67e39fd46 ff8bf88c55fe2171b6f08a69d0c6b59e 32 32 0 0 32.0000 NULL
thomas_batsching_hri.hr_profiles.userlevel 1 2 1 1 0 0 1.0017 0.0418
thomas_batsching_hri.hr_profiles.mail 1984kh1ar@gmail.com zzarouf@gmail.com 11 46 0 0 22.5249 NULL
thomas_batsching_hri.hr_profiles.session   vuas2troeot80b9l7ihl4erui0 0 32 128 97 23.3461 NULL
thomas_batsching_hri.hr_profiles.ctime 0000-00-00 00:00:00 2024-04-12 15:05:12 19 19 0 97 19.0000 NULL
thomas_batsching_hri.hr_profiles.lastlog 2016-03-14 09:47:41 2024-04-12 20:12:09 19 19 0 97 19.0000 NULL
thomas_batsching_hri.hr_profiles.last_update 2016-08-10 09:22:27 2024-04-13 02:18:41 19 19 0 0 19.0000 NULL
thomas_batsching_hri.hr_profiles.validate_date 2016-03-08 08:46:46 2024-04-12 09:03:21 19 19 0 0 19.0000 NULL
thomas_batsching_hri.hr_profiles.validate_code 1457423206mhugel11no2 1712905401issaloran9h6bz 17 41 0 0 27.0262 NULL
thomas_batsching_hri.hr_profiles.validate 1 1 1 1 0 0 1.0000 0.0000
thomas_batsching_hri.hr_profiles.profile_type 1 2 1 1 0 0 1.7025 0.4571
thomas_batsching_hri.hr_profiles.mrmrs 0 2 1 1 319 0 1.1925 0.8448
thomas_batsching_hri.hr_profiles.gname   مهدي 0 19 69 273 5.9241 NULL
thomas_batsching_hri.hr_profiles.lname   محرابی 0 20 28 273 6.8046 NULL
thomas_batsching_hri.hr_profiles.phone   905339136544 0 37 276 273 8.4897 NULL
thomas_batsching_hri.hr_profiles.adress_additional   سيدي الطيبي 0 94 641 273 4.9092 NULL
thomas_batsching_hri.hr_profiles.street   شریعتی ک۳۴ پ۷ 0 94 351 273 9.9805 NULL
thomas_batsching_hri.hr_profiles.zip   niederkrüchten 0 15 40 273 4.8092 NULL
thomas_batsching_hri.hr_profiles.city   ایرلن 0 41 36 273 8.9069 NULL
thomas_batsching_hri.hr_profiles.infotxt   مهندس معلومات قسم حاسبات واتصالات محمولة 0 4125 324 273 276.8609 NULL
thomas_batsching_hri.hr_profiles.age   69 0 6 151 273 1.6632 NULL
thomas_batsching_hri.hr_profiles.profile_img 1457950695.jpg 1712905950.jpg 14 15 15 779 13.6813 NULL
thomas_batsching_hri.hr_profiles.hr_status   status_6 0 8 263 273 4.5517 NULL
thomas_batsching_hri.hr_profiles.education   مهندس معلومات اختصاص حاسبات واتصالات محمولة 0 210 448 273 12.7724 NULL
thomas_batsching_hri.hr_profiles.education_high   لیسانس 0 105 445 273 8.7345 NULL
thomas_batsching_hri.hr_profiles.lang_mother   فازسی 0 37 345 0 6.1470 NULL
thomas_batsching_hri.hr_profiles.lang_other   عربي،فرنسي 0 65 878 0 3.3692 NULL
thomas_batsching_hri.hr_profiles.lang_more   3 0 7 396 0 1.3920 NULL
thomas_batsching_hri.hr_profiles.know   9#12 0 28 528 0 2.2765 NULL
thomas_batsching_hri.hr_profiles.know_other   تجارة،فلاحة 0 233 775 0 10.1094 NULL
thomas_batsching_hri.hr_profiles.target   9#12 0 28 727 0 1.7393 NULL
thomas_batsching_hri.hr_profiles.target_other   Повар 0 259 960 0 3.7279 NULL
thomas_batsching_hri.hr_profiles.capa 0 1 1 1 1088 0 0.0481 0.2140
thomas_batsching_hri.hr_profiles.capa_x   YES 0 4 695 273 0.2195 NULL
thomas_batsching_hri.hr_profiles.search_status 0 2 1 1 954 0 0.2870 0.6692
thomas_batsching_hri.hr_profiles.in_touch   992 0 255 668 287 3.9801 NULL
thomas_batsching_hri.hr_profiles.ds_pub 0 1 1 1 1049 0 0.0822 0.2747
thomas_batsching_hri.hr_profiles.ds_email 0 1 1 1 1002 0 0.1234 0.3288
thomas_batsching_hri.hr_profiles.ds_phone 0 1 1 1 1066 0 0.0674 0.2507
thomas_batsching_hri.hr_profiles.ds_adress 0 1 1 1 1072 0 0.0621 0.2414
thomas_batsching_hri.hr_profiles.ds_info_logmail 1 1 1 1 937 0 0.1802 0.3844
thomas_batsching_hri.hr_profiles.ds_info_statusmail 1 1 1 1 102 0 0.9108 0.2851
thomas_batsching_hri.hr_profiles.deak 0 1 1 1 552 0 0.5171 0.4997
thomas_batsching_hri.hr_profiles.ds_info_profilmail 1 1 1 1 0 0 1.0000 0.0000
thomas_batsching_hri.hr_profiles.date_profil_infomail 2017-06-01 11:55:40 2024-04-12 13:15:29 19 19 0 64 19.0000 NULL
cocey commented 4 months ago

Fields with value group

profile_type

possible : 1=mentor, 2=mentee profile_type COUNT(*)
1 340
2 803

hr_status

hr_status COUNT(*)
NULL 273
  263
0 128
status_1 227
status_2 137
status_3 17
status_4 5
status_5 70
status_6 23

Fields to learn from code

thomas_batsching_hri.hr_profiles.know thomas_batsching_hri.hr_profiles.target thomas_batsching_hri.hr_profiles.capa thomas_batsching_hri.hr_profiles.search_status thomas_batsching_hri.hr_profiles.deak

cocey commented 3 months ago

contact fields

thomas_batsching_hri.hr_profiles.mrmrs Contact GenderIdentity thomas_batsching_hri.hr_profiles.gname Contact FirstName thomas_batsching_hri.hr_profiles.lname Contact LastName thomas_batsching_hri.hr_profiles.phone Contact Phone thomas_batsching_hri.hr_profiles.age Contact Birthdate thomas_batsching_hri.hr_profiles.profile_img Contact PhotoUrl

cocey commented 3 months ago

address fields

thomas_batsching_hri.hr_profiles.street Address Street thomas_batsching_hri.hr_profiles.zip Address PostalCode thomas_batsching_hri.hr_profiles.city Address City

cocey commented 3 months ago

hr_status

Residence permit status
Aufenthaltsstatus
"status_1" => "Residence Permit - Right of Asylum", 
"status_2" => "Residence Permit - Refugee Protection", 
"status_3" => "Residence Permit - Subsidiary Protection", 
"status_4" => "Residence Permit - Prohibition of Deportation", 
"status_5" => "Permission to Reside", 
"status_6" => "Temporary Suspension of Deportation Status", 
"status_1" => "Aufenthaltserlaubnis – Asylberechtigung", 
"status_2" => "Aufenthaltserlaubnis – Flüchtlingsschutz", 
"status_3" => "Aufenthaltserlaubnis - subsidiärer Schutz", 
"status_4" => "Aufenthaltserlaubnis – Abschiebungsverbot", 
"status_5" => "Aufenthaltsgestattung", 
"status_6" => "Duldungsstatus",

Questions

is it also requiered for Mentors ?

cocey commented 3 months ago

capacity

capa

if capa is 1

Currently, I have no further capacity. I am looking after one or more refugees.

capa_x

this field is accepting text but it seems it must be a number!