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