multi-tenant

Tables (14)

Branch_Roles

  • branch_id — UUID — Primary key — NOT NULL
  • role_id — UUID — Primary key — NOT NULL

Branches

  • branch_id — UUID
  • tenant_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL

Dashboard_Widgets

  • dashboard_id — UUID — Primary key — NOT NULL
  • widget_id — UUID — Primary key — NOT NULL
  • layout_json — JSONB

Dashboards

  • dashboard_id — UUID
  • tenant_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT

Department_Roles

  • department_id — UUID — Primary key — NOT NULL
  • role_id — UUID — Primary key — NOT NULL

Departments

  • department_id — UUID
  • branch_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL

Pages

  • page_id — UUID
  • tenant_id — UUID
  • page_key — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • metadata_json — JSONB

Position_Roles

  • position_id — UUID — Primary key — NOT NULL
  • role_id — UUID — Primary key — NOT NULL

Positions

  • position_id — UUID
  • tenant_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL

Role_Permissions

  • permission_id — BIGSERIAL
  • role_id — UUID — NOT NULL
  • resource_type — VARCHAR(100) — NOT NULL
  • resource_key — VARCHAR(255) — NOT NULL
  • can_read — BOOLEAN — NOT NULL
  • can_edit — BOOLEAN — NOT NULL
  • can_create — BOOLEAN — NOT NULL
  • can_delete — BOOLEAN — NOT NULL
  • UNIQUE(role_id, — resource_type,

Roles

  • role_id — UUID
  • tenant_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT

Tenants

  • tenant_id — UUID
  • name — VARCHAR(255) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP

User_Roles

  • user_id — UUID — Primary key — NOT NULL
  • role_id — UUID — Primary key — NOT NULL

Users

  • user_id — UUID
  • tenant_id — UUID — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • branch_id — UUID
  • department_id — UUID
  • position_id — UUID
  • is_active — BOOLEAN
  • created_at — TIMESTAMP