parkgin

Tables (5)

car

  • car_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • license_plate — VARCHAR(20) — NOT NULL
  • registered_at — DATETIME

parking_history

  • history_id — BIGINT — Primary key — NOT NULL
  • car_id — BIGINT — Foreign key → car.car_id — NOT NULL
  • user_id — BIGINT — Foreign key → car.user_id — NOT NULL
  • parking_lot_id — BIGINT — Foreign key → parking_lot.parking_lot_id — NOT NULL
  • spot_id (spot_id2) — BIGINT — Foreign key → parking_spot.spot_id — NOT NULL
  • entry_time — DATETIME — NOT NULL
  • exit_time — DATETIME
  • total_fee — DECIMAL(10,2)
  • status — VARCHAR(20)

parking_lot

  • parking_lot_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • division — VARCHAR(50)
  • type — VARCHAR(50)
  • address — VARCHAR(255) — NOT NULL
  • capacity — INT
  • base_fee — DECIMAL(10,2)
  • fee_per_hour — DECIMAL(10,2)
  • created_at — DATETIME
  • updated_at — DATETIME

parking_spot

  • spot_id — BIGINT — Primary key — NOT NULL
  • parking_lot_id — BIGINT — Foreign key → parking_lot.parking_lot_id — NOT NULL
  • floor — VARCHAR(10) — NOT NULL
  • spot_code — VARCHAR(20) — NOT NULL
  • is_available — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

user

  • user_id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100)
  • phone — VARCHAR(20)
  • password — VARCHAR(255) — NOT NULL
  • role — ENUM('ADMIN', 'USER')
  • created_at — DATETIME
  • updated_at — DATETIME