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.
Bu egzersiz
Creating PostgreSQL Databases
kursunun bir parçasıdırEgzersiz talimatları
- Create a table named
appealwhich includes a unique identifier,id, as well as a column namedcontentallowing the storage of as much text as required for the applicant to make her case.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Create the appeal table
___ ___ ___ (
-- Specify the unique identifier column
___ SERIAL ___ ___,
-- Define a column for holding the text of the appeals
___ ___ NOT NULL
);