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

Office Hours information storage #927

Open
amos-cha opened this issue Jun 20, 2023 · 0 comments
Open

Office Hours information storage #927

amos-cha opened this issue Jun 20, 2023 · 0 comments
Labels
3 Points To measure progress Enhancement

Comments

@amos-cha
Copy link
Contributor

amos-cha commented Jun 20, 2023

The problem with adding structured data is that the database we're updating has a simple VARCHAR(75) column for office hours, meaning we can only store simple text up to 75 characters.

We can discuss the possibility of storing more structured or meaningful data, since we're moving this to entirely within 360, but that's a bigger question that's probably outside the scope of this initial pull request.

Originally posted by @EjPlatzer in gordon-cs/gordon-360-ui#1871 (comment)

TLDR;

Faculty/Professor office hours are currently stored as VARCHAR(75) in SQL. This causes possible user errors which could be prevented if we had an organized/structured input. This would require a change in SQL, API, UI

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
3 Points To measure progress Enhancement
Projects
None yet
Development

No branches or pull requests

1 participant