hi, just want to maek sure some thing.
so i have a table called user. in user table i want to add a field called date of birth. but i dont know which type to choice. it has int, varchar, date, datetime etc. but no date of birth.

do i just choice type date?

2nd question.
i also want a field called gender. so user can pick male or female. but i cant find the right type.

do i just choice boolean? 1 or maile and 0 for femail?

i think i post this in wrong place

on front end i have two SignUps, 1 for applicant and one for sub-Admin of different hotels !!!
store procedure will directly assign ID=1 (Role) for applicant but what i should do for admin ? mean he/she would have to wait for that (mean role have to be assigned by Su?per Admin) ? or what ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.