| use dataverse demo0927; | |
| declare type CustomerType as closed { | |
| cid: int32, | |
| name: string, | |
| age: int32?, | |
| address: AddressType?, | |
| lastorder: { | |
| oid: int32, | |
| total: float | |
| } | |
| } | |
| declare type AddressType as closed { | |
| number: int32, | |
| street: string, | |
| city: string | |
| } | |
| declare nodegroup group1 on nc1,nc2; | |
| declare dataset Customers(CustomerType) | |
| primary key cid on group1; | |
| create index NameIndex on Customers(name); |