Skip to content

Latest commit

 

History

History
37 lines (27 loc) · 873 Bytes

postgresql_test.md

File metadata and controls

37 lines (27 loc) · 873 Bytes

Report on test

Table test.address

Address table. Many persons may have the same address.

Columns

Name Constraints Type Comment
pk_address_id PK, Not Null int4 Primary Key of address
street varchar(80) Street part of an address, if applicable
house_no varchar(10)
city varchar(80)
state_province varchar(80)
postal_code varchar(20)
country varchar(80)

Table test.person

Columns

Name Constraints Type Comment
pk_person_id PK, Not Null int4
first_name Not Null varchar(80)
last_name Not Null varchar(80)
date_of_birth Not Null date

Table test.person_address

Columns

Name Constraints Type Comment
fk_adress_id FK (table: test.address) int4
fk_person_id FK (table: test.person) int4