Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create schema for plan processing status table #132

Open
Tracked by #853
Rkareko opened this issue Aug 30, 2021 · 0 comments
Open
Tracked by #853

Create schema for plan processing status table #132

Rkareko opened this issue Aug 30, 2021 · 0 comments
Assignees

Comments

@Rkareko
Copy link
Contributor

Rkareko commented Aug 30, 2021

Create core.plan_processing_status with the following fields :-

Id id
Plan Id FK plan_id (nullable)
Event Id FK event_id (not null)
Template Id FK template_id (Points to core.templates.identifier) (not null)
Status status ( (null|initial - 0) | processing - 1 | complete 2)
Here we can store it as a Postgres Enum. Should be expressive but still efficient as ints.
Date_created date_created timestamp (only on insert)
Last_updated date_updated timestamp (insert, update record)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant