1/8/2020 Tablas Modulo Creación de questionarios (3ab78d1e) · Commits · Guillermo Agudelo / apptalento · GitLab

Please ensure your account's recovery settings are up to date.

Commit 3ab78d1e authored 1 week ago by Guillermo Agudelo

Tablas Modulo Creación de questionarios

parent 03e0d2f5 master

No related merge requests found

Showing 10 changed files  with 1942 additions and 0 deletions

  database/migrations/2020_07_21_133318_create_states_table.php 0 → 100644
1 + <?php
2 +
3 + use Illuminate\Database\Migrations\Migration;
4 + use Illuminate\Database\Schema\Blueprint;
5 + use Illuminate\Support\Facades\Schema;
6 +
7 + class CreateStatesTable extends Migration
8 +{
9 + /**
10 + * Run the migrations.
11 + *
12 + * @return void
13 + */
14 + public function up()
15 + {
16 + Schema::create('states', function (Blueprint $table) {
17 + $table->id();
18 + $table->string('name');
19 + $table->timestamps();
20 + });
21 +
22 + $states = [
23 + ['name'=>'Amazonas', 'created_at' => now(), 'updated_at' => now()],
24 + ['name'=>'Antioquía', 'created_at' => now(), 'updated_at' => now()],
25 + ['name'=>'Arauca', 'created_at' => now(), 'updated_at' => now()],
26 + ['name'=>'Atlántico', 'created_at' => now(), 'updated_at' => now()],
27 + ['name'=>'Bolívar', 'created_at' => now(), 'updated_at' => now()],
28 + ['name'=>'Boyacá', 'created_at' => now(), 'updated_at' => now()],
29 + ['name'=>'Caldas', 'created_at' => now(), 'updated_at' => now()],
30 + ['name'=>'Caquetá', 'created_at' => now(), 'updated_at' => now()],
31 + ['name'=>'Casanare', 'created_at' => now(), 'updated_at' => now()],
32 + ['name'=>'Cauca', 'created_at' => now(), 'updated_at' => now()],
33 + ['name'=>'Cesar', 'created_at' => now(), 'updated_at' => now()],
34 + ['name'=>'Chocó', 'created_at' => now(), 'updated_at' => now()],
35 + ['name'=>'Córdoba', 'created_at' => now(), 'updated_at' => now()],
36 + ['name'=>'Cundinamarca', 'created_at' => now(), 'updated_at' => now()],
37 + ['name'=>'Guainía', 'created_at' => now(), 'updated_at' => now()],
38 + ['name'=>'Guaviare', 'created_at' => now(), 'updated_at' => now()],
39 + ['name'=>'Huila', 'created_at' => now(), 'updated_at' => now()],
40 + ['name'=>'La Guajira', 'created_at' => now(), 'updated_at' => now()],
41 + ['name'=>'Magdalena', 'created_at' => now(), 'updated_at' => now()],
42 + ['name'=>'Meta', 'created_at' => now(), 'updated_at' => now()],
43 + ['name'=>'Nariño', 'created_at' => now(), 'updated_at' => now()],
44 + ['name'=>'Norte de Santander', 'created_at' => now(), 'updated_at' => now()],
45 + ['name'=>'Putumayo', 'created_at' => now(), 'updated_at' => now()],
46 + ['name'=>'Quindío', 'created_at' => now(), 'updated_at' => now()],
47 + ['name'=>'Risaralda', 'created_at' => now(), 'updated_at' => now()],
48 + ['name'=>'San Andrés y Providencia', 'created_at' => now(), 'updated_at' => now()],
49 + ['name'=>'Santander', 'created_at' => now(), 'updated_at' => now()],
50 + ['name'=>'Sucre', 'created_at' => now(), 'updated_at' => now()],
51 + ['name'=>'Tolima', 'created_at' => now(), 'updated_at' => now()],
52 + ['name'=>'Valle del Cauca', 'created_at' => now(), 'updated_at' => now()],
53 + ['name'=>'Vaupés', 'created_at' => now(), 'updated_at' => now()],

https://gitlab.com/guille.agudelo/apptalento/-/commit/3ab78d1e13dba09daa827627011185cffbc4c55b 1/12
1/8/2020 Tablas Modulo Creación de questionarios (3ab78d1e) · Commits · Guillermo Agudelo / apptalento · GitLab

54 + ['name'=>'Vichada', 'created_at' => now(), 'updated_at' => now()],

55 + ];
56 +
57 + DB::table('states')->insert($states);
58 + }
59 +
60 + /**
61 + * Reverse the migrations.
62 + *
63 + * @return void
64 + */
65 + public function down()
66 + {
67 + Schema::dropIfExists('states');
68 + }
69 +}

  database/migrations/2020_07_21_135705_create_cities_table.php 0 → 100644

This source diff could not be displayed because it is too large. You can view the blob instead.

  database/migrations/2020_07_21_135913_create_pot_sources_table.php 0 → 100644

1 + <?php
2 +
3 + use Illuminate\Database\Migrations\Migration;
4 + use Illuminate\Database\Schema\Blueprint;
5 + use Illuminate\Support\Facades\DB;
6 + use Illuminate\Support\Facades\Schema;
7 +
8 + class CreatePotSourcesTable extends Migration
9 +{
10 + /**
11 + * Run the migrations.
12 + *
13 + * @return void
14 + */
15 + public function up()
16 + {
17 + Schema::create('pot_sources', function (Blueprint $table) {
18 + $table->id();
19 + $table->string('name');
20 + $table->timestamps();
21 + });
22 +
23 + DB::table('pot_sources')->insert([
24 + 'name' => 'Estudiante',
25 + 'created_at' => now(),
26 + 'updated_at' => now()
27 + ]);
28 +
29 + DB::table('pot_sources')->insert([
30 + 'name' => 'Docente',
31 + 'created_at' => now(),
32 + 'updated_at' => now()
33 + ]);
34 +
35 + DB::table('pot_sources')->insert([
36 + 'name' => 'Familiar',
37 + 'created_at' => now(),
38 + 'updated_at' => now()
39 + ]);
40 + }
41 +
42 + /**
43 + * Reverse the migrations.
44 + *
45 + * @return void
46 + */
47 + public function down()
48 + {
49 + Schema::dropIfExists('pot_sources');
50 + }

https://gitlab.com/guille.agudelo/apptalento/-/commit/3ab78d1e13dba09daa827627011185cffbc4c55b 2/12
1/8/2020 Tablas Modulo Creación de questionarios (3ab78d1e) · Commits · Guillermo Agudelo / apptalento · GitLab

51 +}

  database/migrations/2020_07_21_165158_create_pot_factors_table.php 0 → 100644
1 + <?php
2 +
3 + use Illuminate\Database\Migrations\Migration;
4 + use Illuminate\Database\Schema\Blueprint;
5 + use Illuminate\Support\Facades\Schema;
6 +
7 + class CreatePotFactorsTable extends Migration
8 +{
9 + /**
10 + * Run the migrations.
11 + *
12 + * @return void
13 + */
14 + public function up()
15 + {
16 + Schema::create('pot_factors', function (Blueprint $table) {
17 + $table->id();
18 + $table->string('code');
19 + $table->string('name');
20 + $table->timestamps();
21 + });
22 +
23 + DB::table('pot_factors')->insert([
24 + 'code' => 'IN',
25 + 'name' => 'Interés',
26 + 'created_at' => now(),
27 + 'updated_at' => now(),
28 + ]);
29 +
30 + DB::table('pot_factors')->insert([
31 + 'code' => 'AC',
32 + 'name' => 'Aptitud Cognitiva',
33 + 'created_at' => now(),
34 + 'updated_at' => now(),
35 + ]);
36 +
37 + DB::table('pot_factors')->insert([
38 + 'code' => 'H',
39 + 'name' => 'Habilidad',
40 + 'created_at' => now(),
41 + 'updated_at' => now(),
42 + ]);
43 +
44 + DB::table('pot_factors')->insert([
45 + 'code' => 'PR',
46 + 'name' => 'Precocidad',
47 + 'created_at' => now(),
48 + 'updated_at' => now(),
49 + ]);
50 + }
51 +
52 + /**
53 + * Reverse the migrations.
54 + *
55 + * @return void
56 + */
57 + public function down()
58 + {
59 + Schema::dropIfExists('pot_factors');
60 + }
61 +}

  database/migrations/2020_07_21_173828_create_pot_development_levels_table.php 0 → 100644

1 + <?php
2 +
3 + use Illuminate\Database\Migrations\Migration;
4 + use Illuminate\Database\Schema\Blueprint;
5 + use Illuminate\Support\Facades\Schema;
6 +
7 + class CreatePotDevelopmentLevelsTable extends Migration

https://gitlab.com/guille.agudelo/apptalento/-/commit/3ab78d1e13dba09daa827627011185cffbc4c55b 3/12
1/8/2020 Tablas Modulo Creación de questionarios (3ab78d1e) · Commits · Guillermo Agudelo / apptalento · GitLab

8 +{
9 + /**
10 + * Run the migrations.
11 + *
12 + * @return void
13 + */
14 + public function up()
15 + {
16 + Schema::create('pot_development_levels', function (Blueprint $table) {
17 + $table->id();
18 + $table->string('name');
19 + $table->timestamps();
20 + });
21 +
22 + DB::table('pot_development_levels')->insert([
23 + 'name' => 'Excepcional',
24 + 'created_at' => now(),
25 + 'updated_at' => now(),
26 + ]);
27 +
28 + DB::table('pot_development_levels')->insert([
29 + 'name' => 'Sobresaliente',
30 + 'created_at' => now(),
31 + 'updated_at' => now(),
32 + ]);
33 +
34 + DB::table('pot_development_levels')->insert([
35 + 'name' => 'Dentro de lo esperado',
36 + 'created_at' => now(),
37 + 'updated_at' => now(),
38 + ]);
39 + }
40 +
41 + /**
42 + * Reverse the migrations.
43 + *
44 + * @return void
45 + */
46 + public function down()
47 + {
48 + Schema::dropIfExists('pot_development_levels');
49 + }
50 +}

  database/migrations/2020_07_21_174127_create_pot_populations_table.php 0 → 100644
1 + <?php
2 +
3 + use Illuminate\Database\Migrations\Migration;
4 + use Illuminate\Database\Schema\Blueprint;
5 + use Illuminate\Support\Facades\Schema;
6 +
7 + class CreatePotPopulationsTable extends Migration
8 +{
9 + /**
10 + * Run the migrations.
11 + *
12 + * @return void
13 + */
14 + public function up()
15 + {
16 + Schema::create('pot_populations', function (Blueprint $table) {
17 + $table->id();
18 + $table->string('name');
19 + $table->integer('min_age');
20 + $table->integer('max_age');
21 + $table->timestamps();
22 + });
23 +
24 + DB::table('pot_populations')->insert([
25 + 'name' => 'Estudiantes entre 4 y 7 años',
26 + 'min_age' => 4,
27 + 'max_age' => 7,
28 + 'created_at' => now(),
29 + 'updated_at' => now(),

https://gitlab.com/guille.agudelo/apptalento/-/commit/3ab78d1e13dba09daa827627011185cffbc4c55b 4/12
1/8/2020 Tablas Modulo Creación de questionarios (3ab78d1e) · Commits · Guillermo Agudelo / apptalento · GitLab

30 + ]);
31 +
32 + DB::table('pot_populations')->insert([
33 + 'name' => 'Estudiantes entre 8 y 10 años',
34 + 'min_age' => 8,
35 + 'max_age' => 10,
36 + 'created_at' => now(),
37 + 'updated_at' => now(),
38 + ]);
39 +
40 + DB::table('pot_populations')->insert([
41 + 'name' => 'Estudiantes entre 11 y 17 años',
42 + 'min_age' => 11,
43 + 'max_age' => 17,
44 + 'created_at' => now(),
45 + 'updated_at' => now(),
46 + ]);
47 + }
48 +
49 + /**
50 + * Reverse the migrations.
51 + *
52 + * @return void
53 + */
54 + public function down()
55 + {
56 + Schema::dropIfExists('pot_populations');
57 + }
58 +}

  database/migrations/2020_07_21_175644_create_pot_learning_ranges_table.php 0 → 100644

1 + <?php
2 +
3 + use Illuminate\Database\Migrations\Migration;
4 + use Illuminate\Database\Schema\Blueprint;
5 + use Illuminate\Support\Facades\Schema;
6 +
7 + class CreatePotLearningRangesTable extends Migration
8 +{
9 + /**
10 + * Run the migrations.
11 + *
12 + * @return void
13 + */
14 + public function up()
15 + {
16 + Schema::create('pot_learning_ranges', function (Blueprint $table) {
17 + $table->id();
18 + $table->foreignId('pot_population_id');
19 + $table->foreignId('pot_development_level_id');
20 + $table->integer('min_points');
21 + $table->integer('max_points');
22 + $table->timestamps();
23 + });
24 +
25 +
26 + // De 4 a 7
27 + DB::table('pot_learning_ranges')->insert([
28 + 'pot_population_id' => 1,
29 + 'pot_development_level_id' => 1, //Excepcional
30 + 'min_points' => 67,
31 + 'max_points' => 100,
32 + 'created_at' => now(),
33 + 'updated_at' => now(),
34 + ]);
35 +
36 + DB::table('pot_learning_ranges')->insert([
37 + 'pot_population_id' => 1,
38 + 'pot_development_level_id' => 2, //Sobresaliente
39 + 'min_points' => 60,
40 + 'max_points' => 66,
41 + 'created_at' => now(),
42 + 'updated_at' => now(),
43 + ]);

https://gitlab.com/guille.agudelo/apptalento/-/commit/3ab78d1e13dba09daa827627011185cffbc4c55b 5/12
1/8/2020 Tablas Modulo Creación de questionarios (3ab78d1e) · Commits · Guillermo Agudelo / apptalento · GitLab

44 +
45 + DB::table('pot_learning_ranges')->insert([
46 + 'pot_population_id' => 1,
47 + 'pot_development_level_id' => 3, //Dentro de lo esperado
48 + 'min_points' => 0,
49 + 'max_points' => 59,
50 + 'created_at' => now(),
51 + 'updated_at' => now(),
52 + ]);
53 +
54 + // De 6 a 10
55 + DB::table('pot_learning_ranges')->insert([
56 + 'pot_population_id' => 2,
57 + 'pot_development_level_id' => 1, //Excepcional
58 + 'min_points' => 60,
59 + 'max_points' => 100,
60 + 'created_at' => now(),
61 + 'updated_at' => now(),
62 + ]);
63 +
64 + DB::table('pot_learning_ranges')->insert([
65 + 'pot_population_id' => 2,
66 + 'pot_development_level_id' => 2, //Sobresaliente
67 + 'min_points' => 40,
68 + 'max_points' => 59,
69 + 'created_at' => now(),
70 + 'updated_at' => now(),
71 + ]);
72 +
73 + DB::table('pot_learning_ranges')->insert([
74 + 'pot_population_id' => 2,
75 + 'pot_development_level_id' => 3, //Dentro de lo esperado
76 + 'min_points' => 0,
77 + 'max_points' => 39,
78 + 'created_at' => now(),
79 + 'updated_at' => now(),
80 + ]);
81 +
82 + // De 11 a 17
83 + DB::table('pot_learning_ranges')->insert([
84 + 'pot_population_id' => 3,
85 + 'pot_development_level_id' => 1, //Excepcional
86 + 'min_points' => 60,
87 + 'max_points' => 100,
88 + 'created_at' => now(),
89 + 'updated_at' => now(),
90 + ]);
91 +
92 + DB::table('pot_learning_ranges')->insert([
93 + 'pot_population_id' => 3,
94 + 'pot_development_level_id' => 2, //Sobresaliente
95 + 'min_points' => 54,
96 + 'max_points' => 59,
97 + 'created_at' => now(),
98 + 'updated_at' => now(),
99 + ]);
100 +
101 + DB::table('pot_learning_ranges')->insert([
102 + 'pot_population_id' => 3,
103 + 'pot_development_level_id' => 3, //Dentro de lo esperado
104 + 'min_points' => 0,
105 + 'max_points' => 53,
106 + 'created_at' => now(),
107 + 'updated_at' => now(),
108 + ]);
109 + }
110 +
111 + /**
112 + * Reverse the migrations.
113 + *
114 + * @return void
115 + */
116 + public function down()
117 + {
118 + Schema::dropIfExists('pot_learning_ranges');

https://gitlab.com/guille.agudelo/apptalento/-/commit/3ab78d1e13dba09daa827627011185cffbc4c55b 6/12
1/8/2020 Tablas Modulo Creación de questionarios (3ab78d1e) · Commits · Guillermo Agudelo / apptalento · GitLab

119 + }
120 +}

  database/migrations/2020_07_21_180823_create_pot_instruments_table.php 0 → 100644

1 + <?php
2 +
3 + use Illuminate\Database\Migrations\Migration;
4 + use Illuminate\Database\Schema\Blueprint;
5 + use Illuminate\Support\Facades\Schema;
6 +
7 + class CreatePotInstrumentsTable extends Migration
8 +{
9 + /**
10 + * Run the migrations.
11 + *
12 + * @return void
13 + */
14 + public function up()
15 + {
16 + Schema::create('pot_instruments', function (Blueprint $table) {
17 + $table->id();
18 + $table->string('name');
19 + $table->foreignId('pot_population_id');
20 + $table->foreignId('pot_source_id');
21 + $table->timestamps();
22 + });
23 +
24 + DB::table('pot_instruments')->insert([
25 + 'name' => 'Guía de observación para familias',
26 + 'pot_population_id' => 1, //4-7
27 + 'pot_source_id' => 3, //Familiar
28 + 'created_at' => now(),
29 + 'updated_at' => now(),
30 + ]);
31 +
32 + DB::table('pot_instruments')->insert([
33 + 'name' => 'Guía de observación para docentes',
34 + 'pot_population_id' => 1, //4-7
35 + 'pot_source_id' => 2, //Docente
36 + 'created_at' => now(),
37 + 'updated_at' => now(),
38 + ]);
39 +
40 + DB::table('pot_instruments')->insert([
41 + 'name' => 'Reconociendo mi potencial de aprendizaje 8 - 10',
42 + 'pot_population_id' => 2, //8-10
43 + 'pot_source_id' => 1, //Estudiante
44 + 'created_at' => now(),
45 + 'updated_at' => now(),
46 + ]);
47 +
48 + DB::table('pot_instruments')->insert([
49 + 'name' => 'Reconociendo mi potencial de aprendizaje 11 - 17',
50 + 'pot_population_id' => 3, //11-17
51 + 'pot_source_id' => 1, //Estudiante
52 + 'created_at' => now(),
53 + 'updated_at' => now(),
54 + ]);
55 +
56 + DB::table('pot_instruments')->insert([
57 + 'name' => 'Reconociendo en familia el potencial de aprendizaje 8 - 17',
58 + 'pot_population_id' => 2, //8-10
59 + 'pot_source_id' => 3, //Familiar
60 + 'created_at' => now(),
61 + 'updated_at' => now(),
62 + ]);
63 +
64 + DB::table('pot_instruments')->insert([
65 + 'name' => 'Reconociendo el potencial de aprendizaje de mis estudiantes 8 - 17',
66 + 'pot_population_id' => 3, //11-17
67 + 'pot_source_id' => 2, //Docente
68 + 'created_at' => now(),
69 + 'updated_at' => now(),
70 + ]);

https://gitlab.com/guille.agudelo/apptalento/-/commit/3ab78d1e13dba09daa827627011185cffbc4c55b 7/12
1/8/2020 Tablas Modulo Creación de questionarios (3ab78d1e) · Commits · Guillermo Agudelo / apptalento · GitLab

71 + }
72 +
73 + /**
74 + * Reverse the migrations.
75 + *
76 + * @return void
77 + */
78 + public function down()
79 + {
80 + Schema::dropIfExists('pot_instruments');
81 + }
82 +}

  database/migrations/2020_07_21_182109_create_pot_question_ponderations_table.php 0 → 100644

1 + <?php
2 +
3 + use Illuminate\Database\Migrations\Migration;
4 + use Illuminate\Database\Schema\Blueprint;
5 + use Illuminate\Support\Facades\Schema;
6 +
7 + class CreatePotQuestionPonderationsTable extends Migration
8 +{
9 + /**
10 + * Run the migrations.
11 + *
12 + * @return void
13 + */
14 + public function up()
15 + {
16 + Schema::create('pot_question_ponderations', function (Blueprint $table) {
17 + $table->id();
18 + $table->integer('option');
19 + $table->integer('points');
20 + $table->foreignId('pot_source_id');
21 + $table->foreignId('pot_factor_id');
22 + $table->foreignId('pot_population_id');
23 + $table->timestamps();
24 + });
25 +
26 + //Interes, de 4-7, familiar
27 + DB::table('pot_question_ponderations')->insert([
28 + 'option' => 1,
29 + 'points' => 0,
30 + 'pot_source_id' => 3,
31 + 'pot_factor_id' => 1,
32 + 'pot_population_id' => 1,
33 + 'created_at' => now(),
34 + 'updated_at' => now(),
35 + ]);
36 +
37 + DB::table('pot_question_ponderations')->insert([
38 + 'option' => 2,
39 + 'points' => 4,
40 + 'pot_source_id' => 3,
41 + 'pot_factor_id' => 1,
42 + 'pot_population_id' => 1,
43 + 'created_at' => now(),
44 + 'updated_at' => now(),
45 + ]);
46 +
47 + DB::table('pot_question_ponderations')->insert([
48 + 'option' => 3,
49 + 'points' => 9,
50 + 'pot_source_id' => 3,
51 + 'pot_factor_id' => 1,
52 + 'pot_population_id' => 1,
53 + 'created_at' => now(),
54 + 'updated_at' => now(),
55 + ]);
56 +
57 + DB::table('pot_question_ponderations')->insert([
58 + 'option' => 4,
59 + 'points' => 13,
60 + 'pot_source_id' => 3,

https://gitlab.com/guille.agudelo/apptalento/-/commit/3ab78d1e13dba09daa827627011185cffbc4c55b 8/12
1/8/2020 Tablas Modulo Creación de questionarios (3ab78d1e) · Commits · Guillermo Agudelo / apptalento · GitLab

61 + 'pot_factor_id' => 1,
62 + 'pot_population_id' => 1,
63 + 'created_at' => now(),
64 + 'updated_at' => now(),
65 + ]);
66 +
67 + //Aptitud cognitiva, de 4 a 7, familiar
68 + DB::table('pot_question_ponderations')->insert([
69 + 'option' => 1,
70 + 'points' => 0,
71 + 'pot_source_id' => 3,
72 + 'pot_factor_id' => 2,
73 + 'pot_population_id' => 1,
74 + 'created_at' => now(),
75 + 'updated_at' => now(),
76 + ]);
77 +
78 + DB::table('pot_question_ponderations')->insert([
79 + 'option' => 2,
80 + 'points' => 3,
81 + 'pot_source_id' => 3,
82 + 'pot_factor_id' => 2,
83 + 'pot_population_id' => 1,
84 + 'created_at' => now(),
85 + 'updated_at' => now(),
86 + ]);
87 +
88 + DB::table('pot_question_ponderations')->insert([
89 + 'option' => 3,
90 + 'points' => 6,
91 + 'pot_source_id' => 3,
92 + 'pot_factor_id' => 2,
93 + 'pot_population_id' => 1,
94 + 'created_at' => now(),
95 + 'updated_at' => now(),
96 + ]);
97 +
98 + DB::table('pot_question_ponderations')->insert([
99 + 'option' => 4,
100 + 'points' => 10,
101 + 'pot_source_id' => 3,
102 + 'pot_factor_id' => 2,
103 + 'pot_population_id' => 1,
104 + 'created_at' => now(),
105 + 'updated_at' => now(),
106 + ]);
107 +
108 + //Interes, de 4-7, Docente
109 + DB::table('pot_question_ponderations')->insert([
110 + 'option' => 1,
111 + 'points' => 0,
112 + 'pot_source_id' => 2,
113 + 'pot_factor_id' => 1,
114 + 'pot_population_id' => 1,
115 + 'created_at' => now(),
116 + 'updated_at' => now(),
117 + ]);
118 +
119 + DB::table('pot_question_ponderations')->insert([
120 + 'option' => 2,
121 + 'points' => 4,
122 + 'pot_source_id' => 2,
123 + 'pot_factor_id' => 1,
124 + 'pot_population_id' => 1,
125 + 'created_at' => now(),
126 + 'updated_at' => now(),
127 + ]);
128 +
129 + DB::table('pot_question_ponderations')->insert([
130 + 'option' => 3,
131 + 'points' => 9,
132 + 'pot_source_id' => 2,
133 + 'pot_factor_id' => 1,
134 + 'pot_population_id' => 1,
135 + 'created_at' => now(),

https://gitlab.com/guille.agudelo/apptalento/-/commit/3ab78d1e13dba09daa827627011185cffbc4c55b 9/12
1/8/2020 Tablas Modulo Creación de questionarios (3ab78d1e) · Commits · Guillermo Agudelo / apptalento · GitLab

136 + 'updated_at' => now(),

137 + ]);
138 +
139 + DB::table('pot_question_ponderations')->insert([
140 + 'option' => 4,
141 + 'points' => 13,
142 + 'pot_source_id' => 2,
143 + 'pot_factor_id' => 1,
144 + 'pot_population_id' => 1,
145 + 'created_at' => now(),
146 + 'updated_at' => now(),
147 + ]);
148 +
149 + //Interes, de 8-10, Estudiante
150 + DB::table('pot_question_ponderations')->insert([
151 + 'option' => 1,
152 + 'points' => 0,
153 + 'pot_source_id' => 1,
154 + 'pot_factor_id' => 1,
155 + 'pot_population_id' => 2,
156 + 'created_at' => now(),
157 + 'updated_at' => now(),
158 + ]);
159 +
160 + DB::table('pot_question_ponderations')->insert([
161 + 'option' => 2,
162 + 'points' => 4,
163 + 'pot_source_id' => 1,
164 + 'pot_factor_id' => 1,
165 + 'pot_population_id' => 2,
166 + 'created_at' => now(),
167 + 'updated_at' => now(),
168 + ]);
169 +
170 + DB::table('pot_question_ponderations')->insert([
171 + 'option' => 3,
172 + 'points' => 9,
173 + 'pot_source_id' => 1,
174 + 'pot_factor_id' => 1,
175 + 'pot_population_id' => 2,
176 + 'created_at' => now(),
177 + 'updated_at' => now(),
178 + ]);
179 +
180 + DB::table('pot_question_ponderations')->insert([
181 + 'option' => 4,
182 + 'points' => 13,
183 + 'pot_source_id' => 1,
184 + 'pot_factor_id' => 1,
185 + 'pot_population_id' => 2,
186 + 'created_at' => now(),
187 + 'updated_at' => now(),
188 + ]);
189 + }
190 +
191 + /**
192 + * Reverse the migrations.
193 + *
194 + * @return void
195 + */
196 + public function down()
197 + {
198 + Schema::dropIfExists('pot_question_ponderations');
199 + }
200 +}

  database/migrations/2020_07_21_184638_create_pot_indicators_table.php 0 → 100644

1 + <?php
2 +
3 + use Illuminate\Database\Migrations\Migration;
4 + use Illuminate\Database\Schema\Blueprint;
5 + use Illuminate\Support\Facades\Schema;
6 +
7 + class CreatePotIndicatorsTable extends Migration

https://gitlab.com/guille.agudelo/apptalento/-/commit/3ab78d1e13dba09daa827627011185cffbc4c55b 10/12
1/8/2020 Tablas Modulo Creación de questionarios (3ab78d1e) · Commits · Guillermo Agudelo / apptalento · GitLab

8 +{
9 + /**
10 + * Run the migrations.
11 + *
12 + * @return void
13 + */
14 + public function up()
15 + {
16 + Schema::create('pot_indicators', function (Blueprint $table) {
17 + $table->id();
18 + $table->string('name');
19 + $table->foreignId('pot_factor_id');
20 + $table->timestamps();
21 + });
22 +
23 + //Interes
24 + DB::table('pot_indicators')->insert([
25 + 'name' => 'DESTINACIÓN DE TIEMPO',
26 + 'pot_factor_id' => 1
27 + ]);
28 + DB::table('pot_indicators')->insert([
29 + 'name' => 'OBSTINACIÓN',
30 + 'pot_factor_id' => 1
31 + ]);
32 + DB::table('pot_indicators')->insert([
33 + 'name' => 'PERSEVERANCIA – TENACIDAD',
34 + 'pot_factor_id' => 1
35 + ]);
36 + DB::table('pot_indicators')->insert([
37 + 'name' => 'CURIOSIDAD',
38 + 'pot_factor_id' => 1
39 + ]);
40 + DB::table('pot_indicators')->insert([
41 + 'name' => 'GOCE',
42 + 'pot_factor_id' => 1
43 + ]);
44 + DB::table('pot_indicators')->insert([
45 + 'name' => 'LABORIOSIDAD',
46 + 'pot_factor_id' => 1
47 + ]);
48 +
49 + //Aptitud cognitiva
50 + DB::table('pot_indicators')->insert([
51 + 'name' => 'FACILIDAD PARA RECORDAR',
52 + 'pot_factor_id' => 2
53 + ]);
54 + DB::table('pot_indicators')->insert([
55 + 'name' => 'EXPRESIÓN FLUIDA',
56 + 'pot_factor_id' => 2
57 + ]);
58 + DB::table('pot_indicators')->insert([
59 + 'name' => 'RAZONAMIENTO INDUCTIVO',
60 + 'pot_factor_id' => 2
61 + ]);
62 + DB::table('pot_indicators')->insert([
63 + 'name' => 'RAZONAMIENTO DEDUCTIVO',
64 + 'pot_factor_id' => 2
65 + ]);
66 + DB::table('pot_indicators')->insert([
67 + 'name' => 'FACILIDAD PARA COMPRENDER',
68 + 'pot_factor_id' => 2
69 + ]);
70 +
71 + //Habilidad
72 + DB::table('pot_indicators')->insert([
73 + 'name' => 'PROYECCIÓN - PLANIFICACIÓN',
74 + 'pot_factor_id' => 3
75 + ]);
76 + DB::table('pot_indicators')->insert([
77 + 'name' => 'INGENIO',
78 + 'pot_factor_id' => 3
79 + ]);
80 + DB::table('pot_indicators')->insert([
81 + 'name' => 'CREATIVIDAD',
82 + 'pot_factor_id' => 3

https://gitlab.com/guille.agudelo/apptalento/-/commit/3ab78d1e13dba09daa827627011185cffbc4c55b 11/12
1/8/2020 Tablas Modulo Creación de questionarios (3ab78d1e) · Commits · Guillermo Agudelo / apptalento · GitLab

83 + ]);
84 + DB::table('pot_indicators')->insert([
85 + 'name' => 'EXCELENCIA',
86 + 'pot_factor_id' => 3
87 + ]);
88 + DB::table('pot_indicators')->insert([
89 + 'name' => 'FLUIDEZ - CAPACIDAD',
90 + 'pot_factor_id' => 3
91 + ]);
92 +
93 + //Precocidad
94 + DB::table('pot_indicators')->insert([
95 + 'name' => 'DESARROLLO AVANZADO Y PRECOZ',
96 + 'pot_factor_id' => 4
97 + ]);
98 +
99 + }
100 +
101 + /**
102 + * Reverse the migrations.
103 + *
104 + * @return void
105 + */
106 + public function down()
107 + {
108 + Schema::dropIfExists('pot_indicators');
109 + }
110 +}

Write a comment or drag your files here…

Markdown and quick actions are supported

https://gitlab.com/guille.agudelo/apptalento/-/commit/3ab78d1e13dba09daa827627011185cffbc4c55b 12/12