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.

Diese Übung ist Teil des Kurses

Creating PostgreSQL Databases

Kurs anzeigen

Anleitung zur Übung

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.

Interaktive Übung

Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.

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

Code bearbeiten und ausführen