tmccormi wrote on Thursday, February 03, 2011:
I think 24 chars is short even for “short text” so I would think going to 50 would be a problem. But is there a reason you can’t use the ‘codes_text’ field which is 255 chars already?
-Tony
sunsetsystems wrote on Thursday, February 03, 2011:
There’s no downside to increasing a varchar size, but like Tony says use code_text unless there’s a reason not to.
anonymous wrote on Thursday, February 03, 2011:
The load for CVX has a code, vaccine name and description. The description will fit into the code_text field. but the vaccine name will not fit into 24 characters. The related code field will contain the related CPT code.
CVX Code = codes.code
Vaccine Description = codes.code_text
CPT Code = related_code
Vaccine Name = ? codes.code_text_short ?
If there are no objections I will make the change. Otherwise I will use a separate table. Currently there are only 98 entries. Any suggestions?
Thanks!
Connie Douglas
Phyaura, LLC
sunsetsystems wrote on Friday, February 04, 2011:
I have no objection to making code_text_short longer.
tmccormi wrote on Friday, February 04, 2011:
Nor I. too bad MySQL doesn’t have overlay field mapping then you could have a call the same data space vaccine in the table. You can do that in the code (and should) …
-Tony