DB schema changed

uoo723 · Dec 31, 2019 · 5a4cd46 · 5a4cd46
1 parent eaec812
commit 5a4cd46
Show file tree

Hide file tree

Showing 4 changed files with 20 additions and 11 deletions.
diff --git a/Django-3.0.1/django/bin/sample/app_sample/__pycache__/admin.cpython-36.pyc b/Django-3.0.1/django/bin/sample/app_sample/__pycache__/admin.cpython-36.pyc
diff --git a/Django-3.0.1/django/bin/sample/app_sample/__pycache__/models.cpython-36.pyc b/Django-3.0.1/django/bin/sample/app_sample/__pycache__/models.cpython-36.pyc
diff --git a/Django-3.0.1/django/bin/sample/app_sample/admin.py b/Django-3.0.1/django/bin/sample/app_sample/admin.py
@@ -7,6 +7,11 @@
 from .models import Marks
 # Register your models here.
 
+
+class MemberAdmin(admin.ModelAdmin):
+    list_display = []
+
+
 admin.site.register(Members)
 admin.site.register(Cases)
 admin.site.register(Membercases)

diff --git a/Django-3.0.1/django/bin/sample/app_sample/models.py b/Django-3.0.1/django/bin/sample/app_sample/models.py
@@ -129,6 +129,17 @@ class Meta:
         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')
@@ -153,19 +164,12 @@ 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'),)
-
-
-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='markscaseid')
-    videoid = models.ForeignKey('Videos', models.DO_NOTHING, db_column='videoid', related_name='marksvideoid')
-
-    class Meta:
-        managed = False
-        db_table = 'marks'
-        unique_together = (('memberid', 'caseid', 'videoid'),)