Hello, I would like to create a table and incorporate an indivudal data typa: eg.: datatype 'state' with values like { 'pending', 'confirmed','declined' } How can I do this? Thanks!
You can set a default value eg New in the database but the control over what values the user chooses, or are assigned automatically as a work order progresses, is up in PHP or the scripting language you use.
You can use this as "char" or "varchar" type. Then your php code sends values as you want, confirmed or pending or whatever else you want.