search

vvmurthy / RadiationTherapyDecisionSupport

Python Code, MATLAB Original Code and data to benchmark Radiation Therapy Decision Support Algorithm
0 stars 1 forks source link

Set lower bounds on VARCHAR for some of the db tables #24

Open vvmurthy opened 6 years ago

vvmurthy commented 6 years ago

Should ROIDisplayColor be varchar(100)? We can set a tighter lower bound of about 13 characters: "(xxx,yyy,zzz)" Why is PatientGender in patients varchar(20)? it should be varchar(1) Why is DBStudyID in similarity varchar? it should be int(11) Why is TargetOAR in similarity varchar? it should be int(11)

vvmurthy commented 6 years ago

In upload in RadiationTherapyApplication repo, you will need to fix the max lengths in the db definitions to fit the new lower bounds as well.