<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateRainsDuplicateArticlesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('rains_duplicate_articles', function (Blueprint $table) {
            // 1.基本情報
            $table->increments('id');
            $table->integer('hold')->nullable();
            $table->bigInteger('company_id')->nullable();          // 企業コード
            $table->bigInteger('rains_no')->nullable();          // レインズ番号
            $table->integer('sale_no')->nullable();
            $table->integer('property')->required();          // 物件種別
            $table->integer('property_sub')->default(0);      // 新築・中古種別
            $table->string('name')->required();               // 物件名称
            $table->string('name_gouchi')->nullable();               // 物件名称
            $table->string('name_portal')->nullable();          // 物件名称（ポータル用）
            $table->string('occupied')->nullable();             // 未入居
            $table->string('revenue')->nullable();              // 収益物件
            $table->integer('status')->nullable();              // ステータス
            $table->integer('shop')->nullable();                // 物件取り扱い店舗
            $table->string('zip')->required();                // 郵便番号
            $table->integer('address1')->required();          // 都道府県
            $table->integer('address2')->required();          // 市区郡
            $table->integer('address3')->required();          // 町村
            $table->string('address4')->nullable();                         // その他住所
            $table->string('name_apartment')->nullable();                   // マンション名
            $table->integer('room_num')->required();
            $table->double('lat', 9, 6)->nullable();                        // 緯度
            $table->double('lng', 9, 6)->nullable();                        // 経度

            $table->integer('main_traffic')->nullable();                    // 主要交通
            $table->string('main_traffic_line')->nullable();                // 路線
            $table->integer('main_traffic_line_id')->nullable();                // 路線_id
            $table->string('main_traffic_station')->nullable();             // 駅名
            $table->integer('main_traffic_station_id')->nullable();                // 駅名_id
            $table->integer('main_traffic_time')->nullable();               // 徒歩時間
            $table->integer('main_traffic_bus_time')->nullable();           // バス乗車時間
            $table->string('main_traffic_bus')->nullable();                 // バス停
            $table->integer('main_traffic_bus_walk')->nullable();           // 徒歩時間
            
            $table->integer('sub_traffic1')->nullable();                    // 補助交通１
            $table->string('sub_traffic1_line')->nullable();                // 路線
            $table->integer('sub_traffic1_line_id')->nullable();                // 路線_id
            $table->string('sub_traffic1_station')->nullable();             // 駅名
            $table->integer('sub_traffic1_station_id')->nullable();                // 駅名_id
            $table->integer('sub_traffic1_time')->nullable();               // 徒歩時間
            $table->integer('sub_traffic1_bus_time')->nullable();           // バス乗車時間
            $table->string('sub_traffic1_bus')->nullable();                 // バス停
            $table->integer('sub_traffic1_bus_walk')->nullable();           // 徒歩時間
            
            $table->integer('sub_traffic2')->nullable();                    // 補助交通２
            $table->string('sub_traffic2_line')->nullable();                // 路線
            $table->integer('sub_traffic2_line_id')->nullable();                // 路線_id
            $table->string('sub_traffic2_station')->nullable();             // 駅名
            $table->integer('sub_traffic2_station_id')->nullable();                // 駅名_id
            $table->integer('sub_traffic2_time')->nullable();               // 徒歩時間
            $table->integer('sub_traffic2_bus_time')->nullable();           // バス乗車時間
            $table->string('sub_traffic2_bus')->nullable();                 // バス停
            $table->integer('sub_traffic2_bus_walk')->nullable();           // 徒歩時間

            $table->integer('primary_school_city')->nullable();             // 最寄り小学校学区
            $table->integer('primary_school_school')->nullable();           // 学校名
            $table->integer('primary_school_distance')->nullable();         // 距離
            $table->integer('secondary_school_city')->nullable();           // 最寄り中学校学区
            $table->integer('secondary_school_school')->nullable();         // 学校名
            $table->integer('secondary_school_distance')->nullable();       // 距離

            $table->text('memo1')->nullable();                               // 備考
            $table->text('memo2')->nullable();                               // 備考

            // ２.価格
            $table->double('price', 10, 1)->nullable();                     // 価格
            $table->integer('price_closing')->nullable();                       // 成約価格
            $table->integer('tax')->nullable();                             // 税込・税抜き

            $table->integer('council')->nullable();                         // 町会費種類
            $table->integer('council_presence')->nullable();                // 有無
            $table->integer('council_cost')->nullable();                    // 費用
            $table->integer('council_cost_unit')->nullable();               // 費用種類

            $table->integer('spring')->nullable();                          // 温泉
            $table->integer('spring_presence')->nullable();
            $table->integer('spring_cost')->nullable();
            $table->integer('spring_cost_unit')->nullable();
            $table->string('spring_kind')->nullable();

            $table->string('another_cost_name1')->nullable();               // その他諸経費
            $table->integer('another_cost1')->nullable();
            $table->integer('another_cost_unit1')->nullable();

            $table->string('another_cost_name2')->nullable();
            $table->integer('another_cost2')->nullable();
            $table->integer('another_cost_unit2')->nullable();

            //// 戸建
            $table->integer('broadcasting')->nullable();                    // 有線放送
            $table->integer('broadcasting_presence')->nullable();
            $table->integer('broadcasting_cost')->nullable();                    
            $table->integer('broadcasting_fixed_presence')->nullable();                
            $table->integer('broadcasting_fixed_cost')->nullable();                    
            $table->integer('broadcasting_fixed_cost_unit')->nullable();    
            
            $table->integer('internet')->nullable();                        // インターネット
            $table->integer('internet_presence')->nullable();
            $table->integer('internet_cost')->nullable();                    
            $table->integer('internet_fixed_presence')->nullable();                
            $table->integer('internet_fixed_cost')->nullable();                    
            $table->integer('internet_fixed_cost_unit')->nullable();   

            $table->integer('catv')->nullable();                            // ケーブルテレビ
            $table->integer('catv_presence')->nullable();
            $table->integer('catv_cost')->nullable();                    
            $table->integer('catv_fixed_presence')->nullable();                
            $table->integer('catv_fixed_cost')->nullable();                    
            $table->integer('catv_fixed_cost_unit')->nullable();  

            //// マンション
            $table->integer('total_unit')->nullable();
            $table->integer('age_year')->nullable();
            $table->integer('age_month')->nullable();
            $table->integer('construction')->nullable();
            $table->integer('construction_sub')->nullable();
            $table->integer('floor')->nullable();
            $table->integer('whereabouts')->nullable();
            $table->integer('underground')->nullable();
            $table->double('site_area', 5, 2)->nullable();
            $table->string('sales_company')->nullable();
            $table->string('construction_company')->nullable();
            $table->string('management_company')->nullable();
            $table->integer('management_form')->nullable();
            $table->integer('pet')->nullable();                            // ペット可不可
            $table->integer('pet_count')->nullable();                      // ペット最大数
            $table->text('overview_comment')->nullable(); 


            // 3.物件概要
            $table->integer('land_right')->nullable();                           // 土地面積
            $table->integer('land_area')->nullable();                           // 土地面積
            $table->double('land_area_val', 5, 2)->nullable();                  // 土地面積値

            $table->double('total_area_val', 5, 2)->nullable();                 // 延べ面積値
            
            $table->integer('land_condition1')->nullable();                     // 土地条件
            $table->double('land_condition_area1', 5, 2)->nullable();
            $table->integer('land_condition_unit1')->nullable();
            $table->integer('land_condition2')->nullable();
            $table->double('land_condition_area2', 5, 2)->nullable();
            $table->integer('land_condition_unit2')->nullable();
            $table->integer('land_condition3')->nullable();
            $table->double('land_condition_area3', 5, 2)->nullable();
            $table->integer('building_condition1')->nullable();
            $table->double('building_condition_area1', 5, 2)->nullable();
            $table->integer('building_condition2')->nullable();
            $table->double('building_condition_area2', 5, 2)->nullable();
            $table->integer('building_condition3')->nullable();
            $table->double('building_condition_area3', 5, 2)->nullable();
            $table->integer('building_condition4')->nullable();
            $table->integer('building_condition_select')->nullable();

            $table->integer('land_not')->nullable();                            // 建築不可

            $table->integer('land_status')->nullable();
            $table->integer('comp_year')->nullable();
            $table->integer('comp_month')->nullable();

            $table->integer('land_delivery')->nullable();
            $table->integer('delivery_year')->nullable();
            $table->integer('delivery_month')->nullable();
            $table->integer('land_delivery_time')->nullable();

            $table->integer('land_condition')->nullable();
            $table->integer('land_condition_not')->nullable();
            $table->integer('building_plan_place')->nullable();
            $table->double('building_plan_area', 5, 2)->nullable();

            $table->integer('ground')->nullable();
            $table->string('ground_text')->nullable();

            $table->double('building_rate', 5, 2)->nullable();
            $table->double('volume_rate', 5, 2)->nullable();

            $table->integer('road_burden')->nullable();
            $table->double('road_burden_area', 5, 2)->nullable();
            $table->double('road_numerator', 5, 2)->nullable();
            $table->double('road_denominator', 5, 2)->nullable();

            $table->integer('easement')->nullable();
            $table->double('easement_area', 5, 2)->nullable();

            $table->integer('land_kind1')->nullable();
            $table->integer('land_direction1')->nullable();
            $table->double('road_width1', 5, 2)->nullable();
            $table->double('frontage1', 5, 2)->nullable();

            $table->integer('land_kind2')->nullable();
            $table->integer('land_direction2')->nullable();
            $table->double('road_width2', 5, 2)->nullable();
            $table->double('frontage2', 5, 2)->nullable();

            $table->integer('land_kind3')->nullable();
            $table->integer('land_direction3')->nullable();
            $table->double('road_width3', 5, 2)->nullable();
            $table->double('frontage3', 5, 2)->nullable();

            $table->integer('water_supply')->nullable();
            $table->integer('sewerage')->nullable();
            $table->integer('gas')->nullable();
            $table->integer('garage')->nullable();

            $table->integer('set')->nullable();
            $table->double('set_area', 5, 2)->nullable();

            $table->integer('use_area')->nullable();
            $table->integer('land_use')->nullable();

            $table->integer('city_plan')->nullable();
            $table->integer('city_plan_reason')->nullable();
            $table->integer('section')->nullable();

            $table->integer('other_reason')->nullable();
            $table->text('other_comment')->nullable();

            //// 戸建
            $table->integer('rebuilding')->nullable();                              // 再建築不可

            $table->integer('building_area')->nullable();                           // 建物面積
            $table->double('building_area_val', 5, 2)->nullable();                  // 建物面積値
            $table->integer('underground_area')->nullable();                        // 建物条件_地下室
            $table->double('underground_area_val', 5, 2)->nullable();               // 建物条件_地下室値
            $table->integer('garage_area')->nullable();                             // 建物条件_車庫
            $table->double('garage_area_val', 5, 2)->nullable();                    // 建物条件_車庫値
            $table->integer('underground_garage_area')->nullable();                 // 建物条件_地下車庫
            $table->double('underground_garage_area_val', 5, 2)->nullable();        // 建物条件_地下車庫値
            $table->integer('residence_area')->nullable();                          // 建物条件_居住用途以外
            $table->integer('residence_area_val')->nullable();                      // 建物条件_居住用途以外値
            $table->integer('floor_plan')->nullable();                              // 間取り
            $table->integer('floor_plan_type')->nullable();                         // 間取り_タイプ

            
            $table->integer('completed_year')->nullable();
            $table->integer('completed_month')->nullable();
            $table->integer('completed_contract_month')->nullable();

            
            $table->integer('move_in')->nullable();
            $table->integer('move_in_year')->nullable();
            $table->integer('move_in_month')->nullable();
            $table->integer('move_in_contract_month')->nullable();

            $table->integer('current_status')->nullable();
            $table->integer('current_status_year')->nullable();
            $table->integer('current_status_month')->nullable();
            $table->integer('building_construction')->nullable();
            $table->integer('building_construction_sub')->nullable();
            $table->integer('ground_unit')->nullable();
            $table->integer('underground_unit')->nullable();
            $table->integer('parking')->nullable();
            $table->integer('parking_num')->nullable();
            $table->string('architecture_no')->nullable();

            $table->integer('exterior')->nullable();
            $table->integer('exterior_year')->nullable();
            $table->integer('exterior_month')->nullable();
            $table->integer('exterior_wall')->nullable();
            $table->integer('exterior_roof')->nullable();
            $table->integer('exterior_other')->nullable();
            $table->integer('exterior_text')->nullable();

            $table->integer('interior')->nullable();
            $table->integer('interior_year')->nullable();
            $table->integer('interior_month')->nullable();
            $table->integer('interior_kitchen')->nullable();
            $table->integer('interior_bathroom')->nullable();
            $table->integer('interior_toilet')->nullable();
            $table->integer('interior_wall')->nullable();
            $table->integer('interior_floor')->nullable();
            $table->integer('interior_all')->nullable();
            $table->integer('interior_other')->nullable();
            $table->integer('interior_text')->nullable();

            //// マンション


            // 4.投資・事業用
            $table->integer('classfication')->nullable();
            $table->integer('use_method')->nullable();
            $table->string('use_method_text')->nullable();

            $table->integer('trading_classfication')->nullable();
            $table->integer('business_status')->nullable();
            $table->integer('investment_status')->nullable();
            $table->integer('investment_performance')->nullable();
            $table->integer('investment_performance_unit')->nullable();
            $table->double('investment_interest', 5, 2)->nullable();


            // 5.取引情報
            $table->integer('own_company')->nullable();
            $table->integer('suumo')->nullable();
            $table->integer('homes')->nullable();
            $table->integer('athome')->nullable();
            $table->text('catchcopy')->nullable();
            $table->text('point')->nullable();
            $table->text('comment')->nullable();
            $table->integer('hp_charge')->nullable();

            // 7.イベント
            $table->integer('event_category')->nullable();
            $table->integer('event_schedule')->nullable();
            $table->string('event_day')->nullable();
            $table->date('from_event')->nullable();
            $table->date('to_event')->nullable();
            $table->integer('from_hour')->nullable();
            $table->integer('from_minute')->nullable();
            $table->integer('to_hour')->nullable();
            $table->integer('to_minute')->nullable();
            $table->integer('reservation')->nullable();
            $table->text('event_comment')->nullable();
            

            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('rains_duplicate_articles');
    }
}