Customer Relation Module Services
Profile Mysql Database Schema
CREATE TABLE customer_profile ( ID INT(20) NOT NULL AUTO_INCREMENT, TITLE VARCHAR(3), FIRST_NAME VARCHAR(30), MIDDLE_NAME VARCHAR(30), LAST_NAME VARCHAR(30), DOB VARCHAR(10), MOBILE_NUMBER VARCHAR(20), EMAIL_ADDRESS VARCHAR(50), IS_EMAIL_VERIFIED TINYINT(1) DEFAULT 0, IS_MOBILE_VERIFIED TINYINT(1) DEFAULT 0, USER_NAME VARCHAR(30), PASSWORD VARCHAR(20), PROFILE_ID VARCHAR(10), PROFILE_CURRENCY VARCHAR(20), PROFILE_BALANCE DOUBLE(10,2), PROFILE_STATUS TINYINT(1) DEFAULT 0, PROFILE_CARD_NO VARCHAR(30), PROFILE_CARD_TYPE VARCHAR(20), CREATION_TIME DATETIME DEFAULT NOW(), MODIFIED_TIME DATETIME, PRIMARY KEY (ID) );