The cdws schema is used for on-site citation and family functionality. It houses tables and functions that interact with the data-store, index, and attachment repositories through the web services. Several of the tables in the cdws schema are described below. Note that if your initial load occurred before May 13, 2020, these tables will need to be added as described in Leveraging On-Site Citation and Family Functionality.
Table of Contents
Schema
cdws.t_applications
Column | Type | Modifiers | Comment |
|---|---|---|---|
| application_id | serial | primary key | Table primary key |
| application_ucid | varchar(32) | not null | Concatenation of country-doc_number-kind based on application record |
| filed | date | not null | Date of filing |
cdws.t_cited_documents
Column | Type | Modifiers | Comment |
|---|---|---|---|
| id | serial | primary key | Table primary key |
| publication_id | integer | not null | Integer representation of the publication |
| cited_document_id | integer | not null | Document identifier of the cited record |
| source | varchar(8) | not null | Citation origin |
| is_app | boolean | not null | Indicates that record is an application (true) or publication (false) |
| load_id | integer | not null | Load_id of last modification |
cdws.t_priority_documents
Column | Type | Modifiers | Comment |
|---|---|---|---|
| priority_id | serial | primary key | Table primary key |
| publication_id | integer | not null | Integer representation of the publication |
| application_id | integer | not null | Concatenation of country-doc_number-kind based on application record |
| app_type | char(1) | not null | XML origin of record: 'A' indicates application, 'P' indicates priority |
| link | char(1) | Value of priority-claim/linkage-type attribute in XML | |
| load_id | integer | not null | Load_id of last modification |
User-Defined Functions
The following examples illustrate the active functions in the cdws schema. Any functions not documented here are for internal use by IFI CLAIMS only. See Leveraging On-Site Citation and Family Functionality for more information.
| Note |
|---|
Note: Initial loads which occurred prior to May 13, 2020 need to have loaded the citations and family tables for the |
...