b3d

Tables (11)

company

  • id — UUID
  • name — VARCHAR — NOT NULL
  • company_type — VARCHAR — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

department

  • id — UUID
  • company_id — UUID — Foreign key → company.id — NOT NULL
  • name — VARCHAR — NOT NULL
  • sort_order — INT — NOT NULL

menu

  • id — UUID
  • name — VARCHAR — NOT NULL
  • sort_order — INT — NOT NULL

permission

  • id — UUID
  • role_id — UUID — Foreign key → role.id — NOT NULL
  • menu_id — UUID — Foreign key → menu.id — NOT NULL
  • can_read — BOOLEAN — NOT NULL
  • can_write — BOOLEAN — NOT NULL
  • can_edit — BOOLEAN — NOT NULL
  • can_delete — BOOLEAN — NOT NULL

position

  • id — UUID
  • company_id — UUID — Foreign key → company.id — NOT NULL
  • name — VARCHAR — NOT NULL
  • sort_order — INT — NOT NULL

role

  • id — UUID
  • company_id — UUID — Foreign key → company.id — NOT NULL
  • name — VARCHAR — NOT NULL

user

  • id — UUID
  • name — VARCHAR — NOT NULL
  • email — VARCHAR — NOT NULL
  • password — VARCHAR — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_company

  • id — UUID
  • user_id — UUID — Foreign key → user.id — NOT NULL
  • company_id — UUID — Foreign key → company.id — NOT NULL
  • position_id — UUID — Foreign key → position.id
  • department_id — UUID — Foreign key → department.id
  • role_id — UUID — Foreign key → role.id
  • joined_at — TIMESTAMP — NOT NULL
  • left_at — TIMESTAMP

user_login

  • id — UUID
  • user_id — UUID — Foreign key → user.id — NOT NULL
  • count — INT — NOT NULL
  • locked — BOOLEAN — NOT NULL
  • locked_at — TIMESTAMP
  • last_try_at — TIMESTAMP

user_private

  • id — UUID
  • user_id — UUID — Foreign key → user.id — NOT NULL
  • phone — VARCHAR
  • address — VARCHAR
  • account_number — VARCHAR
  • registration_number — VARCHAR

user_private_log

  • id — UUID
  • user_id — UUID — Foreign key → user.id — NOT NULL
  • viewer_id — UUID — Foreign key → user.id — NOT NULL
  • viewed_at — TIMESTAMP — NOT NULL