| Table of Contents |
|---|
...
| Property | Type | Default | Required | Notes |
|---|---|---|---|---|
id | UUID | N | UUID of this Title - system generated if not provided | |
| poLineId | UUID | Y | UUID of the purchase order line this Title is associated with, Foreign Key | |
| title | string | Y | The title of the work | |
| instanceId | UUID | N | UUID of the instance associated with this Title - Invalid to have both this and containerId simultaneously | |
| productIds | productId | N | An array of productIds - each with: id, productIdType, qualifier NOTE: ISBNs will need to be validated and converted to ISBN-13 | |
| contributors | contributor | N | An array of contributors - each with: contributor, contributorNameTypeId | |
publisher | string | N | Publisher of the material | |
| publishedDate | string | N | date (year) of the material's publication - limited to exactly 4 digits | |
| edition | string | N | Edition of the material | |
subscriptionFrom | date-time | N | Start date of the subscription - currently lives in po_line → details | |
| subscriptionTo | date-time | N | End date of the subscription - currently lives in po_line → details | |
| subsriptionInterval | integer | N | the subscription interval in days - currently lives in po_line → details | |
| isAcknowledged | boolean | false | N | Flag for acknowledge receiving note (introduced in UIREC-32) |
| packageName | string | N | The name of the package. Copied from the package POL's titleOrPackage field | |
| poLineNumber | string | N | The poLineNumber of the POL identified by poLineId | |
| receivingNote | string | N | Receiving note from the POL identified by poLineId - currently lives in po_line → details | |
| metadata | metadata | N | System generated record metadata |
...
- Rename "title" to "titleOrPackage"
- remains required
- either the title of the individual work or the package name
- in the case of an individual work, this data is essentially duplicated from the one Title record associated with this POL.
- This is done to help with display of POLs in search/filter & PO detail views
- Add "isPackage"
- Boolean, not required, default=false
- Indicates that this POL is for a package
Add "containerId"UUID of the inventory container record associated with this Titlenot required, no default
- NOTE: instanceId remains here.
pieces
The pieces schema changes as follows:
- Add "titleId"
- UUID of the title record the piece is associated with
- required
- foreign key
APIs
titles
Standard CRUD API for the new "titles" table.
...