In my SQL table I have a field called Category. It can have only two possible values(Animal or Plant).
So my question is .....
Is it a good idea to declare the datatype for Category as nvarchar(10) or a bit field(true or false) or have a separate category table and include its id