search

TFFHRTP / tffhrtp-archives

This is the official Archives repo for TFFHRTP
MIT License
0 stars 0 forks source link

Database schema for TFFHRTP #14

Open soham02 opened 1 day ago

soham02 commented 1 day ago

Current Proposal

https://gitlab.com/tffhrtp/image-archive/archive-website/tffhrtp-archives/-/wikis/home/table_schema_proposal

soham02 commented 1 day ago

Notes for Table Schema Proposal

UserTable -Adding a status column to manage user acounts (active/ suspended) PhotosTable -Visibillity (Public, Private) -Exif field (JSON or XML) to store metadata like camera model setting PhotoSearchLog -ResultCount column to capture number of result returned for query (helpful for analytics) PhotoModifications Table -Priority column (e.g., Low, Medium, High) for triaging modification requests -Comments field for reviewers to explain their decisions. Subscriptions Table: -LastSent timestamp to track the last time an email was sent to the user. ContactMessages Table -ReplyStatus column (e.g., Pending, Replied) to track whether a response has been sent. DeletionAppeals Table -ReviewedBy column to track which moderator/admin handled the appeal. UserRoleChanges Table -Reason column for admins to explain why the role change occurred.