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'