Business Objects

// defined by business-objects/ToDo.ejs
TABLE <%= schema %>.LISTS {
    id INTEGER
    list VARCHAR(256)

    Indexes {
        (id) [pk, name:"pk"]   
    }
}
      
TABLE <%= schema %>.TASKS {
    id INTEGER
    list_id INTEGER
    task VARCHAR(16)
    complete BOOLEAN
  
    Indexes {
        (id) [pk, name:"pk"]   
    }
}

The Hardhat sxt-utils environment now has a scope set to the two tables defined as LISTS and TASKS

For example, the following scopes can be set:

• npx hardhat sxt-utils:{action} --schema <schema> --businessobject ToDo

is the same as

• npx hardhat sxt-utils:{action} --schema <schema> --table lists,tasks

Individual tables can also be referenced

• npx hardhat sxt-utils:{action} --schema <schema> --table lists

or

• npx hardhat sxt-utils:{action} --schema <schema> --table tasks