Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

【PostgreSQL設計ガイドライン】NOT NULLの補足 #43

Open
ma91n opened this issue Feb 7, 2025 · 0 comments
Open

【PostgreSQL設計ガイドライン】NOT NULLの補足 #43

ma91n opened this issue Feb 7, 2025 · 0 comments
Labels
enhancement New feature or request

Comments

@ma91n
Copy link
Collaborator

ma91n commented Feb 7, 2025

以下のようなアクセスユースケースが存在した場合に、NULL許容に定義変更することがアンチパターンかも知れない点を追記

  • 一時保存(仮登録)であるため、全項目を入力させることができない。そのためNULL許容にする
  • 一時保存(仮登録)は別テーブルに保存することで回避可能(この考え方も一般的)
@ma91n ma91n added the enhancement New feature or request label Feb 7, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant