283375 / arcaea-offline Goto Github PK

CREATE DATABASE songs (id, title, artist, ...)  -- 从 songlist 提取，包含标题、曲师等信息
CREATE DATABASE charts_info (song_id, rating_class, constant, ...)  -- 谱面定数等计算 PTT 用信息
CREATE VIEW charts (song_id, rating_class, ...)  -- 上面两张表的合并

CREATE DATABASE score (id AUTOINCREMENT, score NOT NULL, time, pure, far, lost, ...)  -- 存储成绩，除必要的分数外其他项可为 NULL
CREATE VIEW calculated (id, score, pure, far, lost, ..., potential, shiny_pure, ...)  -- 每个成绩经过计算得到的单曲 PTT 等

CREATE DATABASE r30 (*calculated)  -- r30 队列，按 score.time 刷新
CREATE VIEW bests (*calculated)  -- 从 calculated 中自动计算
CREATE VIEW final_potential (ptt, b30, r10)  -- 最后计算得出的最终 PTT