it is time for a master plan only an anime protagonist could devise as fruit threatens to private 50% of videos
Groups - admins, moderators, db staff =>
a) Badges
b) Link user to YouTube channel
Database management page => CRUD (staff only)
a) Staff-only: per channel => from YouTube playlist IDs, grab video IDs + metadata => into psql
b) User-suggestable: per YouTube video ID (11 alphanumeric characters), Bilibili CN video ID (12 alphanumeric characters), Bilibili TV video ID (10 numeric characters) (log in DB management page)
c) Between the 3 types of video IDs, there can be a linked relation as they are all distinguished by their Entry ID
d) Stores sheet music, social media locations by relation to channel or video (same integration as platform video IDs)
e) DB relation between Entry ID and Creator ID such that it can then be subsequently linked to an anipianolist account User ID if that person is on anipianolist
f) Merge and batch add/delete
User reviews and ratings
a) Basic fields/form setup
b) Reactions/comments (reddit-style hierarchy)
c) Review ID with one-to-one relation with Entry ID
it is time for a master plan only an anime protagonist could devise as fruit threatens to private 50% of videos