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?