Contents

create table addresses (
  zip_code char(7) not null,
  prefecture_code char(2) not null,
  prefecture_name varchar(4) not null,
  city varchar(255) not null,
  section varchar(255) not null
);

create unique index index_zip_code_on_addresses on addresses(zip_code);

Version data entries

52 entries across 52 versions & 1 rubygems

Version	Path
tax_jp-1.2.12	data/住所/schema_addresses.sql
tax_jp-1.2.11	data/住所/schema_addresses.sql
tax_jp-1.2.10	data/住所/schema_addresses.sql
tax_jp-1.2.9	data/住所/schema_addresses.sql
tax_jp-1.2.8	data/住所/schema_addresses.sql
tax_jp-1.2.7	data/住所/schema_addresses.sql
tax_jp-1.2.6	data/住所/schema_addresses.sql
tax_jp-1.2.5	data/住所/schema_addresses.sql
tax_jp-1.2.4	data/住所/schema_addresses.sql
tax_jp-1.2.3	data/住所/schema_addresses.sql
tax_jp-1.2.2	data/住所/schema_addresses.sql
tax_jp-1.2.1	data/住所/schema_addresses.sql
tax_jp-1.2.0	data/住所/schema_addresses.sql
tax_jp-1.1.12	data/住所/schema_addresses.sql
tax_jp-1.1.11	data/住所/schema_addresses.sql
tax_jp-1.1.10	data/住所/schema_addresses.sql
tax_jp-1.1.9	data/住所/schema_addresses.sql
tax_jp-1.1.8	data/住所/schema_addresses.sql
tax_jp-1.1.7	data/住所/schema_addresses.sql
tax_jp-1.1.6	data/住所/schema_addresses.sql