Models for User

Tables (4)

Log (logs)

  • id (Key) — Primary key — NOT NULL
  • actor_id (Key2) — Foreign key → User.id — NOT NULL
  • type (Field)
  • fk (Field2)
  • action (Field3)
  • time (Field4)

Profie (profiles)

  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • email (Field2) — String
  • team (Field3)

Statistic (statistics)

  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • testIncomplete (Field)
  • testReviewComplete (Field2)
  • testComplete (Field3)
  • testOverDue (Field4)
  • controlIncomplete (Field5)
  • controlReject (Field6)
  • controlComplete (Field7)

User (users)

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