1 vote
Accepted

How to create unique id in flutter to add in the database

You can use the package named as a UUID (https://pub.dev/packages/uuid). import 'package:uuid/uuid.dart'; var uuid = Uuid(); You can create like below // Generate a v1 (time-based) id uuid.v1(); // -...
Prashant Vaddoriya's user avatar
1 vote
Accepted

Enforce uniqueness on combination of columns + aggregate function

Unfortunately, @SQLpro's answer isn't going to work, because STRING_AGG is not supported in Indexed Views. You can instead use a trigger to enforce this, by storing the aggregated TypeId back into ...
Charlieface's user avatar
  • 12.7k

Only top scored, non community-wiki answers of a minimum length are eligible