butfit
Tables (5)
Booking (Untitled4)
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.id — NOT NULL
- class_id_id — INT — Foreign key → Class.id — NOT NULL
- created_at — datetime
- updated_at — datetime
BookingLog (Untitled5)
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.id — NOT NULL
- class_id_id — INT — Foreign key → Class.id — NOT NULL
- action — Varchar
- created_at — datetime
- updated_at — datetime
Class (Untitled2)
- id — Int — Primary key — NOT NULL
- name (Field3) — Varchar
- location — Varchar
- class_type (class type) — Varchar
- price — PositiveInt
- capacity — PositiveInt
- date — Date
- start_at (start time) — Datetime
- end_at (Field) — Datetime
Credit (Untitled3)
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.id — NOT NULL
- credit — Decimal
- expire_in — INT
User (Untitled)
- id — INT — Primary key — NOT NULL
- password — Varchar
- phone (phone nu,ber) — Varchar
- role (Field) — Varchar