laravel table data types

1$table->bigIncrements('id'); 	Incrementing ID using a "big integer" equivalent.
2$table->bigInteger('votes'); 	BIGINT equivalent to the table
3$table->binary('data'); 	BLOB equivalent to the table
4$table->boolean('confirmed'); 	BOOLEAN equivalent to the table
5$table->char('name', 4); 	CHAR equivalent with a length
6$table->date('created_at'); 	DATE equivalent to the table
7$table->dateTime('created_at'); 	DATETIME equivalent to the table
8$table->decimal('amount', 5, 2); 	DECIMAL equivalent with a precision and scale
9$table->double('column', 15, 8); 	DOUBLE equivalent with precision, 15 digits in total and 8 after the decimal point
10$table->enum('choices', array('foo', 'bar')); 	ENUM equivalent to the table
11$table->float('amount'); 	FLOAT equivalent to the table
12$table->increments('id'); 	Incrementing ID to the table (primary key).
13$table->integer('votes'); 	INTEGER equivalent to the table
14$table->longText('description'); 	LONGTEXT equivalent to the table
15$table->mediumInteger('numbers'); 	MEDIUMINT equivalent to the table
16$table->mediumText('description'); 	MEDIUMTEXT equivalent to the table
17$table->morphs('taggable'); 	Adds INTEGER taggable_id and STRING taggable_type
18$table->nullableTimestamps(); 	Same as timestamps(), except allows NULLs
19$table->smallInteger('votes'); 	SMALLINT equivalent to the table
20$table->tinyInteger('numbers'); 	TINYINT equivalent to the table
21$table->softDeletes(); 	Adds deleted_at column for soft deletes
22$table->string('email'); 	VARCHAR equivalent column
23$table->string('name', 100); 	VARCHAR equivalent with a length
24$table->text('description'); 	TEXT equivalent to the table
25$table->time('sunrise'); 	TIME equivalent to the table
26$table->timestamp('added_on'); 	TIMESTAMP equivalent to the table
27$table->timestamps(); 	Adds created_at and updated_at columns
28$table->rememberToken(); 	Adds remember_token as VARCHAR(100) NULL
29->nullable() 	Designate that the column allows NULL values
30->default($value) 	Declare a default value for a column
31->unsigned() 	Set INTEGER to UNSIGNED

1$table->dropForeign('posts_user_id_foreign');

1DB::statement("ALTER TABLE <table name> ADD <column name> MEDIUMBLOB");

1// in laravel if error of missing pdomysql driver issue the command
2// composer require doctrine/dbal
3DB::connection()->getDoctrineColumn($table_name, $field_name)->getType()->getName()