create type address as ( zip_code varchar(5), city varchar(100), street varchar(100) ); create table contact ( contact_id integer not null primary key, delivery_address address, postal_address address );
The above is an example using Postgres syntax
create type address as ( zip_code varchar(5), city varchar(100), street varchar(100) ); create table contact ( contact_id integer not null primary key, delivery_address address, postal_address address );
The above is an example using Postgres syntax