数据库系统大作业-基于Python的科研管理系统

# Generated by Django 4.2.8 on 2023-12-11 15:12 from django.db import migrations, models import django.db.models.deletion class Migration(migrations.Migration): initial = True dependencies = [] operations = [ migrations.CreateModel( name="Linkman", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("name", models.CharField(max_length=30, unique=True)), ( "phonenumber", models.CharField(db_column="phoneNumber", max_length=20), ), ("email", models.CharField(blank=True, max_length=30, null=True)), ("type", models.CharField(max_length=1)), ], options={ "db_table": "linkman", }, ), migrations.CreateModel( name="Researcher", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("name", models.CharField(max_length=30, unique=True)), ("sex", models.CharField(blank=True, max_length=1, null=True)), ("title", models.CharField(blank=True, max_length=30, null=True)), ("age", models.IntegerField(blank=True, null=True)), ( "researchdirection", models.CharField(db_column="researchDirection", max_length=30), ), ], options={ "db_table": "researcher", }, ), migrations.CreateModel( name="Researchproject", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("name", models.CharField(max_length=30, unique=True)), ( "researchdirection", models.CharField(db_column="researchDirection", max_length=200), ), ("fund", models.IntegerField()), ( "starttime", models.DateField(blank=True, db_column="startTime", null=True), ), ( "endtime", models.DateField(blank=True, db_column="endTime", null=True), ), ( "leaderid", models.ForeignKey( blank=True, db_column="leaderId", null=True, on_delete=django.db.models.deletion.DO_NOTHING, to="app01.researcher", ), ), ], options={ "db_table": "researchproject", }, ), migrations.CreateModel( name="Secretary", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("name", models.CharField(max_length=30, unique=True)), ("sex", models.CharField(blank=True, max_length=1, null=True)), ("age", models.IntegerField(blank=True, null=True)), ("employmenttime", models.DateField(blank=True, null=True)), ( "responsibility", models.CharField(blank=True, max_length=30, null=True), ), ], options={ "db_table": "secretary", }, ), migrations.CreateModel( name="Subproject", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("name", models.CharField(max_length=30, unique=True)), ( "researchdirection", models.CharField(db_column="researchDirection", max_length=200), ), ("fund", models.IntegerField()), ("deadline", models.DateField(blank=True, null=True)), ( "leaderid", models.ForeignKey( blank=True, db_column="leaderId", null=True, on_delete=django.db.models.deletion.DO_NOTHING, to="app01.researcher", ), ), ( "projectid", models.ForeignKey( db_column="projectId", on_delete=django.db.models.deletion.DO_NOTHING, to="app01.researchproject", ), ), ], options={ "db_table": "subproject", }, ), migrations.CreateModel( name="Scientificpayoffs", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("name", models.CharField(max_length=30, unique=True)), ("type", models.CharField(max_length=1)), ("gettime", models.DateField(db_column="getTime")), ("ranking", models.IntegerField(blank=True, null=True)), ( "projectid", models.ForeignKey( db_column="projectId", on_delete=django.db.models.deletion.DO_NOTHING, to="app01.researchproject", ), ), ], options={ "db_table": "scientificpayoffs", }, ), migrations.CreateModel( name="Researchroomlist", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("name", models.CharField(max_length=30, unique=True)), ( "researchdirection", models.CharField(db_column="researchDirection", max_length=30), ), ( "secretaryid", models.ForeignKey( blank=True, db_column="secretaryID", null=True, on_delete=django.db.models.deletion.DO_NOTHING, to="app01.secretary", ), ), ],