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.
Este exercício faz parte do curso
Creating PostgreSQL Databases
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
-- Create a table named 'bank' in the 'loan_504' schema
CREATE TABLE ___.bank (
id serial PRIMARY KEY,
___ VARCHAR (___) NOT NULL
);