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