Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 3

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. tst

Table of Contents

Schema

cdws.t_applications

Column

Type

Modifiers

Comment

application_idserialprimary keyTable primary key
application_ucidvarchar(32)not null

Concatenation of country-doc_number-kind based on application record

fileddatenot nullDate of filing

...