>Should you have a flag for the status "movement complete" ? I would say
>yes but instead of a simple checkbox, you could store a date value. That
>gives you two pieces of information
>a) if the date is null then the movement is not complete.
>b) if the date is NOT null then the movement is complete and you know when
There, Shawn and I disagree :-)
In case of a very simple database, one could use NULL
as a "flag" or "signal". But in general, I would avoid
Basics of database design: store what you know.
Given that NULLs basically means the absence of a value
(eg: unknown), you shouldn't be storing NULLs.
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!