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
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information