User database table

[TechnicalParadox]

Columns

• 'id' - str, notNull, primaryKey (npm uniqid)
• 'username' - str, notNull, validate{ len:[1] }
• 'password_hash' - str, notNull, validate{ len:[1] } (npm bcrypt)
• 'level' - int, notNull, validate{ int } // 0 = normal user, can post, delete comments they own, etc. || 1 = posting privileges, can post new attractions, inherit any lower privileges || 2 = admin, can CRUD Types, can CRUD Categories, can delete any comments, inherit any lower privileges when checking if user is able to do the action they are trying to do, we can do something like this switch (without breaks) so that upper levels inherit the abilities below them:

  switch (user.level)
  {
  case 2:
  //allow admin
  case 1:
  //allow posting
  case 0:
  //allow post/delete comment
  }