class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Database',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('db',
models.FileField(
blank=True,
help_text='Choose SQL File',
upload_to=db.models.content_file_name,
validators=[
django.core.validators.FileExtensionValidator(
allowed_extensions=['sql'])
])),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('db', '0011_auto_20190303_1322'),
]
operations = [
migrations.CreateModel(
name='Report2',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('firstName', models.CharField(max_length=255)),
('lastName', models.CharField(max_length=255)),
('age', models.IntegerField(blank=True, default=0)),
('pincode', models.CharField(blank=True, max_length=255)),
('number', models.CharField(blank=True, max_length=255)),
('address', models.TextField(blank=True)),
('dengueBed', models.IntegerField(blank=True)),
('malariaBed', models.IntegerField(blank=True)),
('tuberculosisBed', models.IntegerField(blank=True)),
('owner', models.CharField(blank=True, max_length=255)),
('govt_id', models.CharField(blank=True, max_length=255)),
('adhaar', models.CharField(blank=True, max_length=255)),
('docRegNo', models.CharField(blank=True, max_length=255)),
('disease', models.CharField(blank=True, max_length=255)),
('hosName', models.CharField(blank=True, max_length=255)),
('HosReg', models.CharField(blank=True, max_length=255)),
('accreditation', models.CharField(blank=True, max_length=255)),
('report_upload', models.FileField(blank=True, null=True, upload_to=db.models.user_directory_path)),
('certi_upload', models.ImageField(blank=True, null=True, upload_to=db.models.lab_certi_path)),
('report_disease', models.CharField(blank=True, max_length=255)),
('gender', models.CharField(blank=True, max_length=1, null=True, verbose_name=(('M', 'Male'), ('F', 'Female'), ('O', 'Other')))),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Doctor',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=30)),
('domain', models.CharField(max_length=200)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='doctorData',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Patient',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=20)),
('age', models.IntegerField()),
('gender', models.CharField(max_length=6)),
('cause', models.CharField(max_length=200)),
('isAssigned', models.BooleanField()),
('doctor',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='db.doctor')),
],
),
migrations.CreateModel(
name='Scans',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date', models.CharField(max_length=8)),
('src', models.FileField(upload_to=db.models.uploadImg)),
('isReported', models.BooleanField()),
('report', models.TextField()),
('patient',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='scans',
to='db.patient')),
],
),
migrations.CreateModel(
name='Hospital',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='hospitalData',
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Content',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('label', models.CharField(max_length=255)),
('url', models.TextField()),
('type',
models.CharField(choices=[('VID', 'Video'), ('AUD', 'Audio'),
('PIC', 'Picture'),
('DOC', 'Document'),
('XLS', 'Excel'),
('PPT', 'Powerpoint'),
('GFORM', 'Google form'),
('GDOC', 'Google document')],
default='DOC',
max_length=255)),
],
options={
'db_table': 'mangalyacore_material_content',
},
),
migrations.CreateModel(
name='Course',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=255)),
('description', models.TextField()),
('pass_grade',
db.models.DecimalRangeField(decimal_places=2,
default=50,
max_digits=5)),
],
options={
'db_table': 'mangalyacore_courses',
},
),
migrations.CreateModel(
name='Material',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=255)),
],
options={
'db_table': 'mangalyacore_materials',
},
),
migrations.CreateModel(
name='UserCourseMaterial',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('grade',
db.models.DecimalRangeField(decimal_places=2,
default=0,
max_digits=5)),
('course_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='courses.Course')),
('material_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='courses.Material')),
('user_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'db_table': 'mangalyacore_user_course_material',
},
),
migrations.AddField(
model_name='content',
name='material_id',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='courses.Material'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='File',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=100)),
('script', models.CharField(blank=True, max_length=100)),
('author', models.CharField(max_length=30)),
('file', models.FileField(blank=True, max_length=10000, upload_to='docs/')),
('created_at', models.DateField(auto_now_add=True)),
],
),
migrations.CreateModel(
name='Plate',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(default=db.models.Plate.get_name, max_length=50, unique=True)),
('type', models.CharField(choices=[('Plate', 'Plate'), ('Box', 'Box')], default='Plate', max_length=50)),
('barcode', models.IntegerField(default=db.models.Plate.get_barcode, unique=True)),
('num_cols', models.IntegerField()),
('num_rows', models.IntegerField()),
('num_well', models.IntegerField()),
('active', models.BooleanField(default=True)),
('status', models.CharField(blank=True, choices=[('G', 'On going'), ('C', 'Completed'), ('A', 'Aborted'), ('H', 'On hold')], max_length=1)),
('created_at', models.DateField(auto_now_add=True)),
('updated_at', models.DateField(auto_now=True)),
],
options={
'ordering': ('id',),
},
),
migrations.CreateModel(
name='Sample',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=50, unique=True, verbose_name='Name')),
('alias', models.CharField(max_length=50)),
('sample_type', models.CharField(choices=[('Pr', 'Primer'), ('Pd', 'Plasmid'), ('Pt', 'Part'), ('Lr', 'Linker'), ('Ot', 'Other')], default='Ot', max_length=50)),
('description', models.CharField(blank=True, max_length=100)),
('project', models.CharField(blank=True, choices=[('GF', 'GF_general'), ('SA', 'Sanguinarine'), ('MK', 'MoClo kit'), ('YK', 'Yeast CRISPR kit')], max_length=30)),
('author', models.CharField(blank=True, max_length=50)),
('sequence', models.CharField(blank=True, max_length=10000)),
('length', models.IntegerField(blank=True, null=True)),
('genbank', models.FileField(blank=True, max_length=10000, upload_to='gb_files/')),
('source_reference', models.CharField(blank=True, max_length=30)),
('comments', models.CharField(blank=True, max_length=100)),
('created_at', models.DateField(default=django.utils.timezone.now)),
('updated_at', models.DateField(auto_now=True)),
('organism', models.CharField(blank=True, choices=[('H', 'Human'), ('Y', 'Yeast')], max_length=1)),
('genus_specie', models.CharField(blank=True, max_length=50)),
('marker', models.CharField(blank=True, max_length=50)),
('application', models.CharField(blank=True, max_length=50)),
('strategy', models.CharField(blank=True, max_length=50)),
('seq_verified', models.FileField(blank=True, max_length=10000, upload_to='seq/')),
('origin_rep', models.CharField(blank=True, max_length=50)),
('cloning_system', models.CharField(blank=True, max_length=50)),
('strand', models.CharField(blank=True, choices=[('+', 'Positive'), ('-', 'Negative')], max_length=1)),
('order_number', models.CharField(blank=True, max_length=50)),
('part_type', models.CharField(blank=True, choices=[('P', 'Promoter'), ('T', 'Terminator'), ('CDS', 'CDS'), ('CR', 'Connector_Right'), ('CL', 'Connector_Left'), ('B', 'Backbone'), ('CS', 'Counter_Screen'), ('Ma', 'Marker'), ('Mi', 'Miscellaneous')], max_length=3)),
('moclo_type', models.CharField(blank=True, max_length=5)),
('sub_sample_id', models.IntegerField(blank=True, null=True)),
('end', models.CharField(blank=True, choices=[('R', 'Right'), ('L', 'Left')], max_length=1)),
('direction', models.CharField(blank=True, choices=[('F', 'Forward'), ('R', 'Reverse')], max_length=1)),
('tm', models.IntegerField(blank=True, null=True)),
('parent_id', models.ForeignKey(blank=True, default='', null=True, on_delete=django.db.models.deletion.CASCADE, to='db.Sample')),
],
options={
'ordering': ('name',),
},
),
migrations.CreateModel(
name='Well',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=5)),
('volume', models.DecimalField(decimal_places=2, max_digits=10)),
('concentration', models.DecimalField(decimal_places=2, max_digits=10)),
('active', models.BooleanField(default=True)),
('status', models.CharField(blank=True, choices=[('G', 'On going'), ('C', 'Completed'), ('A', 'Aborted'), ('H', 'On hold')], max_length=1)),
('parent_well', models.ForeignKey(blank=True, default='', null=True, on_delete=False, to='db.Well')),
('plate', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Plate')),
('samples', models.ManyToManyField(to='db.Sample')),
],
options={
'ordering': ('name', 'plate'),
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='BaseLigand',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('name', models.CharField(blank=True, max_length=200)),
],
options={
'db_table': 'BaseLigand',
},
),
migrations.CreateModel(
name='ChemicalCompound',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('name', models.CharField(blank=True, max_length=200)),
('nick', models.CharField(blank=True, max_length=100)),
('formula', models.CharField(blank=True, max_length=100)),
('synthesis', models.TextField(blank=True)),
('analysis', models.TextField(blank=True)),
('mass',
models.FloatField(
blank=True,
null=True,
validators=[
django.core.validators.MinValueValidator(0.0)
])),
('chirality',
enumfields.fields.EnumField(blank=True,
enum=db.models.Chirality,
max_length=5,
null=True)),
],
options={
'db_table': 'ChemicalCompound',
},
),
migrations.CreateModel(
name='DataType',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('name', models.CharField(blank=True, max_length=45)),
],
options={
'db_table': 'DataType',
},
),
migrations.CreateModel(
name='FunctionalGroup',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('name', models.CharField(blank=True, max_length=100)),
],
options={
'db_table': 'FunctionalGroup',
},
),
migrations.CreateModel(
name='Ligand',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('name', models.CharField(blank=True, max_length=200)),
('nick', models.CharField(blank=True, max_length=100)),
('formula', models.CharField(blank=True, max_length=100)),
('synthesis', models.TextField(blank=True)),
('analysis', models.TextField(blank=True)),
('mass',
models.FloatField(
blank=True,
null=True,
validators=[
django.core.validators.MinValueValidator(0.0)
])),
('chirality',
enumfields.fields.EnumField(blank=True,
enum=db.models.Chirality,
max_length=5,
null=True)),
('connections',
models.PositiveIntegerField(blank=True, null=True)),
('base_ligand',
models.ForeignKey(
blank=True,
db_column='base_ligand',
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='ligands',
to='db.BaseLigand')),
],
options={
'db_table': 'Ligand',
},
),
migrations.CreateModel(
name='LigandCategory',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('name', models.CharField(blank=True, max_length=100)),
],
options={
'verbose_name': 'LigandCategory',
'verbose_name_plural': 'LigandCategories',
},
),
migrations.CreateModel(
name='Mof',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('name', models.CharField(blank=True, max_length=200)),
('nick', models.CharField(blank=True, max_length=100)),
('formula', models.CharField(blank=True, max_length=100)),
('synthesis', models.TextField(blank=True)),
('analysis', models.TextField(blank=True)),
('mass',
models.FloatField(
blank=True,
null=True,
validators=[
django.core.validators.MinValueValidator(0.0)
])),
('topology', models.CharField(blank=True, max_length=10)),
],
options={
'db_table': 'Mof',
},
),
migrations.CreateModel(
name='MofLigand',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('ligand',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='db.Ligand')),
('mof',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='db.Mof')),
],
options={
'db_table': 'Mof_Ligand',
},
),
migrations.CreateModel(
name='Reaction',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('name', models.CharField(blank=True, max_length=200)),
('notes', models.TextField(blank=True)),
],
options={
'db_table': 'Reaction',
},
),
migrations.CreateModel(
name='ReactionCatalystCC',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('rate_constant', models.FloatField(blank=True, null=True)),
('conversion', models.FloatField(blank=True, null=True)),
('ee', models.FloatField(blank=True, null=True)),
('de', models.FloatField(blank=True, null=True)),
('yield_field',
models.FloatField(blank=True, db_column='yield', null=True)),
('amount', models.FloatField(blank=True, null=True)),
('notes', models.TextField(blank=True)),
('component',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='db.ChemicalCompound')),
('reaction',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='db.Reaction')),
],
options={
'db_table': 'Reaction_Catalyst_CC',
},
),
migrations.CreateModel(
name='ReactionCatalystLigand',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('rate_constant', models.FloatField(blank=True, null=True)),
('conversion', models.FloatField(blank=True, null=True)),
('ee', models.FloatField(blank=True, null=True)),
('de', models.FloatField(blank=True, null=True)),
('yield_field',
models.FloatField(blank=True, db_column='yield', null=True)),
('amount', models.FloatField(blank=True, null=True)),
('notes', models.TextField(blank=True)),
('component',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='db.Ligand')),
('reaction',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='db.Reaction')),
],
options={
'db_table': 'Reaction_Catalyst_Ligand',
},
),
migrations.CreateModel(
name='ReactionCatalystMof',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('rate_constant', models.FloatField(blank=True, null=True)),
('conversion', models.FloatField(blank=True, null=True)),
('ee', models.FloatField(blank=True, null=True)),
('de', models.FloatField(blank=True, null=True)),
('yield_field',
models.FloatField(blank=True, db_column='yield', null=True)),
('amount', models.FloatField(blank=True, null=True)),
('notes', models.TextField(blank=True)),
('component',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='db.Mof')),
('reaction',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='db.Reaction')),
],
options={
'db_table': 'Reaction_Catalyst_Mof',
},
),
migrations.CreateModel(
name='ReactionCategory',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('name', models.CharField(blank=True, max_length=100)),
],
options={
'verbose_name': 'ReactionCategory',
'verbose_name_plural': 'ReactionCategories',
},
),
migrations.CreateModel(
name='ReactionData',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('data_file', models.FileField(upload_to='reaction_data/')),
('data_type',
models.ForeignKey(
blank=True,
on_delete=django.db.models.deletion.DO_NOTHING,
to='db.DataType')),
('reaction',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
to='db.Reaction')),
],
options={
'db_table': 'ReactionData',
},
),
migrations.CreateModel(
name='ReactionProduct',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('component',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='db.ChemicalCompound')),
('reaction',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='db.Reaction')),
],
options={
'db_table': 'Reaction_Product',
},
),
migrations.CreateModel(
name='ReactionReactant',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('component',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='db.ChemicalCompound')),
('reaction',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='db.Reaction')),
],
options={
'db_table': 'Reaction_Reactant',
},
),
migrations.CreateModel(
name='VisualizationCC',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('chemdraw', models.FileField(upload_to='visualization/cc/')),
('chemical_compound',
models.OneToOneField(
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='visualization',
to='db.ChemicalCompound')),
],
options={
'db_table': 'VisualizationCC',
},
),
migrations.CreateModel(
name='VisualizationLigand',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('chemdraw',
models.FileField(upload_to='visualization/ligand/')),
('ligand',
models.OneToOneField(
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='visualization',
to='db.Ligand')),
],
options={
'db_table': 'VisualizationLigand',
},
),
migrations.CreateModel(
name='VisualizationMof',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('cif',
models.FileField(db_column='CIF',
upload_to='visualization/mof/cif/')),
('mof',
models.OneToOneField(
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='visualization',
to='db.Mof')),
],
options={
'db_table': 'VisualizationMof',
},
),
migrations.CreateModel(
name='VisualizationReaction',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('chemdraw',
models.FileField(upload_to='visualization/reaction/')),
('reaction',
models.OneToOneField(
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='visualization',
to='db.Reaction')),
],
options={
'db_table': 'VisualizationReaction',
},
),
migrations.AddField(
model_name='reaction',
name='catalysts_cc',
field=models.ManyToManyField(blank=True,
related_name='reaction_catalysts',
through='db.ReactionCatalystCC',
to='db.ChemicalCompound'),
),
migrations.AddField(
model_name='reaction',
name='catalysts_ligand',
field=models.ManyToManyField(blank=True,
related_name='reaction_catalysts',
through='db.ReactionCatalystLigand',
to='db.Ligand'),
),
migrations.AddField(
model_name='reaction',
name='catalysts_mof',
field=models.ManyToManyField(blank=True,
related_name='reaction_catalysts',
through='db.ReactionCatalystMof',
to='db.Mof'),
),
migrations.AddField(
model_name='reaction',
name='category',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='reactions',
to='db.ReactionCategory'),
),
migrations.AddField(
model_name='reaction',
name='products',
field=models.ManyToManyField(blank=True,
related_name='reaction_products',
through='db.ReactionProduct',
to='db.ChemicalCompound'),
),
migrations.AddField(
model_name='reaction',
name='reactants',
field=models.ManyToManyField(blank=True,
related_name='reaction_reactants',
through='db.ReactionReactant',
to='db.ChemicalCompound'),
),
migrations.AddField(
model_name='mof',
name='ligands',
field=models.ManyToManyField(related_name='mofs',
through='db.MofLigand',
to='db.Ligand'),
),
migrations.AddField(
model_name='ligand',
name='category',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='ligands',
to='db.LigandCategory'),
),
migrations.AddField(
model_name='ligand',
name='functional_group',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='ligands',
to='db.FunctionalGroup'),
),
migrations.AddField(
model_name='chemicalcompound',
name='functional_group',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.DO_NOTHING,
related_name='chemicalcompound',
to='db.FunctionalGroup'),
),
]