Phase 0

start small this will take about a year to have all the way done.

login

url - app.crestfallen.com

phase 1 Bank

only manage the bank

both a player view and a gamemaster view

export total count of player bank to be used on the

print to small stickers to put on an ig looking ledger for the event.

phase 2 - Track exp but no player facing builder

Phase 3 advertising

sign up for newsletter

add address for physical mailings

unsubscribe from newsletter

Phase 4 payment

submit event feedback

register for event

pay for event

Phase 5 Character builder

pull source data from the website.

Questions

mobile app?

db structure

player

id name safety_reviewed email newsletter yes/no medical_disclosure

address

mailings: yes/no

discod username

facebook profile

character

id name lineage essence (derived)

hometown

character_life_events

character_skills**

id,character_id,ckill_category_id,skill_id

character_spells

character_skill_category

skill_category

id name lineage (y/n)

skills

name skill_category cost

event

id

type

date

url

event_attendance

id

event_id

player_id

type: interested,registered,attended,missed

event survey

cp log

date,character_number,event_attendance_id,exp type,cp amount

bank_log

id,character_id,date,delta,description

essence log

id,character_id,date,amount,description

Ranking

id,character_id,lineage_id,

administrative views

​ players by tenative,registered,attended

Checking mode

​ character with sheet

Character Sheet

​ date printed

Bank Sheet

​ date printed

Spell Sheet

select character.name,player_id,precedence
from cfl.player
inner join cfl.character on player.id = character.player_id

Login character chooser 1 2 staff Staff view checkin update bank checkout update bank update exp