Missing foreign key for lease6.hwaddr_source
Describe the bug
When inspecting the database structure I noticed (using PostgreSQL) that lease6.hwaddr_source
is not a foreign key to lease_hwaddr_source.hwaddr_source
. This seems inconsistent as both lease6.state
and lease6.lease_type
are foreign keys.
To Reproduce
Steps to reproduce the behavior:
- Run
kea-admin db-init pgsql
- Connect to the kea database using
psql
- Check the database schema with
\d lease6
Expected behavior
I would expect lease6.hwaddr_source
to be a foreign key as it references values in another table.
Environment:
- Kea version: isc-kea-admin, deb package 1.9.3-isc001302020121418142
- OS: Debian GNU/Linux 10 (buster)
Additional Information
None
Contacting you
sander@steffann.nl or +31-6-22660412