DB documentation

Database naming

When building new components, data structures you should follow

• fields in js, sql , csharp should be unique across application, for example use account_name instead name
• all database fields lowercase for example account_billing_street
• standard database filed set in each table (replace task with table name)
  • task_status int
  • task_created_at smalldatetime
  • task_created_by varchar(50)
  • task_modified_at smalldatetime
  • task_modified_by varchar(50)