宜博 / vokoworld

const tableName = 'vk_task_acceptance_items'

function buildTable(t) {
  t.string('task_id', 64).notNullable()
  t.string('item_key', 32).notNullable()
  t.tinyint('ordinal').unsigned().notNullable()
  t.string('text', 1000).notNullable()
  t.primary(['task_id', 'item_key'])
  t.unique(['task_id', 'ordinal'], { indexName: 'uq_vk_task_acceptance_items_ordinal' })
  t.check('ordinal between 1 and 5', [], 'ck_vk_task_acceptance_items_ordinal')
}

module.exports = { tableName, buildTable }