La base de données du registre des brevets se compose de trois tableaux ayant
 la structure suivante :

 1. Drugs Table

 Field Name                      Null?    Type
 ------------------------------- -------- ----
 DRUG_ID                         NOT NULL NUMBER(9)
 MEDICINAL_INGREDIENT                     VARCHAR2(255)
 BRAND_NAME                               VARCHAR2(50)
 ROUTE_OF_ADMINISTRATION                  VARCHAR2(50)
 STRENGTH_PER_UNIT                        VARCHAR2(255)
 HUMAN_OR_VET                             VARCHAR2(50)
 THERAPEUTIC_CLASS                        VARCHAR2(500)
 DOSAGE_FORM                              VARCHAR2(50)
 DIN                                      VARCHAR2(50)


 2. Patent_Service Table

 Field Name                      Null?    Type
 ------------------------------- -------- ----
 FORM_ID                         NOT NULL NUMBER(9)
 DRUG_ID                                  NUMBER(9)
 PATENT_NUMBER                            NUMBER(9)
 CATEGORY                                 VARCHAR2(50)
 FILING_DATE                              DATE
 DATE_GRANTED                             DATE
 EXPIRATION_DATE                          DATE
 SERVICE_COMPANY_NAME                     VARCHAR2(100)
 FIRST_NAME                               VARCHAR2(50)
 LAST_NAME                                VARCHAR2(50)
 POSITION_TITLE                           VARCHAR2(50)
 ADDRESS                                  VARCHAR2(50)
 CITY                                     VARCHAR2(50)
 PROVINCES                                VARCHAR2(50)
 POSTAL_CODE                              VARCHAR2(50)


 3. Submission_Certif Table

 Field Name                      Null?    Type
 ------------------------------- -------- ----
 SUB_FORM_ID                     NOT NULL NUMBER(9)
 DRUG_ID                                  NUMBER(9)
 FORM_ID                                  NUMBER(9)
 SUBMISSION_NUMBER                        VARCHAR2(22)
 DATE_OF_SUBMISSION                       DATE
 CR_DATE                                  DATE
 NOC_DATE                                 DATE
 PATENT_AUDITED                           VARCHAR2(50)
 AUDIT_RESULTS                            VARCHAR2(200)
 DATE_ADDED_TO_REGISTER                   DATE
 PREVIOUSLY_FIELD_SUBMISSION              VARCHAR2(10)
 FOR_OFFICE_USE_ONLY                      VARCHAR2(2000)
 UPDATE_TO_PREVIOUS_RECORD                VARCHAR2(3)
 FIRST_NAME                               VARCHAR2(50)
 LAST_NAME                                VARCHAR2(50)
 ADDRESS                                  VARCHAR2(50)
 CITY                                     VARCHAR2(50)
 PROVINCES                                VARCHAR2(50)
 POSTAL_CODE                              VARCHAR2(50)
 MANUFACTURER_NAME                        VARCHAR2(100)
 POSITION_TITLE                           VARCHAR2(255)
 PHONE_NUMBER                             NUMBER(12)
 FAX_NUMBER                               NUMBER(12)
 DATE_SIGNED                              DATE
 DATE_AMENDED			          DATE
 SUBMISSION_TYPE_CODE			  VARCHAR2(35)
 USE_OF_MI				  VARCHAR2(4000)
 REMOVED_DATE				  DATE
 FOR_OFFICE_USE_ONLY_FRENCH		  VARCHAR2(2000)