/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('ads_catalogo_atrs', function (Blueprint $table) {
$table->string('id_cat_atr') . primary();
$table->string('ads_tipo_recoleccion');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('ads_atr_tipo_recoleccions', function (Blueprint $table) {
$table->string('id_ads_atr') . primary();
$table->string('id_cat_atr');
$table->date('ads_fecha_inicio');
$table->date('ads_fecha_fin');
$table->foreign('id_cat_atr')->references('id_cat_atr')->on('ads_catalogo_atr');
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('ads_resoluciones', function (Blueprint $table) {
$table->string('id_ads_resoluciones') . primary();
$table->string('ads_resolcuion_solicitud');
$table->string('id_ads_atr');
$table->string('id_ads_acr');
$table->foreign('id_ads_atr')->references('id_ads_atr')->on('ads_atr_tipo_recoleccion');
$table->foreign('id_ads_acr')->references('id_ads_acr')->on('ads_acr_recollecion');
});
}
