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.

Sign up for GitHub

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

Jump to bottom

Tables for Data Logging #16

Open
joshhwuu opened this issue Sep 19, 2024 · 0 comments
Open

Tables for Data Logging #16

joshhwuu opened this issue Sep 19, 2024 · 0 comments
Assignees
@Kevinxygu
Labels
High High priority

Comments

@joshhwuu
Copy link
Contributor

joshhwuu commented Sep 19, 2024 •
edited
Loading

Data logging table is the table where we keep track of user activity (sign in time, PC number, game, etc), should look like this:

Attribute/Column Name Type
student_number (FK) charvar(8)
pc_number integer
game charvar(250)
started_at date
ended_at date

Under users_test schema, name the table gamer_activity

Follow-up issue for creating the API: #23
@joshhwuu joshhwuu added the High High priority label Sep 19, 2024
@joshhwuu joshhwuu mentioned this issue Sep 29, 2024
Closed
@joshhwuu joshhwuu changed the title Tables for Data Logging + API Tables for Data Logging Sep 29, 2024
@joshhwuu joshhwuu assigned Kevinxygu and unassigned Jaden51 and joshhwuu Sep 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Kevinxygu Kevinxygu

Labels
High High priority
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@Jaden51 @Kevinxygu @joshhwuu