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