Permalink
Find file
be7b513 Jun 26, 2011
15 lines (14 sloc) 582 Bytes
CREATE TABLE `postal_addresses` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`thing_id` bigint(20) NOT NULL COMMENT 'Link to things table',
`contact_point_id` bigint(20) DEFAULT NULL COMMENT 'Link to contact_points table',
`post_office_box_number` varchar(255) DEFAULT NULL,
`street_address` varchar(255) DEFAULT NULL,
`address_locality` varchar(255) DEFAULT NULL,
`address_region` varchar(255) DEFAULT NULL,
`postal_code` varchar(255) DEFAULT NULL,
`country_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
)
COMMENT='Defined at http://schema.org/PostalAddress'
;