sails: Waterline - I cannot set `null` on the "one" side of a one-to-many when using id columnType "bigserial" - postgres

Node version: v12.10.0 Sails version (sails): 1.2.2 ORM hook version (sails-hook-orm): 2.1.1 Sockets hook version (sails-hook-sockets): 2.0.0 Organics hook version (sails-hook-organics): 0.16.0 Grunt hook version (sails-hook-grunt): UNINSTALLED Uploads hook version (sails-hook-uploads): NOT INSTALLED DB adapter & version (e.g. sails-mysql@5.55.5): sails-postgresql@1.0.2 Skipper adapter & version (e.g. skipper-s3@5.55.5): NOT INSTALLED

I posted this on Stackoverflow too - https://stackoverflow.com/questions/58379618/nullable-value-for-a-one-to-many-relation

I cannot set null on the “one” side of a one-to-many

I have a Payment model, and I want it to optionally be related to a DonationBox. Meaning, Payments can be created without specifying a DonationBox.

Example I want to do this:

Payment.create({
    donationBox: null
})

I have a DonationBox model with this relation:

payments: {
  collection: 'payment',
  via: 'donationBox'
},

I then have a Payment model with this relation:

// Optional because some payments are not for donation boxes
donationBox: {
  model: 'donationbox',
  allowNull: true
},

However lifting with allowNull causes error:

The attribute donationBox on the payment model contains invalid properties. The allowNull flag may not be used on attributes that represent associations. For singular associations null is allowed by default.

If I remove that, then the Payment.create({ donationBox: null }) gives error:

AdapterError: Unexpected error from database adapter: null value in column “donationBox” violates not-null constraint

This error is opposite of the error given when I tried to add allowNull to the model attribute. It said that “null is allowed by default”, but it’s not the case.

Anyone know how I can set null here?