mysql - Using ENUM datatype in many columns with list of values is good practice? -


i developing dating website. in project use mysql table named "users" , table have used enum datatype many columns.

my "users" table looks :

create table if not exists users (     user_id smallint unsigned not null auto_increment,     country_id smallint unsigned not null,      username varchar(20) not null,      password char(128) not null,     salt char(128) not null,     email varchar(40) not null,      first_name varchar(30) default null,     last_name varchar(30) default null,     sex enum('male', 'female') default 'male',     dob varchar(10) not null,      mobile varchar(12) default null,    address varchar(40) default null,   address_two varchar(40) default null,   city varchar(25) not null,      whoami varchar(80) not null,      looking_for enum('short-term','long-term','marriage','dating','friends/hang out','intimate encounter','talk/email/pen pal','activity partner') default 'dating',     ethnicity enum('white/caucasian','black/african','hispanic/latino','asian','native american','middle eastern','east indian','pacific islander','mixed race') default null,     marital_status enum('never married','divorced','widowed','separated','in relationship','not single/not looking') default null,     religion enum('atheist','buddhist/taoist','christian/catholic','christian/protestant','christian/lds','christian/other','hindu','jewish','muslim/islamic','new age','non-religious','agnostic','spiritual not religious','other religion') default null,      body_type enum('skinny','slim/slender','fit/athletic','toned & firm','muscular','ripped','modelesque','average','proportional','curvy','few pounds','full figured','stocky','husky','voluptuous','big , beautiful','large','disabled') default null,     hair_color enum('auburn','red','stawberry blonde','platinum blonde','blonde','dark blonde','light brown','medium brown','dark brown','black','radically dyed','salt & pepper','partial gray','gray','silver/white','bald/shaved') default null,     drink enum('never','rarely','occasionally','socially','regularly','gave up') default null,     smoke enum('never','socially','regularly','trying quit') default null,     headline varchar(100) default null,      about_user text default null,      ideal_match_info text default null,       last_login timestamp not null default '0000-00-00 00:00:00',     date_registered timestamp not null default current_timestamp,     primary key (user_id),     unique (email),      unique (username) ) engine=myisam default charset=utf8;

my question is, enum datatype have used in table correct or not. if correct way hope body guid me right direction.

thank you.

this not way use enum. it's you'll have change options, , way change enum costly , error-prone alter table. store option text instead (varchar or tinytext). normalization perspective better create separate tables options makes data harder understand.

the enum data type best used cases when options guaranteed not change.


Comments

Post a Comment

Popular posts from this blog

node.js - Using Node without global install -

i'm working on few node & electron (atom shell) projects , i'm curious how them work without user having install node globally. i've seen few applications including node directory in project contains node.exe binary. how go setting node project use binary? edit: thought should add, i've searched everywhere answer this, unrelated results.
Read more

How to access a php class file from PHPFox framework into javascript code written in simple HTML file? -

i've website developed using phpfox v3.0.7 . now i'm trying implement 'sse(server sent events)' 1 of php files. reference i'm giving below necessary code part of file. file titled process.class.php , present @ location /var/www/module/notification/include/service/process.class.php present on server having ip http://34.124.40.142/ . <?php /** * [phpfox_header] */ header('content-type: text/event-stream'); header('cache-control: no-cache'); defined('phpfox') or exit('no dice!'); /** * * * @copyright [phpfox_copyright] * @author raymond benc * @package phpfox_service * @version $id: service.class.php 67 2009-01-20 11:32:45z raymond_benc $ */ class notification_service_process extends phpfox_service { /** * class constructor */ public function __construct() { $this->_stable = phpfox::gett('notification'); } public function add($...
Read more

java - Null response to php query in android, even though php works properly -

Image
table i'm trying retrieve above data using 2 php files below. want pass email parameter , return bets user = email. work fine when tested advanced rest client, problem not php. however, when try through android 2 java classes below, null pointer exception (logcat below) , json object returned null. i'm not sure error is, think i'm not passing parameter php , that's why it's producing null response. logcat 05-31 15:10:50.227 26074-26074/com.example.albert.betterapp e/androidruntime﹕ fatal exception: main process: com.example.albert.betterapp, pid: 26074 java.lang.runtimeexception: unable start activity componentinfo{com.example.albert.betterapp/com.example.albert.betterapp.displayallbets}: java.lang.nullpointerexception @ android.app.activitythread.performlaunchactivity(activitythread.java:2292) @ android.app.activitythread.handlelaunchactivity(activitythread.java:2350) @ android.app.activitythread.acce...
Read more