Coverage for crateweb/nlp_classification/migrations/0001_initial.py: 100%

1# Generated by Django 4.2.21 on 2025-08-19 13:53 

2 

3from django.conf import settings 

4from django.db import migrations, models 

5import django.db.models.deletion 

6 

7 

8class Migration(migrations.Migration): 

9 

10 initial = True 

11 

12 dependencies = [ 

13 migrations.swappable_dependency(settings.AUTH_USER_MODEL), 

14 ] 

15 

16 operations = [ 

17 migrations.CreateModel( 

18 name="Assignment", 

19 fields=[ 

20 ( 

21 "id", 

22 models.AutoField( 

23 auto_created=True, 

24 primary_key=True, 

25 serialize=False, 

26 verbose_name="ID", 

27 ), 

28 ), 

29 ], 

30 ), 

31 migrations.CreateModel( 

32 name="Column", 

33 fields=[ 

34 ( 

35 "id", 

36 models.AutoField( 

37 auto_created=True, 

38 primary_key=True, 

39 serialize=False, 

40 verbose_name="ID", 

41 ), 

42 ), 

43 ("name", models.CharField(max_length=100)), 

44 ], 

45 ), 

46 migrations.CreateModel( 

47 name="Option", 

48 fields=[ 

49 ( 

50 "id", 

51 models.AutoField( 

52 auto_created=True, 

53 primary_key=True, 

54 serialize=False, 

55 verbose_name="ID", 

56 ), 

57 ), 

58 ("description", models.CharField(max_length=100)), 

59 ], 

60 ), 

61 migrations.CreateModel( 

62 name="Question", 

63 fields=[ 

64 ( 

65 "id", 

66 models.AutoField( 

67 auto_created=True, 

68 primary_key=True, 

69 serialize=False, 

70 verbose_name="ID", 

71 ), 

72 ), 

73 ("title", models.CharField(max_length=100)), 

74 ( 

75 "options", 

76 models.ManyToManyField(to="nlp_classification.option"), 

77 ), 

78 ], 

79 ), 

80 migrations.CreateModel( 

81 name="SourceRecord", 

82 fields=[ 

83 ( 

84 "id", 

85 models.AutoField( 

86 auto_created=True, 

87 primary_key=True, 

88 serialize=False, 

89 verbose_name="ID", 

90 ), 

91 ), 

92 ("source_pk_value", models.CharField(max_length=100)), 

93 ("nlp_pk_value", models.CharField(max_length=100)), 

94 ], 

95 ), 

96 migrations.CreateModel( 

97 name="TableDefinition", 

98 fields=[ 

99 ( 

100 "id", 

101 models.AutoField( 

102 auto_created=True, 

103 primary_key=True, 

104 serialize=False, 

105 verbose_name="ID", 

106 ), 

107 ), 

108 ("db_connection_name", models.CharField(max_length=100)), 

109 ("table_name", models.CharField(max_length=100)), 

110 ("pk_column_name", models.CharField(max_length=100)), 

111 ], 

112 ), 

113 migrations.CreateModel( 

114 name="Task", 

115 fields=[ 

116 ( 

117 "id", 

118 models.AutoField( 

119 auto_created=True, 

120 primary_key=True, 

121 serialize=False, 

122 verbose_name="ID", 

123 ), 

124 ), 

125 ("name", models.CharField(max_length=100)), 

126 ], 

127 ), 

128 migrations.CreateModel( 

129 name="UserAnswer", 

130 fields=[ 

131 ( 

132 "id", 

133 models.AutoField( 

134 auto_created=True, 

135 primary_key=True, 

136 serialize=False, 

137 verbose_name="ID", 

138 ), 

139 ), 

140 ( 

141 "assignment", 

142 models.ForeignKey( 

143 on_delete=django.db.models.deletion.CASCADE, 

144 to="nlp_classification.assignment", 

145 ), 

146 ), 

147 ( 

148 "decision", 

149 models.ForeignKey( 

150 null=True, 

151 on_delete=django.db.models.deletion.SET_NULL, 

152 to="nlp_classification.option", 

153 ), 

154 ), 

155 ( 

156 "question", 

157 models.ForeignKey( 

158 on_delete=django.db.models.deletion.CASCADE, 

159 to="nlp_classification.question", 

160 ), 

161 ), 

162 ( 

163 "source_record", 

164 models.ForeignKey( 

165 on_delete=django.db.models.deletion.CASCADE, 

166 to="nlp_classification.sourcerecord", 

167 ), 

168 ), 

169 ], 

170 ), 

171 migrations.AddField( 

172 model_name="sourcerecord", 

173 name="nlp_table_definition", 

174 field=models.ForeignKey( 

175 null=True, 

176 on_delete=django.db.models.deletion.SET_NULL, 

177 related_name="source_records", 

178 to="nlp_classification.tabledefinition", 

179 ), 

180 ), 

181 migrations.AddField( 

182 model_name="sourcerecord", 

183 name="source_column", 

184 field=models.ForeignKey( 

185 on_delete=django.db.models.deletion.CASCADE, 

186 to="nlp_classification.column", 

187 ), 

188 ), 

189 migrations.CreateModel( 

190 name="SampleSpec", 

191 fields=[ 

192 ( 

193 "id", 

194 models.AutoField( 

195 auto_created=True, 

196 primary_key=True, 

197 serialize=False, 

198 verbose_name="ID", 

199 ), 

200 ), 

201 ("search_term", models.CharField(max_length=100)), 

202 ("size", models.IntegerField()), 

203 ("seed", models.PositiveIntegerField()), 

204 ( 

205 "nlp_table_definition", 

206 models.ForeignKey( 

207 on_delete=django.db.models.deletion.CASCADE, 

208 to="nlp_classification.tabledefinition", 

209 ), 

210 ), 

211 ( 

212 "source_column", 

213 models.ForeignKey( 

214 on_delete=django.db.models.deletion.CASCADE, 

215 to="nlp_classification.column", 

216 ), 

217 ), 

218 ], 

219 ), 

220 migrations.AddField( 

221 model_name="question", 

222 name="task", 

223 field=models.ForeignKey( 

224 on_delete=django.db.models.deletion.CASCADE, 

225 to="nlp_classification.task", 

226 ), 

227 ), 

228 migrations.AddField( 

229 model_name="column", 

230 name="table_definition", 

231 field=models.ForeignKey( 

232 on_delete=django.db.models.deletion.CASCADE, 

233 to="nlp_classification.tabledefinition", 

234 ), 

235 ), 

236 migrations.AddField( 

237 model_name="assignment", 

238 name="sample_spec", 

239 field=models.ForeignKey( 

240 on_delete=django.db.models.deletion.CASCADE, 

241 to="nlp_classification.samplespec", 

242 ), 

243 ), 

244 migrations.AddField( 

245 model_name="assignment", 

246 name="source_records", 

247 field=models.ManyToManyField(to="nlp_classification.sourcerecord"), 

248 ), 

249 migrations.AddField( 

250 model_name="assignment", 

251 name="task", 

252 field=models.ForeignKey( 

253 on_delete=django.db.models.deletion.CASCADE, 

254 to="nlp_classification.task", 

255 ), 

256 ), 

257 migrations.AddField( 

258 model_name="assignment", 

259 name="user", 

260 field=models.ForeignKey( 

261 on_delete=django.db.models.deletion.CASCADE, 

262 to=settings.AUTH_USER_MODEL, 

263 ), 

264 ), 

265 ]