Creating PostgreSQL Databases
Darryl Reeves
Industry Assistant Professor, New York University
CREATE TABLE loan (
borrower_id INTEGER REFERENCES borrower(id),
bank_name VARCHAR(50) DEFAULT NULL,
...
);
CREATE TABLE bank (
id SERIAL PRIMARY KEY,
name VARCHAR(50) DEFAULT NULL,
...
);
CREATE TABLE loan (
borrower_id INTEGER REFERENCES borrower(id),
bank_name VARCHAR(50) DEFAULT NULL,
...
);
CREATE TABLE bank (
id SERIAL PRIMARY KEY,
name VARCHAR(50) DEFAULT NULL,
...
);
CREATE TABLE loan (
borrower_id INTEGER REFERENCES borrower(id),
bank_id INTEGER REFERENCES bank(id),
...
);
applicant
id | name |
---|---|
1 | Jane Simmmons |
2 | Rick Demps |
3 | Pam Jones |
borrower
id | name |
---|---|
1 | Jack Smith |
2 | Sara Williams |
3 | Jennifer Valdez |
applicant
id | name |
---|---|
1 | Jane Simmmons |
2 | Rick Demps |
3 | Pam Jones |
borrower
id | name |
---|---|
1 | Jack Smith |
2 | Sara Williams |
3 | Jennifer Valdez |
4 | Pam Jones |
applicant
id | name |
---|---|
1 | Jane Simmmons |
2 | Rick Demps |
3 | Pam Jones |
borrower
id | name |
---|---|
1 | Jack Smith |
2 | Sara Williams |
3 | Jennifer Valdez |
applicant
id | name |
---|---|
1 | Jane Simmmons |
2 | Rick Demps |
borrower
id | name |
---|---|
1 | Jack Smith |
2 | Sara Williams |
3 | Jennifer Valdez |
4 | Pam Jones |
CREATE TABLE borrower (
id SERIAL PRIMARY KEY,
name VARCHAR(50) NOT NULL
);
CREATE TABLE borrower (
id SERIAL PRIMARY KEY,
name VARCHAR(50) NOT NULL,
approved BOOLEAN DEFAULT NULL
);
approved
is NULL
=> applicantapproved
is true
=> borrowerapproved
is false
=> denied applicationCreating PostgreSQL Databases