postcode-migration.V1.000__setup.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of postcode Show documentation

SQL model for UK postcode data

The newest version!

create schema postcode;

create table postcode.postcode (
postcode varchar not null primary key,
items jsonb,
address_ref varchar,
city varchar);


create table postcode.address(
id varchar not null primary key,
items jsonb);