Table design for Custom Fields

Discussions about development of VICIDIAL and astGUIclient

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Table design for Custom Fields

Postby theprofoundgeek » Wed May 02, 2012 5:34 pm

Hello,

I was working with the custom field and came across this table :

vicidial_lists_fields (
field_id INT(9) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
list_id BIGINT(14) UNSIGNED NOT NULL DEFAULT '0',
field_label VARCHAR(50),
field_name VARCHAR(1000),
field_description VARCHAR(100),
field_rank SMALLINT(5),
field_help VARCHAR(1000),
field_type ENUM('TEXT','AREA','SELECT','MULTI','RADIO','CHECKBOX','DATE','TIME') default 'TEXT',
field_options VARCHAR(5000),
field_size SMALLINT(5),
field_max SMALLINT(5),
field_default VARCHAR(255),
field_cost SMALLINT(5),
field_required ENUM('Y','N') default 'N',
name_position ENUM('LEFT','TOP') default 'LEFT',
multi_position ENUM('HORIZONTAL','VERTICAL') default 'HORIZONTAL',
field_order SMALLINT(5) default '1'
);


Here, as per my understanding field_options VARCHAR(5000), is used to store the options of fields types with multiple options such as checkbox. Isn't it a bad way to store it this way?

Would creating a new table named vicidial_lists_fields_options with :

field_id | Option

would be a better way to do this? Are there any particular reasons to store options in a single string?
theprofoundgeek
 
Posts: 7
Joined: Thu Jan 12, 2012 3:01 pm

Re: Table design for Custom Fields

Postby mflorell » Wed May 02, 2012 6:10 pm

It seems to work pretty well actually, and it's a lot faster than sticking up to hundreds of options in separate records in a separate table. We actually did a ton of testing on just about every aspect of custom fields to ensure it could stand up to hundreds of agents and millions of records and what we created two years ago has stood up very well.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Development

Who is online

Users browsing this forum: No registered users and 31 guests