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