Kestrel is adding a points program, and you're building its tables. Each task is checked by reading the database catalog or by trying inserts that your rules must refuse, so constraints have to be real.
Plan before typing: which columns are required, which must be unique, which must point at another table, and what each check should allow. Remember that the database here doesn't support ON DELETE CASCADE, and that a new column with a default fills existing rows.