au_id|id|11|||no
au_lname|varchar|40|||no
au_fname|varchar|20|||no
phone|char|12|||no
address|varchar|40|||yes
city|varchar|20|||yes
state|char|2|||yes
zip|char|5|||yes
contract|bit|1|||no