| blob | 3da96ce5eb899d4e9d174e31bf317c564321e501 |
1 CREATE TABLE IF NOT EXISTS form_assessment_intake (
2 id bigint(20) NOT NULL auto_increment,
3 date datetime default NULL,
4 pid bigint(20) default NULL,
5 user varchar(255) default NULL,
6 groupname varchar(255) default NULL,
7 authorized tinyint(4) default NULL,
8 activity tinyint(4) default NULL,
9 dcn varchar(10) default NULL,
10 location varchar(20) default NULL,
11 time_in time default NULL,
12 time_out time default NULL,
13 referral_source varchar(15) default NULL,
14 new_client_eval varchar(3) NOT NULL default 'N/A',
15 readmission varchar(3) NOT NULL default 'N/A',
16 consultation varchar(3) NOT NULL default 'N/A',
17 copy_sent_to varchar(25) default NULL,
18 reason_why longtext,
19 behavior_led_to longtext,
20 school_work longtext,
21 personal_relationships longtext,
22 fatherc varchar(3) NOT NULL default 'N/A',
23 motherc varchar(3) NOT NULL default 'N/A',
24 father_involved longtext,
25 mother_involved longtext,
26 number_children tinyint(4),
27 siblings longtext,
28 other_relationships longtext,
29 social_relationships longtext,
30 current_symptoms longtext,
31 personal_strengths longtext,
32 spiritual varchar(15) default NULL,
33 legal varchar(20) default NULL,
34 prior_history longtext,
35 number_admitt tinyint(4),
36 type_admitt varchar(20),
37 substance_use longtext,
38 substance_abuse longtext,
39 axis1 longtext,
40 axis2 longtext,
41 axis3 longtext,
42 allergies varchar(20),
43 ax4_prob_support_group varchar(3) NOT NULL default 'N/A',
44 ax4_prob_soc_env varchar(3) NOT NULL default 'N/A',
45 ax4_educational_prob varchar(3) NOT NULL default 'N/A',
46 ax4_occ_prob varchar(3) NOT NULL default 'N/A',
47 ax4_housing varchar(3) NOT NULL default 'N/A',
48 ax4_economic varchar(3) NOT NULL default 'N/A',
49 ax4_access_hc varchar(3) NOT NULL default 'N/A',
50 ax4_legal varchar(3) NOT NULL default 'N/A',
51 ax4_other_cb varchar(3) NOT NULL default 'N/A',
52 ax4_other longtext,
53 ax5_current varchar(3),
54 ax5_past varchar(3),
55 risk_suicide_na varchar(3) NOT NULL default 'N/A',
56 risk_suicide_nk varchar(3) NOT NULL default 'N/A',
57 risk_suicide_io varchar(3) NOT NULL default 'N/A',
58 risk_suicide_plan varchar(3) NOT NULL default 'N/A',
59 risk_suicide_iwom varchar(3) NOT NULL default 'N/A',
60 risk_suicide_iwm varchar(3) NOT NULL default 'N/A',
61 risk_homocide_na varchar(3) NOT NULL default 'N/A',
62 risk_homocide_nk varchar(3) NOT NULL default 'N/A',
63 risk_homocide_io varchar(3) NOT NULL default 'N/A',
64 risk_homocide_plan varchar(3) NOT NULL default 'N/A',
65 risk_homocide_iwom varchar(3) NOT NULL default 'N/A',
66 risk_homocide_iwm varchar(3) NOT NULL default 'N/A',
67 risk_compliance_na varchar(3) NOT NULL default 'N/A',
68 risk_compliance_fc varchar(3) NOT NULL default 'N/A',
69 risk_compliance_mc varchar(3) NOT NULL default 'N/A',
70 risk_compliance_moc varchar(3) NOT NULL default 'N/A',
71 risk_compliance_var varchar(3) NOT NULL default 'N/A',
72 risk_compliance_no varchar(3) NOT NULL default 'N/A',
73 risk_substance_na varchar(3) NOT NULL default 'N/A',
74 risk_substance_none varchar(3) NOT NULL default 'N/A',
75 risk_normal_use longtext,
76 risk_substance_ou varchar(3) NOT NULL default 'N/A',
77 risk_substance_dp varchar(3) NOT NULL default 'N/A',
78 risk_substance_ur varchar(3) NOT NULL default 'N/A',
79 risk_substance_ab varchar(3) NOT NULL default 'N/A',
80 risk_sexual_na varchar(3) NOT NULL default 'N/A',
81 risk_sexual_y varchar(3) NOT NULL default 'N/A',
82 risk_sexual_n varchar(3) NOT NULL default 'N/A',
83 risk_sexual_ry varchar(3) NOT NULL default 'N/A',
84 risk_sexual_rn varchar(3) NOT NULL default 'N/A',
85 risk_sexual_cv varchar(3) NOT NULL default 'N/A',
86 risk_sexual_cp varchar(3) NOT NULL default 'N/A',
87 risk_sexual_b varchar(3) NOT NULL default 'N/A',
88 risk_sexual_nf varchar(3) NOT NULL default 'N/A',
89 risk_neglect_na varchar(3) NOT NULL default 'N/A',
90 risk_neglect_y varchar(3) NOT NULL default 'N/A',
91 risk_neglect_n varchar(3) NOT NULL default 'N/A',
92 risk_neglect_ry varchar(3) NOT NULL default 'N/A',
93 risk_neglect_rn varchar(3) NOT NULL default 'N/A',
94 risk_neglect_cv varchar(3) NOT NULL default 'N/A',
95 risk_neglect_cp varchar(3) NOT NULL default 'N/A',
96 risk_neglect_cb varchar(3) NOT NULL default 'N/A',
97 risk_neglect_cn varchar(3) NOT NULL default 'N/A',
98 risk_exists_c varchar(3) NOT NULL default 'N/A',
99 risk_exists_cn varchar(3) NOT NULL default 'N/A',
100 risk_exists_s varchar(3) NOT NULL default 'N/A',
101 risk_exists_o varchar(3) NOT NULL default 'N/A',
102 risk_exists_b varchar(3) NOT NULL default 'N/A',
103 risk_community longtext,
104 recommendations_psy_i varchar(3) NOT NULL default 'N/A',
105 recommendations_psy_f varchar(3) NOT NULL default 'N/A',
106 recommendations_psy_m varchar(3) NOT NULL default 'N/A',
107 recommendations_psy_o varchar(3) NOT NULL default 'N/A',
108 recommendations_psy_notes longtext,
109 refer_date date default NULL,
110 parent date default NULL,
111 supervision_level longtext,
112 supervision_type longtext,
113 supervision_res longtext,
114 supervision_services longtext,
115 support_ps varchar(3) NOT NULL default 'N/A',
116 support_cs varchar(3) NOT NULL default 'N/A',
117 support_sm varchar(3) NOT NULL default 'N/A',
118 support_a varchar(3) NOT NULL default 'N/A',
119 support_o varchar(3) NOT NULL default 'N/A',
120 support_ol longtext,
121 legal_op varchar(3) NOT NULL default 'N/A',
122 legal_so varchar(3) NOT NULL default 'N/A',
123 legal_sa varchar(3) NOT NULL default 'N/A',
124 legal_ve varchar(3) NOT NULL default 'N/A',
125 legal_ad varchar(3) NOT NULL default 'N/A',
126 legal_adl varchar(20) default NULL,
127 legal_o varchar(3) NOT NULL default 'N/A',
128 legal_ol longtext,
129 referrals_pepm longtext,
130 referrals_mc longtext,
131 referrals_vt longtext,
132 referrals_o longtext,
133 referrals_cu longtext,
134 referrals_docs longtext,
135 referrals_or longtext,
136 PRIMARY KEY (id)
137 ) ENGINE=MyISAM;