Define mydatatype=varchar(10) is substituted throughout schema. So, Long/Lat, PostCode, Zipcode, USRN, Employee # or whatever remains consistent throughout.I wouldn't have to refer to other table defs to maintain consistency.