# Laravel database migrations The PHP framework Laravel has a concept of *migrations* where the developer can programmatically create database tables. A typical file looks something like this: increments('id'); $table->string('name'); $table->string('email')->unique(); $table->timestamp('email_verified_at')->nullable(); $table->string('password'); $table->rememberToken(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('users'); } } By harvesting ~300K such files from github this dataset was created with the purpose of analyzing the datatypes used and naming conventions. ## Columns * user: the github username * repo: the repository name * filename: the filename * table: the table to be created extracted from Schema::create('table_name' ... * column_data_type: column data type extracted from $table->string('name'); * column_name: column name extracted from $table->string('name'); ## Resources The data was harvested using [this repo][1] and transformed using [this repo][2]. Obviously the metadata harvested does not capture much, but it's a start. A dump of *original* files (starting from Laravel 5+) can be found [here][3]. ## Thank you Thanks to all the kaggle inspirers and especially @brainmaniac. Please share your ideas on how to improve or expand this dataset (it's my first). [1]: https://github.com/ajthinking/github-selective-scraper [2]: https://github.com/ajthinking/migration-analysis [3]: https://drive.google.com/open?id=1e9Dnr17XXRCRl5E7dv-i-4sxemCqhssB