Update nullable foreign keys to be non-nullable - Githubissues

keygen-sh / keygen-api

Keygen is a fair source software licensing and distribution API built with Ruby on Rails. For developers, by developers.

https://keygen.sh

Other

699 stars 40 forks source link

Update nullable foreign keys to be non-nullable #818

Open ezekg opened 2 months ago

ezekg commented 2 months ago

For correctness, and also for query performance via query planner optimizations.

[ ] billings.account_id
[ ] keys.account_id
[ ] keys.policy_id
[x] licenses.account_id (#819)
[x] licenses.policy_id (#820)
[x] licenses.product_id (#817)
[x] machines.account_id (#822)
[x] machines.license_id (#823)
[ ] metrics.account_id
[x] policies.account_id (#826)
[x] policies.product_id (#828)
[x] products.account_id (#825)
[ ] request_logs.account_id
[ ] roles.resource_id
[ ] roles.resource_type
[ ] tokens.account_id
[ ] tokens.bearer_id
[ ] tokens.bearer_type
[x] users.account_id (#821)
[ ] webhook_endpoints.account_id
[ ] webhook_events.account_id

Ref: https://gist.github.com/ezekg/3bbc5e91d9f1211115c956a7f09d924b