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

Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.

-- 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