Creating tables in existing schemas
The SBA provides twelve different funding opportunities. Two popular programs are the 7a and 504 programs. These loans have different purposes where 504 loans are typically used for real estate purchases and 7a loans are typically for general business needs. You have been tasked with the creation of tables which share a name but allow for different structures within their respective schemas. The schemas for these loans have already been created for you (named loan_7a and loan_504, respectively).
You will now put your knowledge to use to add new tables to these existing schemas.
Cet exercice fait partie du cours
Creating PostgreSQL Databases
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
-- Create a table named 'bank' in the 'loan_504' schema
CREATE TABLE ___.bank (
id serial PRIMARY KEY,
___ VARCHAR (___) NOT NULL
);