smart_parking_erd
Tables (12)
Admin User (admin_users)
- Admin User ID (admin_user_id) — UUID, NOT NULL — Primary key — NOT NULL
- Email (email) — VARCHAR(100), NOT NULL, UNIQUE
- Name (name) — VARCHAR(50), NOT NULL
- Created At (created_at) — TIMESTAMP, NOT NULL, DEFAULT CURRENT_TIMESTAMP
- Updated At (updated_at) — TIMESTAMP, NOT NULL, DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Facility Metadata (facility_metadata)
- Parking Lot ID (parking_lot_id) — UUID, NOT NULL — Foreign key → Parking Lot.Parking Lot ID — NOT NULL
- Admin User ID (admin_user_id) — UUID, NOT NULL — Foreign key → Parking Lot.Admin User ID — NOT NULL
- Base Rate (base_rate) — INTEGER, NOT NULL
- Operationg Hours (operating_hours) — VARCHAR(20), NOT NULL
- Extra Info (extra_info) — TEXT
IoT Device (iot_device)
- Device ID (device_id) — UUID, NOT NULL — Primary key — NOT NULL
- Parking Lot ID (parking_lot_id) — UUID, NOT NULL — Foreign key → Parking Lot.Parking Lot ID — NOT NULL
- Model Name (model_name) — VARCHAR(50), NOT NULL
- Installed At (installed_at) — TIMESTAMP, NOT NULL, DEFAULT CURRENT_TIMESTAMP
IoT Status Log (iot_status_log)
- Log ID (log_id) — UUID, NOT NULL — Primary key — NOT NULL
- Device ID (device_id) — UUID, NOT NULL — Foreign key → IoT Device.Device ID — NOT NULL
- Status Message (status) — VARCHAR(50), NOT NULL
- Logged At (logged_at) — TIMESTAMP, NOT NULL, DEFAULT CURRENT_TIMESTAMP
Parking Availability (parking_availability)
- Parking Lot ID (parking_lot_id) — UUID, NOT NULL — Foreign key → Parking Lot.Parking Lot ID — NOT NULL
- Admin User ID (admin_user_id) — UUID, NOT NULL — Foreign key → Parking Lot.Admin User ID — NOT NULL
- Available Spaces (available_spaces) — INTEGER, NOT NULL
- Is Operating (is_operating) — BOOLEAN, NOT NULL, DEFAULT FALSE
- Last Updated (last_updated) — TIMESTAMP, NOT NULL, DEFAULT CURRENT_TIMESTAMP
Parking History (parking_historie)
- History ID (history_id) — UUID, NOT NULL — Primary key — NOT NULL
- User ID (user_id) — UUID, NOT NULL — Foreign key → User.User ID — NOT NULL
- Vehicle ID (vehicle_id) — UUID, NOT NULL — Foreign key → Vehicle.Vehicle ID — NOT NULL
- Parking Lot ID (parking_lot_id) — UUID, NOT NULL — Foreign key → Parking Lot.Parking Lot ID — NOT NULL
- Admin User ID (admin_user_id) — UUID, NOT NULL — Foreign key → Parking Lot.Admin User ID — NOT NULL
- Entry Time (entry_time) — TIMESTAMP, NOT NULL
- Exit Time (exit_time) — TIMESTAMP, NOT NULL
- Duration (Minutes) (duration_miutes) — INTEGER, NOT NULL
- Fee (fee) — INTEGER, NOT NULL
Parking Lot (parking_lot)
- Parking Lot ID (parking_lot_id) — UUID, NOT NULL — Primary key — NOT NULL
- Admin User ID (admin_user_id) — UUID, NOT NULL — Foreign key → Admin User.Admin User ID — NOT NULL
- Name (name) — VARCHAR(100), NOT NULL
- Address (address) — TEXT, NOT NULL, UNIQUE
- Capacity (capacity) — INTEGER, NOT NULL
- Is Public (is_public) — BOOLEAN, DEFAULT FALSE
- Has EV Charging (has_ev) — BOOLEAN, DEFAULT FALSE
- Created At (created_at) — TIMESTAMP, NOT NULL, DEFAULT CURRENT_TIMESTAMP
- Updated At (updated_at) — TIMESTAMP, NOT NULL, DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Parking Pass (passe)
- Pass ID (pass_id) — UUID, NOT NULL — Primary key — NOT NULL
- User ID (user_id) — UUID, NOT NULL — Foreign key → User.User ID — NOT NULL
- Vehicle ID (vehicle_id) — UUID, NOT NULL — Foreign key → Vehicle.Vehicle ID — NOT NULL
- Parking Lot ID (parking_lot_id) — UUID, NOT NULL — Foreign key → Parking Lot.Parking Lot ID — NOT NULL
- Admin User ID (admin_user_id) — UUID, NOT NULL — Foreign key → Parking Lot.Admin User ID — NOT NULL
- Pass Type (pass_type) — VARCHAR(20), NOT NULL
- Valid From (valid_from) — TIMESTAMP, NOT NULL
- Valid Until (valid_until) — TIMESTAMP, NOT NULL
- Issued At (issud_at) — TIMESTAMP, NOT NULL, DEFAULT CURRENT_TIMESTAMP
Parking Score Weight (parking_score_weight)
- Parking Lot ID (parking_lot_id) — UUID, NOT NULL — Foreign key → Parking Lot.Parking Lot ID — NOT NULL
- Admin User ID (admin_user_id) — UUID, NOT NULL — Foreign key → Parking Lot.Admin User ID — NOT NULL
- Price Weight (price_weight) — FLOAT, NOT NULL
- Distance Weight (distance_weight) — FLOAT, NOT NULL
- Congestion Weight (congestion_weight) — FLOAT, NOT NULL
- Field
Payment (payments)
- Payment ID (payment_id) — UUID, NOT NULL — Primary key — NOT NULL
- User ID (user_id) — UUID, NOT NULL — Foreign key → User.User ID — NOT NULL
- Vehicle ID (vehicle_id) — UUID, NOT NULL — Foreign key → Vehicle.Vehicle ID — NOT NULL
- Pass ID (pass_id) — UUID, NOT NULL — Foreign key → Parking Pass.Pass ID — NOT NULL
- Parking Lot ID (parking_lot_id) — UUID, NOT NULL — Foreign key → Parking Pass.Parking Lot ID — NOT NULL
- Admin User ID (admin_user_id) — UUID, NOT NULL — Foreign key → Parking Pass.Admin User ID — NOT NULL
- Amount (amoun) — INTEGER, NOT NULL
- Paid At (paid_at) — TIMESTAMP, NOT NULL, DEFAULT CURRENT_TIMESTAMP
- Status (status) — VARCHAR(10), NOT NULL
User (user)
- User ID (user_id) — UUID, NOT NULL — Primary key — NOT NULL
- Email (email) — VARCHAR(100), UNIQUE, NOT NULL
- Password (password) — VARCHAR(255), NOT NULL
- Name (name) — VARCHAR(50) NOT NULL
- Social Type (social_type) — VARCHAR(20), NOT NULL
- Created At (created_at) — TIMESTAMP, NOT NULL, DEFAULT CURRENT_TIMESTAMP
- Updated At (updated_at) — TIMESTAMP, NOT NULL, DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Vehicle (vehicle)
- Vehicle ID (vehicle_id) — UUID, NOT NULL — Primary key — NOT NULL
- User ID (user_id) — UUID, NOT NULL — Foreign key → User.User ID — NOT NULL
- Vehicle Number (vehicle_number) — VARCHAR(20), NOT NULL
- Is Default (is_default) — BOOLEAN, DEFAULT FALSE
- Created At (created_at) — TIMESTAMP, NOT NULL, DEFAULT CURRENT_TIMESTAMP
- Updated At (updated_at) — TIMESTAMP, NOT NULL, DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP