in query knex code example
Example 1: knex datatypes
table.increments('id')
table.string('account_name')
table.integer('age')
table.float('age')
table.decimal('balance', 8, 2)
table.boolean('is_admin')
table.date('birthday')
table.time('created_at')
table.timestamp('created_at').defaultTo(knex.fn.now())
table.json('profile')
table.jsonb('profile')
table.uuid('id').primary()
Example 2: knexjs execute all migrations
$ knex migrate:make create_users_table
$ knex migrate:make create_tasks_table