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