week1

Tables (3)

Untitled

  • PK (id) — Primary key — NOT NULL
  • FK (user_id) — Primary key — NOT NULL
  • FK (mission_id) — Primary key — NOT NULL

mission (store)

  • PK (id) — int — Primary key — NOT NULL
  • FK (user_id) — Primary key — NOT NULL
  • PK (id2) — int — Foreign key → user.PK — NOT NULL
  • Field (title)
  • Field (description)
  • Field (status)
  • Field
  • PK (id3) — int — Foreign key → user.PK — NOT NULL

user

  • PK (id) — int — Primary key — NOT NULL
  • Field (name)
  • Field2 (email)
  • Field3 (password)
  • Field (points)