StudyHive
Tables (7)
Amenity (CopyOfUntitled6)
- amenity_id (PK) — AUTO_INCREMENT, NOT NULL — Primary key — NOT NULL
- name (VARCHAR) — NOT NULL
Check_Ins (Untitled3)
- checkin_id (PK) — AUTOINCREMENT, NOT NULL — Primary key — NOT NULL
- user_id (FK) — NOT NULL
- space_id (FK->StudySpaces) — NOT NULL
- checkin_time (Field2) — DEFAULT CURRENT_TIMESTAMP
- user_id (PK2) — AUTO_INCREMENT, NOT NULL — Foreign key → Users.user_id — NOT NULL
Feedback (Untitled5)
- feedback_id (PK) — NOT NULL — Primary key — NOT NULL
- user_id (PK2) — AUTO_INCREMENT, NOT NULL — Foreign key → Users.user_id — NOT NULL
- message (TEXT) — NOT NULL
- created_at (DATETIME) — DEFAULT CURRENT_TIMESTAMP
Reviews (Untitled4)
- review_id (PK) — AUTO_INCREMENT, NOT NULL — Primary key — NOT NULL
- user_id (FK->Users) — AUTO_INCREMENT, NOT NULL — Foreign key → Users.user_id — NOT NULL
- space_id (FK->StudySpaces) — AUTO_INCREMENT, NOT NULL — Foreign key → Study_Spaces.space_id — NOT NULL
- rating (INT) — NOT NULL
- comment (TEXT) — NULL
- created_at (DATETIME) — DEFAULT CURRENT_TIMESTAMP
StudySpace_Amenity (Untitled7)
- space_id (FK->StudySpace) — AUTO_INCREMENT, NOT NULL — Foreign key → Study_Spaces.space_id — NOT NULL
- amenity_id (PK) — AUTO_INCREMENT, NOT NULL — Foreign key → Amenity.amenity_id — NOT NULL
Study_Spaces (Untitled2)
- space_id (PK) — AUTO_INCREMENT, NOT NULL — Primary key — NOT NULL
- checkin_id (PK2) — AUTOINCREMENT, NOT NULL — Foreign key → Check_Ins.checkin_id — NOT NULL
- name (Field) — NOT NULL
- location (Field2) — NOT NULL
- space_type (Field3) — NOT NULL
- hours_open (Field5) — NOT NULL
- peak_hours (Field6) — NOT NULL
- rating_avg (Field7) — NOT NULL
Users (Untitled)
- user_id (PK) — AUTO_INCREMENT, NOT NULL — Primary key — NOT NULL
- username (VARCHAR(100)) — UNIQUE, NOT NULL
- name (Field) — NOT NULL
- email (Field2) — UNIQUE, NOT NULL
- password (Field4) — NOT NULL
- avatar_url (Field5) — NULL
- role (Field6) — DEFAULT'student'