Untitled

unknown
plain_text
2 years ago
16 kB
Indexable
Never
	
CREATE TABLE `app_form52652_data` (
  `entity_id` int(11) NOT NULL AUTO_INCREMENT,
  `masterform_id` int(11) NOT NULL DEFAULT '1',
  `orgid` bigint(20) NOT NULL,
  `dcnid` int(11) NOT NULL DEFAULT '1',
  `payment_mode` varchar(100) CHARACTER SET latin1 DEFAULT '',
  `payment_status` varchar(100) CHARACTER SET latin1 DEFAULT '',
  `paymentTransactionNo` varchar(200) CHARACTER SET latin1 DEFAULT '',
  `paymentReceiptNo` varchar(200) CHARACTER SET latin1 DEFAULT '',
  `rowstate` int(11) NOT NULL DEFAULT '1',
  `parent_entity_id` int(11) DEFAULT NULL,
  `logged_by` bigint(20) NOT NULL,
  `logged_date` datetime NOT NULL,
  `last_updated_by` bigint(20) DEFAULT NULL,
  `last_updated_date` datetime DEFAULT NULL,
  `app_seq_no` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `user_id` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `user_pwd` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `app_status` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `comments` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `payment_request_time` datetime DEFAULT NULL,
  `payment_response_time` datetime DEFAULT NULL,
  `login_attempt` varchar(5) CHARACTER SET latin1 DEFAULT '',
  `paymentCardType` varchar(50) CHARACTER SET latin1 DEFAULT '',
  `orderid` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `auth_id` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `ItemName` varchar(300) CHARACTER SET latin1 DEFAULT NULL,
  `txtItemStartDate` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `txtItemDuration` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtItemshortDesc` varchar(500) DEFAULT NULL,
  `txtItemPrice` varchar(20) DEFAULT '0',
  `txtCurrency` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtThumbnailImage` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `txtAdditionalDtls` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `txtItemTags` varchar(1000) CHARACTER SET latin1 DEFAULT NULL,
  `txtPublishFlag` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `txtTotalJoinees` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `txtOrgId` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtItemVisibility` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `txtProductCreationType` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `txtDiscountPercentage` varchar(10) DEFAULT '0',
  `txtItemEndDate` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `IsRecommendedByiON` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `txtLevel1` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `txtLevel2` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `txtLevel3` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `txtLevel4` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `txtCreatedBy` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `txtInstanceId` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `txtItemPurchaseType` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `IsItemActivationRqd` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `IsItemOnlinePurchaseReqd` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `txtEmail` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtItemScheduledStartDate` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `txtItemScheduledEndDate` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `txtProductStatus` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtProfilesmapped` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `IsSchedulingRqd` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `IsMemberVerificationRqd` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `txtUserAttribute` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtUserAttrubuteValue` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `IsParentProduct` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `txtParentProductId` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtProductVisbilityAnonymous` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `txtTimezone` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `txtAttribute1` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtAttribute2` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtAttribute3` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtAttribute4` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtAttribute5` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtAttribute6` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtAttribute7` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtAttribute8` longtext,
  `txtAttribute9` varchar(255) DEFAULT NULL,
  `txtAttribute10` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `productId` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtAttributeOfCPDcredit` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtPublishDate` datetime DEFAULT NULL,
  `txtItemLogo` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `txtItemType` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtItemSummary` varchar(2000) CHARACTER SET latin1 DEFAULT NULL,
  `txtEnrollToAccessContent` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `txtItemSyllabusDescription` varchar(2000) CHARACTER SET latin1 DEFAULT NULL,
  `txtInstructorTestimonial` varchar(1000) CHARACTER SET latin1 DEFAULT NULL,
  `txtChooseCourseQuestions` varchar(2000) CHARACTER SET latin1 DEFAULT NULL,
  `txtNextEnrollDate` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtItemSyllabusName` varchar(1000) CHARACTER SET latin1 DEFAULT NULL,
  `txtInstructorName` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtInstructorJobTitle` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtInstructorPhoto` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtCourseSchedule` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `txtModuleCount` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `txtChooseCourseAnswers` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `txtPublisherName` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txtProductMicrositeLink` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `txtProductMicrositeBannerLink` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `IsPriceOveriddenReqd` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `productImage` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `productImage_verification` varchar(4) CHARACTER SET latin1 DEFAULT '-1',
  `templateupload` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `templateupload_verification` varchar(4) CHARACTER SET latin1 DEFAULT '-1',
  `paymentFailureReason` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `txtTCSPercentage` varchar(50) DEFAULT '0',
  `countOfChildProducts` int(10) DEFAULT '0',
  `location` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `seatsAvailable` int(10) DEFAULT '0',
  `isLimitedSeats` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `refundPolicyWriteUp` varchar(1000) CHARACTER SET latin1 DEFAULT NULL,
  `refundPercFromPublisher` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `refundPercFromPlatformOwner` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `refundApplicable` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txnChargePayer` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txnChargePerc` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txnChargeCurrency` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `txnChargeFV` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `subscriptionType` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `languageId` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `isRecommendedCount` int(20) DEFAULT '0',
  `isMultipleSubscriptionsAllowed` int(5) DEFAULT '0',
  `taxPercentage` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `taxDescription` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `reviewCount` int(20) DEFAULT '0',
  `rating1` int(20) DEFAULT '0',
  `avgRating` float DEFAULT '0',
  `ratingCount` int(20) DEFAULT '0',
  `rating4` int(20) DEFAULT '0',
  `rating5` int(20) DEFAULT '0',
  `rating2` int(20) DEFAULT '0',
  `rating3` int(20) DEFAULT '0',
  `shortURL` varchar(300) CHARACTER SET latin1 DEFAULT NULL,
  `entityOrgId` int(10) DEFAULT '0',
  `autoProductAssign` int(5) DEFAULT '0',
  `autoPartnerShip` int(5) DEFAULT '0',
  `amount_refund_percent` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `platform_refund_percent` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `seller_refund_percent` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `msf_paid_by` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `pr_icon` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `pr_icon_verification` varchar(4) CHARACTER SET latin1 DEFAULT '-1',
  `availabilityEndDate` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `availabilityStartDate` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `SACcode` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `scrutinySetting` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `HSNcode` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `waitListStatus` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `registerInterestStatus` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `prd_barcode` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `prd_barcode_verification` varchar(4) CHARACTER SET latin1 DEFAULT '-1',
  `noOfDays` int(5) DEFAULT '0',
  `expiryDate` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `typeOfValidity` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `bundleId` int(10) DEFAULT '0',
  `isExternalApp` int(5) DEFAULT '0',
  `FPMaxC` int(5) DEFAULT '0',
  `SPMinC` int(5) DEFAULT '0',
  `SPMaxC` int(5) DEFAULT '0',
  `PPD` varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  `expiryDate_sub` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `dashboardDisplay` int(5) DEFAULT '0',
  `FPMinC` int(5) DEFAULT '0',
  `PPPD` text CHARACTER SET latin1,
  `noOfDays_sub` int(10) DEFAULT '0',
  `mailordisplaytext` text CHARACTER SET latin1,
  `postPaymentScreen` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `distributerPercentageDiscount` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `hub_cred_score` varchar(20) CHARACTER SET latin1 DEFAULT '1',
  `PublisherTnC` mediumtext,
  `free_license_count` varchar(5) CHARACTER SET latin1 DEFAULT '0',
  `course_profile` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `is_Phygital` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `microsite_html` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `testing_license_count` varchar(5) CHARACTER SET latin1 DEFAULT '0',
  `CourseTemplate_Id` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `OfflineSaleBy` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `IBA_Id` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `multipleSubscriptionCount` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `skills` text CHARACTER SET latin1,
  `microsite_iframe` varchar(2) CHARACTER SET latin1 DEFAULT '1',
  `micrositeXLSPath` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `templateId` varchar(10) CHARACTER SET latin1 DEFAULT '0',
  `productTransactionData` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `productGroup` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `isMultiSlot` varchar(1) CHARACTER SET latin1 DEFAULT NULL,
  `multiSlotJson` text CHARACTER SET latin1,
  `paymentLink` text CHARACTER SET latin1,
  `scoreCalculation` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `expiryExplanationComment` text CHARACTER SET latin1,
  `notifDisplayDuration` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `activeCouponCount` varchar(5) CHARACTER SET latin1 DEFAULT '0',
  `isBundledProduct` varchar(5) CHARACTER SET latin1 DEFAULT '0',
  `bundleProductList` text CHARACTER SET latin1,
  `learner_version` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `learner_sos` text,
  `aggregator_price_details` varchar(1) DEFAULT '0',
  `aggregator_sos` text,
  `distributor_sos` longtext,
  `distributor_tnc` longtext,
  `aggregator_tnc` text,
  `learner_price_details` varchar(1) DEFAULT '0',
  `distributor_price_details` varchar(1) DEFAULT '0',
  `learner_tnc` text,
  `product_purchase_dependancy` varchar(5) DEFAULT '0',
  `license_activation_type` varchar(5) DEFAULT '0',
  `assessement_course_id` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `downtime_end_time` timestamp NULL DEFAULT NULL,
  `distributor_version` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `aggregator_version` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `downtime_details` text,
  `downtime_start_time` timestamp NULL DEFAULT NULL,
  `pre_completion` text,
  `post_completion` text,
  `app_type` varchar(5) DEFAULT '0',
  `product_category` varchar(4) DEFAULT '0',
  `product_solution` varchar(4) DEFAULT '0',
  `vertical_sub_category` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `vertical_category` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `subSubscriptionType` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `customFormId` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `isPurchaseButtonReqd` varchar(5) CHARACTER SET latin1 DEFAULT '1',
  `tiny_url` varchar(200) DEFAULT NULL,
  `isWidgetType` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `serviceURL` varchar(300) CHARACTER SET latin1 DEFAULT NULL,
  `productType` varchar(100) DEFAULT NULL,
  `gst_address` varchar(300) DEFAULT NULL,
  `gstNumber` varchar(50) DEFAULT NULL,
  `multitenantBundleid` varchar(50) DEFAULT NULL,
  `isLicenceGenerationSupressed` varchar(10) DEFAULT NULL,
  `isNexarcAssured` tinyint(1) DEFAULT '0',
  `isAppSearchable` tinyint(1) DEFAULT '1',
  `isBenefitAccounting` tinyint(1) DEFAULT '0',
  `isLicenceAutoConsumed` tinyint(1) DEFAULT '0',
  `leadDestValue` varchar(50) DEFAULT NULL,
  `listingPrice` varchar(20) DEFAULT '0',
  `isPackageHidden` tinyint(1) DEFAULT '0',
  `isTataGroupProduct` tinyint(1) DEFAULT '0',
  `isPopular` tinyint(1) DEFAULT '0',
  `isComingSoon` tinyint(1) DEFAULT '0',
  `enableLiveChat` tinyint(1) DEFAULT '0',
  `product_offerring_id` int(11) DEFAULT NULL,
  `partner_id` int(11) DEFAULT NULL,
  `product_status_id` int(11) DEFAULT NULL,
  `seller_type_id` int(11) DEFAULT NULL,
  `display_store_name` varchar(100) DEFAULT NULL,
  `principle_entity` varchar(100) DEFAULT NULL,
  `operating_model_id` int(11) DEFAULT NULL,
  `is_refund_available` tinyint(1) NOT NULL DEFAULT '1',
  `refund_duration` int(11) DEFAULT NULL,
  `payment_borne_by_id` int(11) DEFAULT NULL,
  `settlement_frequency_days` varchar(200) DEFAULT NULL,
  `request_id` bigint(13) DEFAULT NULL,
  `country_of_origin` varchar(100) DEFAULT NULL,
  `production_capacity` varchar(100) DEFAULT NULL,
  `safty_warning` longtext,
  `moq` varchar(11) DEFAULT NULL,
  `moq_unit` varchar(100) DEFAULT NULL,
  `price_unit` varchar(100) DEFAULT NULL,
  `pto_id` int(11) DEFAULT '0',
  `product_brand_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `app_seq_no` (`app_seq_no`),
  KEY `index_logged_date` (`logged_date`),
  KEY `txtLevel1` (`txtLevel1`),
  KEY `txtLevel2` (`txtLevel2`),
  KEY `txtLevel3` (`txtLevel3`),
  KEY `txtLevel4` (`txtLevel4`),
  KEY `txtInstanceId` (`txtInstanceId`),
  KEY `txtOrgId` (`txtOrgId`),
  KEY `idx_last_updated_date` (`last_updated_date`),
  KEY `idx_user` (`user_id`(10)),
  KEY `idx_templateId` (`templateId`),
  KEY `idx_shortURL` (`shortURL`),
  KEY `idx_txtParentProductId` (`txtParentProductId`),
  KEY `idx_app_form52652_data_product_category` (`product_category`),
  FULLTEXT KEY `products` (`ItemName`,`txtItemTags`)
) ENGINE=InnoDB AUTO_INCREMENT=1616 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC