Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function up()
- {
- Schema::create('pacient', function (Blueprint $table) {
- $table->increments('id')->primary();
- $table->string('meno');
- $table->string('preizvisko');
- $table->string('rodne_cislo');
- $table->date('datum_narodenia');
- $table->integer('telefonne_cislo');
- $table->string('email');
- $table->string('pohlavie');
- $table->integer('vek');
- $table->string('povolanie');
- $table->string('stomatolog');
- $table->timestamps();
- });
- }
- /**
- * Reverse the migrations.
- *
- * @return void
- */
- public function down()
- {
- Schema::drop('pacient');
- }
- //===============================================================================
- public function up()
- {
- Schema::create('adresa', function (Blueprint $table) {
- $table->increments('id');
- $table->unsignedInteger('pacient_id');
- $table->string('ulica');
- $table->integer('cislo');
- $table->integer('psc');
- $table->string('mesto');
- $table->string('krajina');
- $table->foreign('pacient_id')->references('id')->on('pacient')->onDelete('cascade');
- });
- }
- /**
- * Reverse the migrations.
- *
- * @return void
- */
- public function down()
- {
- Schema::drop('adresa');
- }
- //===============================================================================
- public function up()
- {
- Schema::create('dovod_konzultacie', function (Blueprint $table) {
- $table->increments('id');
- $table->unsignedInteger('pacient_id');
- $table->boolean('estetika_zubov');
- $table->boolean('estetika_tvare');
- $table->boolean('odoslanie_zubarom');
- $table->boolean('tazkosti_celustnym_klbom');
- $table->boolean('priprava_na_implantaty');
- $table->boolean('predproteticka_priprava');
- $table->string('ine');
- $table->foreign('pacient_id')->references('id')->on('pacient')->onDelete('cascade');
- });
- }
- /**
- * Reverse the migrations.
- *
- * @return void
- */
- public function down()
- {
- Schema::drop('dovod_konzultacie');
- }
- //===============================================================================
- public function up()
- {
- Schema::create('info_zuboch', function (Blueprint $table) {
- $table->increments('id');
- $table->unsignedInteger('pacient_id');
- $table->boolean('strojcek');
- $table->string('podrobnosti_strojcek');
- $table->boolean('rodinny_strojcek');
- $table->string('podrobnosti_rodinny_strojcek');
- $table->boolean('uraz_zubov');
- $table->string('podrobnosti_uraz_zubov');
- $table->boolean('medzi_zubna_kefka');
- $table->boolean('medzi_zubna_nit');
- $table->boolean('zubna_prehliadka');
- $table->string('casto_prehliadky');
- $table->foreign('pacient_id')->references('id')->on('pacient')->onDelete('cascade');
- });
- }
- /**
- * Reverse the migrations.
- *
- * @return void
- */
- public function down()
- {
- Schema::drop('info_zuboch');
- }
- //===============================================================================
- public function up()
- {
- Schema::create('zlozviky', function (Blueprint $table) {
- $table->increments('id');
- $table->unsignedInteger('info_zuboch_id');
- $table->boolean('skripanie');
- $table->boolean('zatinanie_zubov');
- $table->boolean('dychanie_ustami');
- $table->boolean('cmulanie_prsta');
- $table->boolean('vsuvanie_dolnej_peri');
- $table->boolean('fajcenie');
- $table->boolean('ine');
- $table->boolean('nemam_zlozvyk');
- $table->foreign('info_zuboch_id')->references('id')->on('info_zuboch')->onDelete('cascade');
- });
- }
- /**
- * Reverse the migrations.
- *
- * @return void
- */
- public function down()
- {
- Schema::drop('zlozviky');
- }
- //===============================================================================
- public function up()
- {
- Schema::create('file_path', function (Blueprint $table) {
- $table->increments('id');
- $table->unsignedInteger('info_zuboch_id');
- $table->string('path');
- $table->foreign('info_zuboch_id')->references('id')->on('info_zuboch')->onDelete('cascade');
- });
- }
- /**
- * Reverse the migrations.
- *
- * @return void
- */
- public function down()
- {
- Schema::drop('file_path');
- }
- //===============================================================================
- public function up()
- {
- Schema::create('zdravotne_udaje', function (Blueprint $table) {
- $table->increments('id');
- $table->unsignedInteger('pacient_id');
- $table->boolean('nejake_ochorenie');
- $table->boolean('alergie');
- $table->string('ake_ochorenie');
- $table->boolean('lieky');
- $table->string('ake_lieky');
- $table->boolean('infekcie');
- $table->boolean('operacie');
- $table->boolean('tehotna');
- $table->boolean('kojite');
- $table->foreign('pacient_id')->references('id')->on('pacient')->onDelete('cascade');
- });
- }
- /**
- * Reverse the migrations.
- *
- * @return void
- */
- public function down()
- {
- Schema::drop('zdravotne_udaje');
- }
- //===============================================================================
- public function up()
- {
- Schema::create('alergie', function (Blueprint $table) {
- $table->increments('id');
- $table->unsignedInteger('zdravotne_udaje_id');
- $table->boolean('lieky');
- $table->boolean('kovy');
- $table->boolean('potraviny');
- $table->boolean('latex');
- $table->boolean('ine');
- $table->foreign('zdravotne_udaje_id')->references('id')->on('vsZdravotneUdaje')->onDelete('cascade');
- });
- }
- /**
- * Reverse the migrations.
- *
- * @return void
- */
- public function down()
- {
- Schema::drop('alergie');
- }
- //===============================================================================
- public function up()
- {
- Schema::create('infekcie', function (Blueprint $table) {
- $table->increments('id');
- $table->unsignedInteger('zdravotne_udaje_id');
- $table->boolean('hiv');
- $table->boolean('hepatitida_b');
- $table->boolean('hepatitida_c');
- $table->foreign('zdravotne_udaje_id')->references('id')->on('vsZdravotneUdaje')->onDelete('cascade');
- });
- }
- /**
- * Reverse the migrations.
- *
- * @return void
- */
- public function down()
- {
- Schema::drop('infekcie');
- }
- //===============================================================================
Add Comment
Please, Sign In to add comment