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