GYMbackend

Tables (7)

Equipment (Untitled5)

  • equipment id (EQUIPMENT_ID) — AI — Primary key — NOT NULL
  • GymID (GYM_ID) — AI — Foreign key → Gym.GymID — NOT NULL
  • name (NAME) — INT
  • quantity (QUANTITY) — INT

Gym (Untitled2)

  • GymID (GYM_ID) — AI — Primary key — NOT NULL
  • name (GYM_NAME) — BARCHAR(50)
  • rate — FLOAT
  • quantity equipment (QUANTITY_EQUIPMENT) — INT

RefreshToken (Untitled7)

  • refresh id (REFRESH_ID) — AI — Primary key — NOT NULL
  • user email (USER_EMAIL) — VARCHAR(30) — Foreign key → User.user email — NOT NULL
  • token (TOKEN) — BARCHAR(50)

Rental Item (Untitled6)

  • rental item id (RENTAL_ITEM_ID) — AI — Primary key — NOT NULL
  • GymID (GYM_ID) — AI — Foreign key → Gym.GymID — NOT NULL
  • name (NAME) — VARCHAR(20)
  • quantity (QUANTITY) — INT

ReviewGYM (Untitled4)

  • review id (Review_ID) — ai — Primary key — NOT NULL
  • GymID (GYM_ID) — AI — Foreign key → Gym.GymID — NOT NULL
  • rating (RATING) — FLOAT
  • Field (CONTENT) — VARCHAR(200)
  • created at (CREATED_AT) — DATE

User (Untitled)

  • user email (USER_EMAIL) — VARCHAR(30) — Primary key — NOT NULL
  • password (PASSWORD) — VARCHAR(30)
  • grade (GRADE) — INT

User_Gym_Registeration (Untitled3)

  • register_id (REGISTER_ID) — AI — Primary key — NOT NULL
  • user email (USER_EMAIL) — VARCHAR(30) — Foreign key → User.user email — NOT NULL
  • GymID (GYM_ID) — AI — Foreign key → Gym.GymID — NOT NULL