UMC-first week assignment

Tables (5)

Food (Food type)

  • Key1 — Foreign key → User.Key1 — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7
  • Field8
  • Field9
  • Field10
  • Field11
  • Field12

Login (Login info)

  • Key1 — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Key2 — NOT NULL
  • Key — NOT NULL

Mission (Mission info)

  • Field5 — Primary key
  • Key1 — Foreign key → User.Key1 — NOT NULL
  • Field2
  • Field3
  • Field4
  • Field

Restaurant Info (Restaurant info)

  • Field5 — Foreign key → Mission.Field5
  • Field
  • Field2
  • Field3
  • Field4

User (User info)

  • Key1 — Foreign key → Login.Key1 — NOT NULL
  • Field2
  • Field3
  • Field
  • Field5
  • Field4
  • Field6