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