Database Schema

Tables

This section provides low level information of the application tables and their's relationship. In order to avoid any conflict with predefined keywords or similar tables we use table prefix as SK_. Hence all tables listed below will be prefixed with SK_ while creation and accessed accordingly.

SK_CUSTOMER

COLUMN NAME	DATA TYPE	NULLABLE	KEY
CUSTOMER_ID	VARCHAR2 (20)	NO	PK
CUSTOMER_NAME	VARCHAR2 (50)	NO
GENDER	VARCHAR2(20)	YES
AGE	VARCHAR2(20)	YES
MOBILE_NUMBER	VARCHAR2 (20)	YES
EMAIL	VARCHAR2(50)	YES
ADDRESS	VARCHAR2(200)	YES