Create supabase views for challenges

l2lam / CBC-Board-System

Sports (badminton) club session management system to faciliate efficient, fair play for all club members

Apache License 2.0

1 stars 1 forks source link

Open l2lam opened 2 weeks ago

l2lam commented 2 weeks ago

DB views to stitch together the challenge related records into a flat table:

active challenges - for challenges that got interrupted and needs to be resumed
all challenges - for historical examination of challenges
challenge statistics for a given member - can be used to determine challenge elligibility