DATA SCIENCE example

Tables (3)

Class (Untitled2)

  • id (Key) — Auto Increase — Primary key — NOT NULL
  • class_name (Field) — NOT NULL
  • professer (Field2) — NOT NULL

user (Untitled)

  • id (Key) — Auto Increase — Primary key — NOT NULL
  • name (Field) — Not NULL
  • age (Field2) — age > 20
  • email (Field3) — UNIQUE

user_class (Untitled3)

  • user_id (Key3) — Foreign key → user.id — NOT NULL
  • class_id (Key4) — Foreign key → Class.id — NOT NULL
  • likes (Field) — DEFAULT 0