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