 CREATE VIEW view_addresses AS
 SELECT
 addresses.address_id,
-addresses.site_id,
 addresses.line1,
 addresses.line2,
 addresses.line3,

-- Each mailing address can be one of several types
CREATE TABLE address_address_type (
    address_id integer REFERENCES addresses NOT NULL, -- Address identifier
    address_type_id integer REFERENCES address_types NOT NULL -- Address type
) WITH OIDS;

CREATE VIEW address_address_types AS
SELECT address_id,

-- Slivers
CREATE TABLE slice_node (
    slice_id integer REFERENCES slices NOT NULL, -- Slice identifier
    node_id integer REFERENCES nodes NOT NULL, -- Node identifier
    PRIMARY KEY (slice_id, node_id)
) WITH OIDS;
CREATE INDEX slice_node_slice_id_idx ON slice_node (slice_id);
CREATE INDEX slice_node_node_id_idx ON slice_node (node_id);
