My question involves civil law for the state of: TN

i was shot in the face in TN and the offender was charged with not guilty because of insanity.

can you do a civil action at someone who is in a psychiatric hospital?

if i do, would the state pay it since they are the "guardian" at the moment, or would the money be garnished from his paycheck when he is released from the mental hospital?

the offender is an invalid with no assets, but was under mental-treatment (was not taking his mental-affecting pills and was on alcohol at the time of the shooting) at the time of the crime.... is the state hospital that was medicating him in any way responsible? or is the offender singly responsible for his own actions of shooting me?

should i file a civil suit in small claims court (max $15,000) or sue for what i feel damages are , which is closer to 30 million (damaged vision and much suffering) in big court?