profile_schema.js

const Schema = use('Schema');

class ProfileSchema extends Schema {
    up () {
        this.create('profiles', (table) => {
            table.increments();
            table.integer('user_id')
                .unsigned()
                .references('id')
                .inTable('users')
                .notNullable();
            table.string('name', 254);
            table.string('surname', 254);
            table.string('patronymic', 254);
            table.date('date_of_birth');
            table.timestamps();
        });
    }

    down () {
        this.drop('profiles');
    }
}

module.exports = ProfileSchema;