Alan Gauld <alan.ga...@btinternet.com> writes: > A flag column that can be used to include/exclude students from > reports.
Boolean flags very commonly indicate something that can be different at different times. When the name is of the form “currently_foo”, that's almost certainly something that is different at different points in time. So better than a boolean in the database, would be a timestamp (or just a date) indicating *when* the status changes. Either an ‘enrolled’ timestamp, or a ‘departed’ timestamp, or both. Then you can interrogate the database about past, present, or future, by comparing that value with whatever point in time is of interest. -- \ “Faith is the determination to remain ignorant in the face of | `\ all evidence that you are ignorant.” —Shaun Mason | _o__) | Ben Finney _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor
