How to pass references in schemafull tables 1-N

[ndrean]

Ref: #1604 (comment)
Have you defined the fields for the array? DEFINE FIELD r ON t TYPE array; DEFINE FIELD r.* ON t TYPE record(r);

This could probably be added to the documentation because I did not find any mention to the type array or record. A typical use case is with a one-to-many with schemafull tables, then the first table should contain an array of records of references of the second table to enforce safety.

DEFINE TABLE many SCHEMAFULL;

DEFINE TABLE one SCHEMAFULL;
DEFINE FIELD m ON one TYPE array;
DEFINE FIELD m.* ON one TYPE record(many);

CREATE many:1;
CREATE many:2;

CREATE one:1 SET m=[many:1, many:2, 'something'], bad='field'

returns the expected filtering. Nice!

[{"time":"195.291µs","status":"OK","result":[{"id":"one:1","m":["many:1","many:2"]}]}]