Skip to content

Add ORM tables models #7

@Timelessprod

Description

@Timelessprod

Add SqlAlchemy ORM classes for 2 tables:

  • vehicles:

    • id: UUID
    • trip_id: STRING
    • line_product: ENUM(bus, subway, tram, suburban, ferry, express, regional)
    • line_name: STRING
    • partition_dt: DATE
  • vehicle_positions:

    • vehicle_id: FOREIGN KEY on Vehicle
    • timestamp: TIMESTAMP
    • latitude: DECIMAL
    • longitude: DECIMAL
    • partition_dt: DATE

Both tables should be partitioned by day on the partition_dt column and have relationships to enable back population and cascade deletions.

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions