startapp

eunseongc · Dec 31, 2019 · 31c363c · 31c363c
1 parent 157437b
commit 31c363c
Show file tree

Hide file tree

Showing 14 changed files with 401 additions and 0 deletions.
diff --git a/startapp/__init__.py b/startapp/__init__.py
diff --git a/startapp/__pycache__/__init__.cpython-36.pyc b/startapp/__pycache__/__init__.cpython-36.pyc
diff --git a/startapp/__pycache__/admin.cpython-36.pyc b/startapp/__pycache__/admin.cpython-36.pyc
diff --git a/startapp/__pycache__/apps.cpython-36.pyc b/startapp/__pycache__/apps.cpython-36.pyc
diff --git a/startapp/__pycache__/models.cpython-36.pyc b/startapp/__pycache__/models.cpython-36.pyc
diff --git a/startapp/admin.py b/startapp/admin.py
@@ -0,0 +1,14 @@
+from django.contrib import admin
+
+from .models import Members
+from .models import Cases
+from .models import Membercases
+from .models import Videos
+from .models import Marks
+# Register your models here.
+
+admin.site.register(Members)
+admin.site.register(Cases)
+admin.site.register(Membercases)
+admin.site.register(Videos)
+admin.site.register(Marks)
diff --git a/startapp/apps.py b/startapp/apps.py
@@ -0,0 +1,5 @@
+from django.apps import AppConfig
+
+
+class StartappConfig(AppConfig):
+    name = 'startapp'
diff --git a/startapp/migrations/0001_initial.py b/startapp/migrations/0001_initial.py
@@ -0,0 +1,201 @@
+# Generated by Django 3.0.1 on 2019-12-31 08:29
+
+from django.db import migrations, models
+import django.db.models.deletion
+
+
+class Migration(migrations.Migration):
+
+    initial = True
+
+    dependencies = [
+    ]
+
+    operations = [
+        migrations.CreateModel(
+            name='AuthGroup',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('name', models.CharField(max_length=150, unique=True)),
+            ],
+            options={
+                'db_table': 'auth_group',
+                'managed': False,
+            },
+        ),
+        migrations.CreateModel(
+            name='AuthGroupPermissions',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+            ],
+            options={
+                'db_table': 'auth_group_permissions',
+                'managed': False,
+            },
+        ),
+        migrations.CreateModel(
+            name='AuthPermission',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('name', models.CharField(max_length=255)),
+                ('codename', models.CharField(max_length=100)),
+            ],
+            options={
+                'db_table': 'auth_permission',
+                'managed': False,
+            },
+        ),
+        migrations.CreateModel(
+            name='AuthUser',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('password', models.CharField(max_length=128)),
+                ('last_login', models.DateTimeField(blank=True, null=True)),
+                ('is_superuser', models.IntegerField()),
+                ('username', models.CharField(max_length=150, unique=True)),
+                ('first_name', models.CharField(max_length=30)),
+                ('last_name', models.CharField(max_length=150)),
+                ('email', models.CharField(max_length=254)),
+                ('is_staff', models.IntegerField()),
+                ('is_active', models.IntegerField()),
+                ('date_joined', models.DateTimeField()),
+            ],
+            options={
+                'db_table': 'auth_user',
+                'managed': False,
+            },
+        ),
+        migrations.CreateModel(
+            name='AuthUserGroups',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+            ],
+            options={
+                'db_table': 'auth_user_groups',
+                'managed': False,
+            },
+        ),
+        migrations.CreateModel(
+            name='AuthUserUserPermissions',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+            ],
+            options={
+                'db_table': 'auth_user_user_permissions',
+                'managed': False,
+            },
+        ),
+        migrations.CreateModel(
+            name='Cases',
+            fields=[
+                ('caseid', models.AutoField(primary_key=True, serialize=False)),
+                ('doclink', models.CharField(blank=True, max_length=300, null=True)),
+                ('hash', models.CharField(max_length=300)),
+                ('qrlink', models.CharField(max_length=300)),
+            ],
+            options={
+                'db_table': 'cases',
+                'managed': False,
+            },
+        ),
+        migrations.CreateModel(
+            name='DjangoAdminLog',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('action_time', models.DateTimeField()),
+                ('object_id', models.TextField(blank=True, null=True)),
+                ('object_repr', models.CharField(max_length=200)),
+                ('action_flag', models.PositiveSmallIntegerField()),
+                ('change_message', models.TextField()),
+            ],
+            options={
+                'db_table': 'django_admin_log',
+                'managed': False,
+            },
+        ),
+        migrations.CreateModel(
+            name='DjangoContentType',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('app_label', models.CharField(max_length=100)),
+                ('model', models.CharField(max_length=100)),
+            ],
+            options={
+                'db_table': 'django_content_type',
+                'managed': False,
+            },
+        ),
+        migrations.CreateModel(
+            name='DjangoMigrations',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('app', models.CharField(max_length=255)),
+                ('name', models.CharField(max_length=255)),
+                ('applied', models.DateTimeField()),
+            ],
+            options={
+                'db_table': 'django_migrations',
+                'managed': False,
+            },
+        ),
+        migrations.CreateModel(
+            name='DjangoSession',
+            fields=[
+                ('session_key', models.CharField(max_length=40, primary_key=True, serialize=False)),
+                ('session_data', models.TextField()),
+                ('expire_date', models.DateTimeField()),
+            ],
+            options={
+                'db_table': 'django_session',
+                'managed': False,
+            },
+        ),
+        migrations.CreateModel(
+            name='Members',
+            fields=[
+                ('memberid', models.AutoField(primary_key=True, serialize=False)),
+                ('id', models.CharField(blank=True, max_length=50, null=True)),
+                ('pw', models.CharField(max_length=100)),
+            ],
+            options={
+                'db_table': 'members',
+                'managed': False,
+            },
+        ),
+        migrations.CreateModel(
+            name='Marks',
+            fields=[
+                ('memberid', models.OneToOneField(db_column='memberid', on_delete=django.db.models.deletion.DO_NOTHING, primary_key=True, serialize=False, to='startapp.Members')),
+            ],
+            options={
+                'db_table': 'marks',
+                'managed': False,
+            },
+        ),
+        migrations.CreateModel(
+            name='Membercases',
+            fields=[
+                ('memberid', models.OneToOneField(db_column='memberid', on_delete=django.db.models.deletion.DO_NOTHING, primary_key=True, serialize=False, to='startapp.Members')),
+            ],
+            options={
+                'db_table': 'membercases',
+                'managed': False,
+            },
+        ),
+        migrations.CreateModel(
+            name='Videos',
+            fields=[
+                ('caseid', models.OneToOneField(db_column='caseid', on_delete=django.db.models.deletion.DO_NOTHING, primary_key=True, serialize=False, to='startapp.Cases')),
+                ('videoid', models.IntegerField()),
+                ('videolink', models.CharField(max_length=300)),
+                ('metadata', models.CharField(blank=True, max_length=300, null=True)),
+                ('thumbnaillink', models.CharField(blank=True, max_length=300, null=True)),
+                ('videolength', models.IntegerField(blank=True, null=True)),
+                ('timestamp', models.DateTimeField()),
+            ],
+            options={
+                'db_table': 'videos',
+                'managed': False,
+            },
+        ),
+    ]
diff --git a/startapp/migrations/__init__.py b/startapp/migrations/__init__.py
diff --git a/startapp/migrations/__pycache__/0001_initial.cpython-36.pyc b/startapp/migrations/__pycache__/0001_initial.cpython-36.pyc
diff --git a/startapp/migrations/__pycache__/__init__.cpython-36.pyc b/startapp/migrations/__pycache__/__init__.cpython-36.pyc
diff --git a/startapp/models.py b/startapp/models.py
@@ -0,0 +1,175 @@
+# This is an auto-generated Django model module.
+# You'll have to do the following manually to clean this up:
+#   * Rearrange models' order
+#   * Make sure each model has one field with primary_key=True
+#   * Make sure each ForeignKey and OneToOneField has `on_delete` set to the desired behavior
+#   * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table
+# Feel free to rename the models, but don't rename db_table values or field names.
+from django.db import models
+
+
+class AuthGroup(models.Model):
+    name = models.CharField(unique=True, max_length=150)
+
+    class Meta:
+        managed = False
+        db_table = 'auth_group'
+
+
+class AuthGroupPermissions(models.Model):
+    group = models.ForeignKey(AuthGroup, models.DO_NOTHING)
+    permission = models.ForeignKey('AuthPermission', models.DO_NOTHING)
+
+    class Meta:
+        managed = False
+        db_table = 'auth_group_permissions'
+        unique_together = (('group', 'permission'),)
+
+
+class AuthPermission(models.Model):
+    name = models.CharField(max_length=255)
+    content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING)
+    codename = models.CharField(max_length=100)
+
+    class Meta:
+        managed = False
+        db_table = 'auth_permission'
+        unique_together = (('content_type', 'codename'),)
+
+
+class AuthUser(models.Model):
+    password = models.CharField(max_length=128)
+    last_login = models.DateTimeField(blank=True, null=True)
+    is_superuser = models.IntegerField()
+    username = models.CharField(unique=True, max_length=150)
+    first_name = models.CharField(max_length=30)
+    last_name = models.CharField(max_length=150)
+    email = models.CharField(max_length=254)
+    is_staff = models.IntegerField()
+    is_active = models.IntegerField()
+    date_joined = models.DateTimeField()
+
+    class Meta:
+        managed = False
+        db_table = 'auth_user'
+
+
+class AuthUserGroups(models.Model):
+    user = models.ForeignKey(AuthUser, models.DO_NOTHING)
+    group = models.ForeignKey(AuthGroup, models.DO_NOTHING)
+
+    class Meta:
+        managed = False
+        db_table = 'auth_user_groups'
+        unique_together = (('user', 'group'),)
+
+
+class AuthUserUserPermissions(models.Model):
+    user = models.ForeignKey(AuthUser, models.DO_NOTHING)
+    permission = models.ForeignKey(AuthPermission, models.DO_NOTHING)
+
+    class Meta:
+        managed = False
+        db_table = 'auth_user_user_permissions'
+        unique_together = (('user', 'permission'),)
+
+
+class Cases(models.Model):
+    caseid = models.AutoField(primary_key=True)
+    doclink = models.CharField(max_length=300, blank=True, null=True)
+    hash = models.CharField(max_length=300)
+    qrlink = models.CharField(max_length=300)
+
+    class Meta:
+        managed = False
+        db_table = 'cases'
+
+
+class DjangoAdminLog(models.Model):
+    action_time = models.DateTimeField()
+    object_id = models.TextField(blank=True, null=True)
+    object_repr = models.CharField(max_length=200)
+    action_flag = models.PositiveSmallIntegerField()
+    change_message = models.TextField()
+    content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING, blank=True, null=True)
+    user = models.ForeignKey(AuthUser, models.DO_NOTHING)
+
+    class Meta:
+        managed = False
+        db_table = 'django_admin_log'
+
+
+class DjangoContentType(models.Model):
+    app_label = models.CharField(max_length=100)
+    model = models.CharField(max_length=100)
+
+    class Meta:
+        managed = False
+        db_table = 'django_content_type'
+        unique_together = (('app_label', 'model'),)
+
+
+class DjangoMigrations(models.Model):
+    app = models.CharField(max_length=255)
+    name = models.CharField(max_length=255)
+    applied = models.DateTimeField()
+
+    class Meta:
+        managed = False
+        db_table = 'django_migrations'
+
+
+class DjangoSession(models.Model):
+    session_key = models.CharField(primary_key=True, max_length=40)
+    session_data = models.TextField()
+    expire_date = models.DateTimeField()
+
+    class Meta:
+        managed = False
+        db_table = 'django_session'
+
+
+class Marks(models.Model):
+    memberid = models.OneToOneField('Members', models.DO_NOTHING, db_column='memberid', primary_key=True)
+    caseid = models.ForeignKey('Videos', models.DO_NOTHING, db_column='caseid', related_name='Marks_caseid')
+    videoid = models.ForeignKey('Videos', models.DO_NOTHING, db_column='videoid', related_name='Marks_videoid')
+
+    class Meta:
+        managed = False
+        db_table = 'marks'
+        unique_together = (('memberid', 'caseid', 'videoid'),)
+
+
+class Membercases(models.Model):
+    memberid = models.OneToOneField('Members', models.DO_NOTHING, db_column='memberid', primary_key=True)
+    caseid = models.ForeignKey(Cases, models.DO_NOTHING, db_column='caseid')
+
+    class Meta:
+        managed = False
+        db_table = 'membercases'
+        unique_together = (('memberid', 'caseid'),)
+
+
+class Members(models.Model):
+    memberid = models.AutoField(primary_key=True)
+    id = models.CharField(max_length=50, blank=True, null=True)
+    pw = models.CharField(max_length=100)
+
+    class Meta:
+        managed = False
+        db_table = 'members'
+
+
+class Videos(models.Model):
+    caseid = models.OneToOneField(Cases, models.DO_NOTHING, db_column='caseid', primary_key=True)
+    videoid = models.IntegerField()
+    videolink = models.CharField(max_length=300)
+    metadata = models.CharField(max_length=300, blank=True, null=True)
+    thumbnaillink = models.CharField(max_length=300, blank=True, null=True)
+    videolength = models.IntegerField(blank=True, null=True)
+    timestamp = models.DateTimeField()
+
+    class Meta:
+        managed = False
+        db_table = 'videos'
+        unique_together = (('caseid', 'videoid'),)