SBA appeals table

In managing the SBA database, it would be helpful for applicants that were denied a loan to have an electronic appeal process that would allow the rejected loan application to be reconsidered. The focus of this exercise will be on designing a table to store both the appeal and the accompanying text describing the justification for reconsideration.

Deze oefening maakt deel uit van de cursus

Creating PostgreSQL Databases

Cursus bekijken

Oefeninstructies

Create a table named appeal which includes a unique identifier,id, as well as a column named content allowing the storage of as much text as required for the applicant to make her case.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

-- Create the appeal table
___ ___ ___ (
    -- Specify the unique identifier column
	___ SERIAL ___ ___,
    -- Define a column for holding the text of the appeals
    ___ ___ NOT NULL
);

Code bewerken en uitvoeren