BanHang

Tables (4)

branch (Untitled3)

  • branchId (Key) — string — Primary key — NOT NULL
  • companyId (Key2) — string — Foreign key → company.companyId — NOT NULL
  • name (Field) — string
  • address (Field2) — string
  • phone (Field3) — string
  • isActive (Field4) — string

company (Untitled4)

  • companyId (Key) — string — Primary key — NOT NULL
  • name (Field) — string
  • subscriptionPlan (Field2) — string
  • expiredAt (Field3) — string

role (Untitled)

  • roleId (Key) — string — Primary key — NOT NULL
  • name — string
  • permisions (Field2) — array of string

user (Untitled2)

  • userId (Key) — string — Primary key — NOT NULL
  • companyId (Key22) — string — Foreign key → branch.companyId — NOT NULL
  • roleId (FK) — string — Foreign key → role.roleId — NOT NULL
  • branchId (Key2) — string — Foreign key → branch.branchId — NOT NULL
  • fullname (Field) — string
  • email (Field2) — string
  • password (Field3) — string
  • phone (Field4) — string
  • isActive (Field5) — boolean