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)