Stevia

Tables (7)

admin (/admins)

  • id (PK) — UUID — Primary key — NOT NULL
  • admin_id (Field) — varchar
  • password (Field2) — varchar

asd (Untitled)

  • Key — Primary key — NOT NULL
  • Field

building (/buildings)

  • id (PK) — UUID — Primary key — NOT NULL
  • location (Field) — varchar
  • name (Field2) — varchar

key (/keys)

  • id (PK) — UUID — Primary key — NOT NULL
  • room_id (PK2) — UUID — Foreign key → room.id — NOT NULL
  • status (Field) — boolean
  • rental_time (Field2) — timestamp

reservation (/reservations)

  • id (PK) — UUID — Primary key — NOT NULL
  • usage_time (Field) — varchar
  • reserve_time (Field2) — timestamp
  • user_id (FK) — UUID — Foreign key → user.id — NOT NULL
  • room_id (FK2) — UUID — Foreign key → room.id — NOT NULL

room (/rooms)

  • id (PK) — UUID — Primary key — NOT NULL
  • room_no (Field) — integer
  • image (Field2) — text
  • building_id (FK) — UUID — Foreign key → building.id — NOT NULL

user (/users)

  • id (PK) — UUID — Primary key — NOT NULL
  • student_id (Field) — integer
  • password (Field2) — varchar
  • name (Field3) — varchar
  • department (Field4) — varchar
  • phone_no (Field5) — varchar
  • email (Field6) — varchar