Squidhead

Convention Reference

Column Conventions
These conventions deal with names of columns, and what happens when you use them
CreatedOn (datetime)
  • Value set automatically
  • Will be set only in the create method.
  • Will be set to current_timestamp in the database.
  • Input will not bubble up to the user.
UpdatedOn (datetime)
  • Value set automatically
  • Will be set to current_timestamp in the database.
  • Input will not bubble up to the user.
CreatedBy
  • Will be set only in the create method.
Active (bit)
  • Will not bubble up to the user in input or output.
  • Will make delete work by deactivating records instead of deleting them from table.
Table Conventions
These conventions deal with names of tables, and what happens when you use them
tableToTable
If you do a pass through join through a table named tablenameToOtherTableName, Squidhead will create a stored proc that will join through the middle table.