Models for File

Tables (4)

File (files)

  • id (Key) — Primary key — NOT NULL
  • author_id (Key2) — Foreign key → User.id — NOT NULL
  • test_id (Key3) — Foreign key → Test.id — NOT NULL
  • editor_id (Field)
  • title (Field2)
  • created_time (Field4)
  • updated_time (Field3)
  • due_date (Field5)
  • url (Field7)
  • assigned_time (Field6)
  • parent_id (Field8)
  • related_count (Field9)

StarredFile (starred_file)

  • user_id (Key3) — Foreign key → User.id — NOT NULL
  • file_id (Key4) — Foreign key → File.id — NOT NULL
  • created_time (Field)

Test (tests)

  • id (Key) — Primary key — NOT NULL
  • author_id (Key4) — Foreign key → User.id — NOT NULL
  • status (Field2)
  • created_time (Field3)
  • updated_time (Field4)
  • due_date (Field6)

User (users)

  • id (Key) — Primary key — NOT NULL
  • username (Key2) — NOT NULL
  • password (Field2)
  • frist_name (Field)
  • last_name (Field3)
  • is_admin (Field4)