Table: blogs

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, NO,	bigint, NO,
blogSlug	varchar(225), NO,	varchar(225), YES,
blogTitle	varchar(225), NO,	varchar(225), YES,
blogDetail	longtext, NO,	longtext, NO,
blogThumbnail	varchar(225), NO,	varchar(225), YES,
blogStatus	varchar(225), NO, DRAFT	varchar(225), YES,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	datetime, YES, CURRENT_TIMESTAMP
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	datetime, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: categories

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, NO,	bigint, NO,
categoryName	varchar(255), NO,	varchar(255), YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	timestamp, NO,
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	timestamp, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: coupons

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, NO,	bigint, NO,
userUid	bigint, YES,	bigint, YES,
couponStatus	enum('REQUESTED','APPROVED','REJECTED'), YES, REQUESTED	enum('REQUESTED','APPROVED','REJECTED'), YES,
couponCode	varchar(50), NO,	varchar(50), YES,
couponTitle	varchar(255), NO,	varchar(255), YES,
couponDescription	text, YES,	text, YES,
couponDiscountType	enum('PERCENT','FLAT'), NO,	enum('PERCENT','FLAT'), YES,
couponDiscountValue	decimal(10,2), NO,	decimal(10,2), YES,
couponMaxDiscountAmount	decimal(10,2), YES,	decimal(10,2), YES,
couponMinOrderAmount	decimal(10,2), YES, 0.00	decimal(10,2), YES,
couponStartDate	date, NO,	date, NO,
couponEndDate	date, NO,	date, NO,
couponMaxUsageLimit	int, YES,	int, YES,
couponPerUserLimit	int, YES, 1	int, YES,
couponTotalUsed	int, YES, 0	int, YES,
couponApplicableOn	enum('ALL','COURSE','USER'), YES, COURSE	enum('ALL','COURSE','USER'), YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	datetime, YES, CURRENT_TIMESTAMP
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	datetime, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: course_enrollments

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, NO,	bigint, NO,
versionCode	varchar(20), YES,	varchar(20), YES,
orderUid	bigint, YES,	bigint, YES,
referenceNo	varchar(100), NO,	varchar(100), YES,
courseUid	bigint, NO,	bigint, NO,
userUid	bigint, NO,	bigint, NO,
allowedAccessTillDate	date, YES,	date, YES,
totalWatchDuration	time, YES, 00:00:00	time, YES,
watchCourseStatus	varchar(100), YES,	varchar(100), YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	datetime, YES, CURRENT_TIMESTAMP
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	datetime, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: course_learning_objectives

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
versionCode	varchar(20), YES,	varchar(20), YES,
courseUid	bigint, NO,	bigint, NO,
learningObjective	varchar(225), YES,	varchar(225), YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	datetime, YES, CURRENT_TIMESTAMP
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	datetime, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: course_prices

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, NO,	bigint, NO,
versionCode	varchar(20), YES,	varchar(20), YES,
courseUid	bigint, NO,	bigint, NO,
coursePrice	decimal(10,2), NO,	decimal(10,2), YES,
courseDiscountType	enum('FIXED','PERCENTAGE','NONE'), YES, NONE	enum('FIXED','PERCENTAGE','NONE'), YES,
courseDiscountValue	decimal(10,2), NO,	decimal(10,2), YES,
courseDiscountedValue	decimal(10,2), YES,	decimal(10,2), YES,
courseFinalPrice	decimal(10,2), NO,	decimal(10,2), YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	timestamp, NO,
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	timestamp, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: course_question_answers

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, YES,	bigint, YES,
userUid	bigint, NO,	bigint, NO,
courseUid	bigint, NO,	bigint, NO,
question	varchar(255), NO,	varchar(255), YES,
answer	varchar(255), YES,	varchar(255), YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	datetime, YES, CURRENT_TIMESTAMP
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	datetime, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: course_requirements

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
versionCode	varchar(20), YES,	varchar(20), YES,
courseUid	bigint, NO,	bigint, NO,
requirement	varchar(225), YES,	varchar(225), YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	datetime, YES, CURRENT_TIMESTAMP
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	datetime, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: course_reviews

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
userUid	bigint, NO,	bigint, NO,
courseUid	bigint, NO,	bigint, NO,
rating	int, YES,	int, YES,
comment	text, YES,	text, YES,
isApproved	tinyint(1), YES, 1	tinyint(1), YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	timestamp, NO,

Table: course_target_audiences

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
versionCode	varchar(20), YES,	varchar(20), YES,
courseUid	bigint, NO,	bigint, NO,
targetAudience	varchar(255), YES, 1	varchar(255), YES,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	datetime, YES, CURRENT_TIMESTAMP
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	datetime, YES,
updatedBy	bigint, YES,	bigint, YES,
deletecTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: course_versions

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, NO,	bigint, NO,
courseUid	❌ Missing	bigint, NO,
changeType	varchar(100), YES,	❌ Missing
versionCode	decimal(10,0), YES,	decimal(10,0), YES,
courseStatus	enum('DRAFT','REVIEW','PUBLISHED','ARCHIEVED','REJECTED'), YES, DRAFT	enum('DRAFT','REVIEW','PUBLISHED','ARCHIEVED','REJECTED'), YES,
changeLog	varchar(255), YES,	varchar(255), YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	timestamp, NO,
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	timestamp, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: course_video_notes

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, NO,	bigint, NO,
userUid	bigint, NO,	bigint, NO,
courseUid	bigint, NO,	bigint, NO,
courseVideoUid	bigint, NO,	bigint, NO,
videoTime	time, YES,	time, YES,
note	longtext, YES,	longtext, YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	timestamp, NO,
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	timestamp, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: course_video_tracking

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, YES,	bigint, YES,
userUid	bigint, NO,	bigint, NO,
courseUid	bigint, NO,	bigint, NO,
courseVideoUid	bigint, NO,	bigint, NO,
watchDuration	time, YES, 00:00:00	time, YES,
watchVideoStatus	varchar(15), YES, NOT_STARTED	varchar(15), YES,
updatedTimestamp	timestamp, YES,	timestamp, YES,

Table: course_videos

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, YES,	bigint, YES,
versionCode	varchar(20), YES,	varchar(20), YES,
courseUid	bigint, NO,	bigint, NO,
videoTitle	varchar(255), NO,	varchar(255), YES,
videoLink	varchar(255), YES,	varchar(255), YES,
videoThumbnailLink	varchar(255), YES,	varchar(255), YES,
videoDurationInMin	int, YES,	int, YES,
videoDuration	time, YES, 00:00:00	time, YES,
orderIndex	int, YES, 0	int, YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	datetime, YES, CURRENT_TIMESTAMP
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	datetime, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: courses

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, NO,	bigint, NO,
courseVersion	varchar(20), YES,	varchar(20), YES,
categoryUid	bigint, YES,	bigint, YES,
courseTitle	varchar(255), NO,	varchar(255), YES,
courseSlug	varchar(255), YES,	varchar(255), YES,
courseAccessDurationInDays	int, YES,	int, YES,
courseDescription	longtext, YES,	longtext, YES,
courseThumbnailLink	varchar(225), YES,	varchar(225), YES,
courseLanguage	varchar(50), YES, English	varchar(50), YES,
courseLevel	varchar(50), YES, Beginner	varchar(50), YES,
courseDurationInMin	int, YES, 0	int, YES,
courseDuration	time, YES, 00:00:00	time, YES,
courseRating	int, YES, 0	int, YES, 0
courseTotalRating	int, YES, 0	int, YES, 0
isBestSeller	tinyint(1), YES, 0	int, YES, 0
courseTotalEnrollment	int, YES, 0	int, YES, 0
courseUnasnweredQuestion	int, YES, 0	int, YES, 0
courseStatus	enum('DRAFT','REVIEW','PUBLISHED','ARCHIEVED','REJECTED'), YES, DRAFT	enum('DRAFT','REVIEW','PUBLISHED','ARCHIEVED','REJECTED'), YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	datetime, YES, CURRENT_TIMESTAMP	datetime, YES, CURRENT_TIMESTAMP
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	datetime, YES,	datetime, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: enquiries

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, YES,	bigint, YES,
enquirySource	varchar(30), YES,	varchar(30), YES,
firstName	varchar(225), YES,	varchar(225), YES,
lastName	varchar(225), YES,	varchar(225), YES,
clubbedFullName	varchar(225), YES,	varchar(225), YES,
clubbedName	varchar(225), YES,	varchar(225), YES,
email	varchar(225), YES,	varchar(225), YES,
mobileNo	varchar(15), YES,	varchar(15), YES,
whatsAppNo	varchar(15), YES,	varchar(15), YES,
subject	varchar(225), YES,	varchar(225), YES,
message	varchar(225), YES,	varchar(225), YES,
isActive	int, YES, 1	int, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	timestamp, NO,
remark	varchar(255), YES,	varchar(255), YES,
updatedTimestamp	timestamp, NO, CURRENT_TIMESTAMP	timestamp, NO,
deleted_timestamp	datetime, YES,	datetime, YES,
createdBy	bigint, YES,	bigint, YES,
updatedBy	bigint, YES,	bigint, YES,

Table: faqs

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, NO,	bigint, NO,
faqLevel	varchar(30), NO,	varchar(30), YES,
referenceUid	bigint, YES,	bigint, YES,
faqQuestion	varchar(225), NO,	varchar(225), YES,
faqAnswer	longtext, NO,	longtext, NO,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	datetime, YES, CURRENT_TIMESTAMP
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	datetime, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: live_class_schedules

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, NO,	bigint, NO,
classUid	bigint, NO,	bigint, NO,
classDate	date, YES,	date, YES,
classStartTime	time, YES,	time, YES,
classEndTime	time, YES,	time, YES,
classUrl	varchar(255), YES,	varchar(255), YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	datetime, YES, CURRENT_TIMESTAMP
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	datetime, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: live_classes

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, NO,	bigint, NO,
classTitle	varchar(255), NO,	varchar(255), YES,
classSlug	varchar(255), YES,	varchar(255), YES,
classThumbnailLink	varchar(225), YES,	varchar(225), YES,
classDescription	longtext, YES,	longtext, YES,
classInstructions	longtext, YES,	longtext, YES,
classStatus	enum('DRAFT','REVIEW','PUBLISHED','ARCHIEVED','REJECTED'), YES,	enum('DRAFT','REVIEW','PUBLISHED','ARCHIEVED','REJECTED'), YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	datetime, YES, CURRENT_TIMESTAMP
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	datetime, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: order_items

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
orderUid	bigint, NO,	bigint, NO,
userUid	bigint, NO,	bigint, NO,
courseUid	bigint, YES,	bigint, YES,
coursePrice	decimal(10,2), YES,	decimal(10,2), YES,
courseDiscountType	varchar(20), YES,	varchar(20), YES,
courseDiscountValue	decimal(10,2), YES,	decimal(10,2), YES,
courseDiscountedValue	decimal(10,2), YES,	decimal(10,2), YES,
courseFinalPrice	decimal(10,2), YES,	decimal(10,2), YES,
createdTimestamp	timestamp, YES, CURRENT_TIMESTAMP	timestamp, YES,
updatedTimestamp	timestamp, YES, CURRENT_TIMESTAMP	timestamp, YES,

Table: orders

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, NO,	bigint, NO,
orderStatus	enum('PENDING','SUCCESS','FAILED'), YES, PENDING	enum('PENDING','SUCCESS','FAILED'), YES,
userUid	bigint, NO,	bigint, NO,
subtotal	decimal(10,2), YES,	decimal(10,2), YES,
courseDiscount	decimal(10,2), YES,	decimal(10,2), YES,
subtotalAfterCourseDiscount	decimal(10,2), YES,	decimal(10,2), YES,
couponCode	varchar(100), YES,	varchar(100), YES,
couponDiscountType	varchar(100), YES,	varchar(100), YES,
couponDiscountValue	decimal(10,2), YES,	decimal(10,2), YES,
couponDiscount	decimal(10,2), YES,	decimal(10,2), YES,
subtotalAfterAllDiscount	decimal(10,2), YES,	decimal(10,2), YES,
taxRate	decimal(10,2), YES,	decimal(10,2), YES,
taxAmount	decimal(10,2), YES,	decimal(10,2), YES,
grandTotal	decimal(10,2), YES,	decimal(10,2), YES,
itemCount	int, YES,	int, YES,
totalSaving	decimal(10,2), YES,	decimal(10,2), YES,
billingFirstName	varchar(200), YES,	varchar(200), YES,
billingLastName	varchar(200), YES,	varchar(200), YES,
billingEmail	varchar(200), YES,	varchar(200), YES,
billingMobileNo	varchar(200), YES,	varchar(200), YES,
billingStreetAddress	varchar(200), YES,	varchar(200), YES,
billingCity	varchar(200), YES,	varchar(200), YES,
billingState	varchar(200), YES,	varchar(200), YES,
billingPincode	varchar(200), YES,	varchar(200), YES,
billingCountry	varchar(200), YES,	varchar(200), YES,
paymentUrl	varchar(225), YES,	varchar(225), YES,
createdTimestamp	timestamp, YES, CURRENT_TIMESTAMP	timestamp, YES,
updatedTimestamp	timestamp, YES, CURRENT_TIMESTAMP	timestamp, YES,

Table: payment_initializations

Column	digitalskillindia	dev_digitalskillindia
id	bigint unsigned, NO,	int, NO,
referenceNo	bigint unsigned, NO,	bigint unsigned, NO,
userUid	bigint unsigned, NO,	bigint unsigned, NO,
courseUid	bigint unsigned, NO,	bigint unsigned, NO,
createdTimestamp	timestamp, YES, CURRENT_TIMESTAMP	timestamp, YES,
coursePrice	decimal(10,2), NO,	decimal(10,2), YES,
courseDiscount	decimal(10,2), YES, 0.00	decimal(10,2), YES,
courseDiscountedPrice	decimal(10,2), YES, 0.00	decimal(10,2), YES,
cgstPercentage	decimal(10,2), YES, 0.00	decimal(10,2), YES,
cgstAmount	decimal(10,2), YES, 0.00	decimal(10,2), YES,
sgstPercentage	decimal(10,2), YES, 0.00	decimal(10,2), YES,
sgstAmount	decimal(10,2), YES, 0.00	decimal(10,2), YES,
redirectionUrl	varchar(225), YES,	varchar(225), YES,
payableAmount	decimal(10,2), NO,	decimal(10,2), YES,
updatedTimestamp	timestamp, YES, CURRENT_TIMESTAMP	timestamp, YES,

Table: payments

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, YES,	bigint, YES,
referenceNo	bigint unsigned, NO,	bigint unsigned, NO,
userUid	bigint unsigned, NO,	bigint unsigned, NO,
payableAmount	decimal(10,2), YES,	decimal(10,2), YES,
paymentMethod	varchar(50), YES,	varchar(50), YES,
paymentStatus	enum('pending','success','failed','abandoned'), YES,	enum('pending','success','failed','abandoned'), YES,
deductionPercentage	decimal(5,2), YES,	decimal(5,2), YES,
netAmountDebit	decimal(10,2), YES,	decimal(10,2), YES,
cardCategory	varchar(50), YES,	varchar(50), YES,
unmappedStatus	varchar(50), YES,	varchar(50), YES,
addedOn	timestamp, YES,	timestamp, YES,
cashBackPercentage	decimal(5,2), YES,	decimal(5,2), YES,
bankRefNum	varchar(50), YES,	varchar(50), YES,
errorMessage	varchar(255), YES,	varchar(255), YES,
phone	varchar(20), YES,	varchar(20), YES,
easePayId	varchar(50), YES,	varchar(50), YES,
cardNumber	varchar(50), YES,	varchar(50), YES,
upiVa	varchar(50), YES,	varchar(50), YES,
paymentSource	varchar(50), YES,	varchar(50), YES,
cardType	varchar(50), YES,	varchar(50), YES,
mode	varchar(50), YES,	varchar(50), YES,
error	varchar(255), YES,	varchar(255), YES,
bankCode	varchar(50), YES,	varchar(50), YES,
nameOnCard	varchar(100), YES,	varchar(100), YES,
bankName	varchar(100), YES,	varchar(100), YES,
issuingBank	varchar(100), YES,	varchar(100), YES,
pgType	varchar(50), YES,	varchar(50), YES,
authCode	varchar(50), YES,	varchar(50), YES,
firstName	varchar(100), YES,	varchar(100), YES,
email	varchar(150), YES,	varchar(150), YES,
merchantLogo	varchar(255), YES,	varchar(255), YES,
txnId	varchar(50), YES,	varchar(50), YES,
udf1	varchar(255), YES,	varchar(255), YES,
udf2	varchar(255), YES,	varchar(255), YES,
udf3	varchar(255), YES,	varchar(255), YES,
udf4	varchar(255), YES,	varchar(255), YES,
udf5	varchar(255), YES,	varchar(255), YES,
udf6	varchar(255), YES,	varchar(255), YES,
udf7	varchar(255), YES,	varchar(255), YES,
udf8	varchar(255), YES,	varchar(255), YES,
udf9	varchar(255), YES,	varchar(255), YES,
udf10	varchar(255), YES,	varchar(255), YES,
createdTimestamp	timestamp, YES, CURRENT_TIMESTAMP	timestamp, YES,
updatedTimestamp	timestamp, YES, CURRENT_TIMESTAMP	timestamp, YES,
amount	decimal(10,2), YES,	decimal(10,2), YES,
productInfo	varchar(100), YES,	varchar(100), YES,
successUrl	varchar(255), YES,	varchar(255), YES,
failureUrl	varchar(255), YES,	varchar(255), YES,
paymentHash	varchar(255), YES,	varchar(255), YES,
paymentKey	varchar(100), YES,	varchar(100), YES,
gatewayStatus	varchar(50), YES,	varchar(50), YES,
status	varchar(100), YES,	varchar(100), YES,

Table: system_logs

Column	digitalskillindia	dev_digitalskillindia
id	bigint, NO,	int, NO,
service	varchar(120), YES,	varchar(120), YES,
method	varchar(120), YES,	varchar(120), YES,
error_code	varchar(200), YES,	varchar(200), YES,
message	text, YES,	text, YES,
level	enum('INFO','WARNING','ERROR','CRITICAL'), YES,	enum('INFO','WARNING','ERROR','CRITICAL'), YES,
file	varchar(255), YES,	varchar(255), YES,
line	int, YES,	int, YES,
trace	longtext, YES,	longtext, YES,
payload	json, YES,	json, YES,
user_uid	bigint, YES,	bigint, YES,
ip_address	varchar(50), YES,	varchar(50), YES,
created_at	timestamp, YES, CURRENT_TIMESTAMP	timestamp, YES,

Table: theme_manager

Column	digitalskillindia	dev_digitalskillindia
id	bigint unsigned, NO,	int, NO,
primary_color	varchar(255), YES,	varchar(255), YES,
primary_dark	varchar(255), YES,	varchar(255), YES,
primary_light	varchar(255), YES,	varchar(255), YES,
secondary_color	varchar(255), YES,	varchar(255), YES,
accent_color	varchar(255), YES,	varchar(255), YES,
background_color	varchar(255), YES,	varchar(255), YES,
primary_50	varchar(255), YES,	varchar(255), YES,
primary_100	varchar(255), YES,	varchar(255), YES,
primary_500	varchar(255), YES,	varchar(255), YES,
primary_600	varchar(255), YES,	varchar(255), YES,
primary_700	varchar(255), YES,	varchar(255), YES,
success_color	varchar(255), YES,	varchar(255), YES,
warning_color	varchar(255), YES,	varchar(255), YES,
danger_color	varchar(255), YES,	varchar(255), YES,
info_color	varchar(255), YES,	varchar(255), YES,
muted_color	varchar(255), YES,	varchar(255), YES,
light_color	varchar(255), YES,	varchar(255), YES,
dark_color	varchar(255), YES,	varchar(255), YES,
is_active	tinyint(1), NO, 1	tinyint(1), YES,
created_at	timestamp, YES,	timestamp, YES,
updated_at	timestamp, YES,	timestamp, YES,

Table: user_additional_details

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
userUid	int, NO,	int, NO,
detailsType	varchar(10), YES, EXPERTISE	varchar(10), YES,
details	varchar(225), YES,	varchar(225), YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	timestamp, NO, CURRENT_TIMESTAMP	timestamp, NO,
createdBy	int, YES,	int, YES,
updatedTimestamp	timestamp, YES,	timestamp, YES,
updatedBy	int, YES,	int, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	int, YES,	int, YES,

Table: user_cart_summary

Column	digitalskillindia	dev_digitalskillindia
id	bigint, NO,	int, NO,
userUid	bigint, NO,	bigint, NO,
subtotal	decimal(10,2), YES,	decimal(10,2), YES,
courseDiscount	decimal(10,2), YES,	decimal(10,2), YES,
subtotalAfterCourseDiscount	decimal(10,2), YES,	decimal(10,2), YES,
couponCode	text, YES,	text, YES,
couponDiscountType	varchar(100), YES,	varchar(100), YES,
couponDiscountValue	decimal(10,2), YES,	decimal(10,2), YES,
couponDiscount	decimal(10,2), YES,	decimal(10,2), YES,
subtotalAfterAllDiscount	decimal(10,2), YES,	decimal(10,2), YES,
taxRate	decimal(10,2), YES,	decimal(10,2), YES,
taxAmount	decimal(10,2), YES,	decimal(10,2), YES,
grandTotal	decimal(10,2), YES,	decimal(10,2), YES,
itemCount	int, YES,	int, YES,
totalSaving	decimal(10,2), YES,	decimal(10,2), YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	datetime, YES, CURRENT_TIMESTAMP	datetime, YES, CURRENT_TIMESTAMP
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	timestamp, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: user_carts

Column	digitalskillindia	dev_digitalskillindia
id	bigint, NO,	int, NO,
cartSummaryUid	bigint, YES,	bigint, YES,
userUid	bigint, NO,	bigint, NO,
courseUid	bigint, NO,	bigint, NO,
coursePrice	decimal(10,2), YES,	decimal(10,2), YES,
courseDiscountType	varchar(20), YES,	varchar(20), YES,
courseDiscountValue	decimal(10,2), YES,	decimal(10,2), YES,
courseDiscountedValue	decimal(10,2), YES,	decimal(10,2), YES,
courseFinalPrice	decimal(10,2), YES,	decimal(10,2), YES,
isActive	tinyint(1), YES, 1	tinyint(1), YES,
remark	text, YES,	text, YES,
createdTimestamp	datetime, YES, CURRENT_TIMESTAMP	datetime, YES, CURRENT_TIMESTAMP
createdBy	bigint, YES,	bigint, YES,
updatedTimestamp	timestamp, YES,	timestamp, YES,
updatedBy	bigint, YES,	bigint, YES,
deletedTimestamp	timestamp, YES,	timestamp, YES,
deletedBy	bigint, YES,	bigint, YES,

Table: user_otps

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
otpType	varchar(100), YES,	varchar(100), YES,
mobileNo	varchar(100), NO,	varchar(100), YES,
otp	varchar(100), NO,	varchar(100), YES,
expiryTimestamp	timestamp, YES,	timestamp, YES,
isUsed	tinyint, YES, 0	tinyint, YES,

Table: users

Column	digitalskillindia	dev_digitalskillindia
id	int, NO,	int, NO,
uid	bigint, YES,	bigint, YES,
userRole	varchar(15), YES,	varchar(15), YES,
avatar	varchar(225), YES,	varchar(225), YES,
firstName	varchar(225), YES,	varchar(225), YES,
middleName	varchar(225), YES,	varchar(225), YES,
lastName	varchar(225), YES,	varchar(225), YES,
clubbedFullName	varchar(225), YES,	varchar(225), YES,
clubbedName	varchar(225), YES,	varchar(225), YES,
email	varchar(225), YES,	varchar(225), YES,
emailVerifiedAt	datetime, YES,	datetime, YES,
mobileNo	varchar(15), YES,	varchar(15), YES,
mobileNoVerifiedAt	datetime, YES,	datetime, YES,
password	varchar(255), YES,	varchar(255), YES,
whatsAppNo	varchar(15), YES,	varchar(15), YES,
whatsAppNoVerifiedAt	datetime, YES,	datetime, YES,
dob	date, YES,	date, YES,
gender	enum('MALE','FEMALE','OTHER'), YES,	enum('MALE','FEMALE','OTHER'), YES,
isActive	int, YES, 1	int, YES,
remark	varchar(255), YES,	varchar(255), YES,
createdTimestamp	datetime, YES,	datetime, YES,
updatedTimestamp	datetime, YES,	datetime, YES,
deleted_timestamp	datetime, YES,	datetime, YES,
createdBy	bigint, YES,	bigint, YES,
updatedBy	bigint, YES,	bigint, YES,
professionalTitle	varchar(100), YES,	varchar(100), YES,
bio	varchar(225), YES,	varchar(225), YES,
socialTwitter	varchar(100), YES,	varchar(100), YES,
socialGithub	varchar(100), YES,	varchar(100), YES,
socialLinkedin	varchar(100), YES,	varchar(100), YES,
socialWebsite	varchar(100), YES,	varchar(100), YES,

Table: website_configurations

Column	digitalskillindia	dev_digitalskillindia
id	bigint unsigned, NO,	int, NO,
config_key	varchar(255), NO,	varchar(255), YES,
config_value	varchar(255), NO,	varchar(255), YES,
category	varchar(255), NO, general	varchar(255), YES,
description	varchar(500), YES,	varchar(500), YES,
metadata	json, YES,	json, YES,
is_active	tinyint(1), NO, 1	tinyint(1), YES,
created_at	timestamp, YES,	timestamp, YES,
updated_at	timestamp, YES,	timestamp, YES,