test

Tables (6)

Roles (roles)

  • id — uuid — Primary key — NOT NULL
  • role_name (Field) — string — manager, admin, employee

Staff (users)

  • id — uuid — Primary key — NOT NULL
  • store_id — uuid — Foreign key → store.id — NOT NULL
  • name — string
  • address — string
  • created_at — timestamp
  • updatd_at (updated_at) — timestamp
  • Field (password)

Users

  • id — uuid — Primary key — NOT NULL
  • name — string
  • address — string
  • created_at — timestamp
  • updatd_at (updated_at) — timestamp
  • Field (password)

bookings

  • id — uid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → Users.id — NOT NULL
  • id (store_id) — uuid — Foreign key → store.id — NOT NULL
  • refrence_id — string
  • booking_date — timestamp
  • total_amount — numeric
  • Field

store (Untitled)

  • id — uuid — Primary key — NOT NULL
  • store_name (Field)

user_roles

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → Staff.id — NOT NULL
  • role_id — uuid — Foreign key → Roles.id — NOT NULL