ipv4_addresses.sql
1 CREATE TABLE ipv4_addresses ( 2 id UUID PRIMARY KEY DEFAULT generate_uuid_v7(), 3 resource_id UUID NOT NULL REFERENCES resources(id), 4 address_ipv4 ip4 NOT NULL, 5 created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP, 6 modified_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP, 7 UNIQUE (resource_id), 8 UNIQUE (address_ipv4) 9 );