Status field contains values Open,Awaiting,Approved,Rejected. To store a value what is the best datatype in mysql? Is it TINYINT OR VARCHAR? TINYINT occupies less memory if we store numbers instead of strings ( 1 => Open, 2 => Awaiting ...). Is it cause any performence issue when using joins?
I want to create a table to store status values like this
STATUS VALUE
------ ------
Open 1
Awaiting 2
Approved 3
Rejected 4
Is it good idea? or proceeding with varchar is good idea?
Thanks