Skip to content

warn if a column (not a key) is present in more than one table #174

@ashleyasmus

Description

@ashleyasmus

I ran into this issue recently where participation_group was repeated in hh, person, day, trip and vehicle tables.

It really confused hts_summary -- it ended up choosing the lowest-grain table (trip) for summaries, so I ended up with wackadoo counts of each participation group level.

We should make sure that the tables fed to hts_data follow database design principles: unless a key column (IDs), no column should be repeated across tables.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions