SQLite Forum

foreign key issue on deleate
Login
Chronological Hierarchical 
Programs(UserName) is text but User(ID) is integer.

ProgramList(Program) is not unique.

Your schema is logically inconsistent.