/ learning / sql / src / tables / ipv4_addresses.sql
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  );