Spaces:
Sleeping
Sleeping
| from sqlalchemy import Column, ForeignKey, Boolean, Float, String | |
| from sqlalchemy.dialects.postgresql import UUID | |
| from geoalchemy2 import Geography | |
| from app.core.database import Base | |
| class Driver(Base): | |
| __tablename__ = 'drivers' | |
| user_id = Column(UUID(as_uuid=True), ForeignKey('profiles.id', ondelete='CASCADE'), primary_key=True) | |
| license_no = Column(String, nullable=False) | |
| vehicle_make = Column(String) | |
| vehicle_model = Column(String) | |
| vehicle_plate = Column(String) | |
| is_online = Column(Boolean, default=False) | |
| rating = Column(Float, default=5.0) | |
| current_location = Column(Geography('POINT', srid=4326)) | |