Mission

Tables (4)

Users (Untitled)

  • id (key) — int — Primary key — NOT NULL
  • username — varchar(20)
  • password — varchar(20)
  • email — varchar(20)

home_page (Untitled4)

  • id — Int — Primary key — NOT NULL
  • id (key) — int — Foreign key → Users.id — NOT NULL
  • point_id — Int

missions (Untitled2)

  • id — int — Primary key — NOT NULL
  • id (key) — int — Foreign key → Users.id — NOT NULL
  • description — varchar(20)
  • point_mission — int

point (Untitled3)

  • id — Int — Primary key — NOT NULL
  • id (key) — int — Foreign key → Users.id — NOT NULL
  • point_id — Int
  • point_total — int