Creating tables

Tables are mainly database objects containing the required data in a tabular form.

We have used Oracle DB to create the tables for our use-case.

List of tables and their corresponding attributes are as follows:

Table name	Attributes
CPTM_PRODUCT_CUSTOMER_MAPPING	Ticket Id Issue Description Ticket Type External Ticket Number Priority Application Name Application Version Platform Version Status UI Component Name Assigned To Planned Resolution Name Actual Resolution Name Is Internal Created By Creation Date Last Update By Last Update Date Customer Id Requested By
CPTM_CUSTOMER_USER_MAPPING	User Id Creation Date Last Updated Date Created By Last Update By Purpose Customer Id End Date
CPTM_AVIS_CUSOTMERS	Account Name Account Type Description Account Number Status Currency Code Payment Term ID Tax code Attribute 1 Attribute 2 Attribute 3 Attribute 4 Attribute 5 Attribute 6 Attribute 7 Attribute 8 Attribute 9 Approver Sales Contact Creation date
CPTM_AVIS_LOOKUPS	Lookup Type Lookup Code Meaning Description Created By Creation Date Last Updated By Last Update Date Start Date End Date
CPTM_AVIS_TICKET_SUMMARY_V	Customer Id New In Progress Awaiting Testing Awaiting Response On Hold Closed Under Review

The table names can be different as per your convenience and requirements. However, the following tutorial contains the names as specified.