E-Learning (46)
Article (21)
Mentoring & Booking (18)
Affiliator & Referral (9)
Practice (7)
User & Role (6)
AYCL (6)
Voucher & Redeem Code (5)
Modul Pendukung (4)
Payment & Withdrawal (2)
Job Board (Dummy) (2)
activity_logs
🔑idString
🔗userIdString
actionString
descriptionString?
ipAddressString?
userAgentString?
typeString?
createdAtDateTime
affiliator_profiles
🔑idString
🔗userIdString U
currentTierString
totalPointsInt
isActiveBoolean
joinedAtDateTime
createdAtDateTime
updatedAtDateTime?
affiliator_seasons
🔑idString
seasonNameString
startDateDateTime
endDateDateTime
isActiveBoolean
createdAtDateTime
affiliator_season_points
🔑idString
🔗affiliatorProfileIdString
🔗seasonIdString
pointsInt
tierAtSeasonStartString
tierAtSeasonEndString?
maintenanceQuotaMetBoolean?
createdAtDateTime
updatedAtDateTime?
affiliator_product_configs
🔑idString
productTypeString
tierString
commissionAmountDecimal?
discountAmountDecimal?
commissionPercentDecimal?
discountPercentDecimal?
pointsAwardedInt
isActiveBoolean
createdAtDateTime
updatedAtDateTime?
articles
🔑idString
🔗authorIdString
titleString
slugString U
excerptString?
coverImageString?
🔗categoryIdString?
tagsString[]
statusArticleStatus
isRecommendedBoolean
publishedAtDateTime?
createdAtDateTime?
updatedAtDateTime?
deletedAtDateTime?
article_categories
🔑idString
nameString U
createdAtDateTime
updatedAtDateTime?
article_blocks
🔑idString
🔗articleIdString
orderNumberInt?
createdAtDateTime?
ct_article_content_blocks
🔑idString
🔗blockIdString
typeArticleContentBlockType
orderNumberInt?
createdAtDateTime?
ct_article_heading_contents
🔑idString
🔗contentIdString U
levelInt
textString
ct_article_paragraph_contents
🔑idString
🔗contentIdString U
textString
ct_article_highlight_contents
🔑idString
🔗contentIdString U
textString
ct_article_table_contents
🔑idString
🔗contentIdString U
ct_article_table_columns
🔑idString
🔗tableIdString
headerString
orderNumberInt
ct_article_table_rows
🔑idString
🔗tableIdString
orderNumberInt
ct_article_table_cells
🔑idString
🔗rowIdString
🔗columnIdString
valueString?
ct_article_divider_contents
🔑idString
🔗contentIdString U
styleArticleDividerStyle
ct_article_link_contents
🔑idString
🔗contentIdString U
linkTextString
linkTypeArticleLinkType
externalUrlString?
🔗targetContentBlockIdString?
🔗targetAdditionalContentIdString?
ct_article_table_of_content_contents
🔑idString
🔗contentIdString U
🔗articleIdString U
ct_article_table_of_content_items
🔑idString
🔗tocIdString
labelString
orderNumberInt
🔗targetContentBlockIdString?
🔗targetAdditionalContentIdString?
ct_article_additional_contents
🔑idString
🔗blockIdString
typeArticleAdditionalContentType
positionAnchorPosition
orderNumberInt?
ct_article_image_video_contents
🔑idString
🔗additionalContentIdString U
titleString?
captionString?
descriptionString?
mediaTypeMediaType
urlString
thumbnailUrlString?
durationSecondsInt?
widthPercentInt?
createdAtDateTime?
article_element_favorites
🔑idString
🔗userIdString
elementTypeArticleElementType
createdAtDateTime?
article_likes
🔑idString
🔗articleIdString
🔗userIdString
createdAtDateTime
article_comments
🔑idString
🔗articleIdString
🔗userIdString
🔗parentIdString?
contentString
createdAtDateTime
updatedAtDateTime?
deletedAtDateTime?
article_comment_likes
🔑idString
🔗commentIdString
🔗userIdString
createdAtDateTime
aycl_batches
🔑idString
titleString
slugString U
headlineString
subHeadlineString?
descriptionString?
whatsappGroupLinkString?
priceDecimal
startDateDateTime?
endDateDateTime?
isActiveBoolean
createdAtDateTime
updatedAtDateTime?
aycl_sections
🔑idString
🔗batchIdString
typeAYCLSectionType
titleString
contentJson
orderInt
aycl_materials
🔑idString
🔗batchIdString
titleString
descriptionString?
aycl_schedules
🔑idString
🔗batchIdString
titleString
dateDateTime
startTimeDateTime
endTimeDateTime
googleMeetLinkString?
quotaInt?
createdAtDateTime
aycl_bookings
🔑idString
🔗userIdString
🔗batchIdString
🔗referralUsageIdString? U
statusString
createdAtDateTime
currentStatusString?
institutionString?
studyProgramString?
semesterString?
ageInt?
reasonString?
familiarityString?
aycl_participants
🔑idString
🔗bookingIdString
🔗scheduleIdString
createdAtDateTime
bookings
🔑idString
🔗menteeIdString
🔗mentoringServiceIdString
🔗referralUsageIdString? U
bookingDateDateTime?
statusString?
specialRequestsString?
materialString?
expectedOutputString?
supportDocumentString?
createdAtDateTime?
updatedAtDateTime?
booking_invoices
🔑idString
🔗bookingIdString U
totalAmountDecimal
paidAmountDecimal
remainingAmountDecimal
paymentTypeString
installmentCountInt?
statusString
createdAtDateTime
updatedAtDateTime?
booking_participants
🔑idString
🔗bookingIdString
🔗userIdString
paymentStatusString
🔗paymentIdString?
isLeaderBoolean
certificates
🔑idString
🔗menteeIdString
🔗serviceIdString
certificateNumberString U
issueDateDateTime?
certificatePathString?
googleDriveUrlString?
projectCertificatePathString?
statusString?
verifiedByString?
noteString?
createdAtDateTime?
updatedAtDateTime?
commission_payments
🔑idString
🔗referralCodeIdString
amountDecimal
transactionIdString?
statusString?
paid_atDateTime?
notesString?
created_atDateTime
🔗withdrawalMethodIdString?
export_logs
🔑idString
entityString
typeString
createdAtDateTime
e_learning_audit_logs
🔑idString
🔗userIdString
entityTypeELearningAuditEntityType
entityIdString
actionELearningAuditAction
descriptionString?
oldValueJson?
newValueJson?
createdAtDateTime
e_learning_courses
🔑idString
🔗mentorIdString
titleString
descriptionString?
thumbnailImagesString[]
categoryString?
tagsString[]
targetAudienceString?
levelString?
estimatedDurationString?
benefitsString?
toolsUsedString?
isActiveBoolean?
slugString? U
statusCourseStatus?
createdAtDateTime?
updatedAtDateTime?
e_learning_course_stream_counts
🔑idString
🔗courseIdString
🔗userIdString
streamCountInt
createdAtDateTime?
updatedAtDateTime?
e_learning_sub_chapters
🔑idString
🔗courseIdString
titleString
coverImageString?
descriptionString?
orderNumberInt
estimatedTimeString?
taskTypeTaskType?
statusCourseStatus
levelString?
createdAtDateTime?
updatedAtDateTime?
e_learning_sub_babs
🔑idString
🔗subChapterIdString
titleString
orderNumberInt?
estimatedTimeString?
statusCourseStatus
createdAtDateTime?
updatedAtDateTime?
e_learning_texts
🔑idString
🔗subBabIdString
titleString?
orderNumberInt?
statusCourseStatus
createdAtDateTime?
updatedAtDateTime?
e_learning_text_blocks
🔑idString
🔗textIdString
orderNumberInt?
createdAtDateTime?
ct_e_learning_content_blocks
🔑idString
🔗blockIdString
typeContentBlockType
orderNumberInt?
createdAtDateTime?
ct_e_learning_heading_contents
🔑idString
🔗contentIdString U
levelInt
textString
ct_e_learning_paragraph_contents
🔑idString
🔗contentIdString U
textString
ct_e_learning_highlight_contents
🔑idString
🔗contentIdString U
textString
ct_e_learning_accordion_contents
🔑idString
🔗contentIdString U
titleString
descriptionString?
ct_e_learning_accordion_items
🔑idString
🔗accordionIdString
titleString
contentString
orderNumberInt
ct_e_learning_carousel_contents
🔑idString
🔗contentIdString U
titleString
descriptionString?
cardsPerSlideInt?
ct_e_learning_carousel_items
🔑idString
🔗carouselIdString
titleString
imageString?
contentString?
orderNumberInt
ct_e_learning_content_card_contents
🔑idString
🔗contentIdString U
titleString
descriptionString?
disableExpandableContentBoolean
ct_e_learning_content_card_items
🔑idString
🔗cardIdString
titleString
contentString
expandableContentString?
orderNumberInt
ct_e_learning_tab_navigation_contents
🔑idString
🔗contentIdString U
titleString
descriptionString?
ct_e_learning_tab_items
🔑idString
🔗tabIdString
titleString
contentString
orderNumberInt
ct_e_learning_summary_contents
🔑idString
🔗contentIdString U
ct_e_learning_summary_comments
🔑idString
🔗summaryIdString
commentString
orderNumberInt
ct_e_learning_additional_contents
🔑idString
🔗blockIdString
typeAdditionalContentType
positionAnchorPosition
orderNumberInt?
ct_e_learning_matching_questions
🔑idString
🔗additionalContentIdString U
titleString?
instructionString?
maxScoreFloat?
explanationString?
createdAtDateTime?
ct_e_learning_matching_items
🔑idString
🔗questionIdString
contentString
sideMatchingItemSide
orderNumberInt
matchWithIdString?
ct_e_learning_multiple_choice_questions
🔑idString
🔗additionalContentIdString U
questionString
descriptionString?
allowMultipleBoolean
explanationString?
ct_e_learning_multiple_choice_options
🔑idString
🔗questionIdString
contentString
isCorrectBoolean
orderNumberInt
ct_e_learning_image_video_contents
🔑idString
🔗additionalContentIdString U
titleString?
captionString?
descriptionString?
mediaTypeMediaType
urlString
thumbnailUrlString?
durationSecondsInt?
widthPercentInt?
createdAtDateTime?
ct_e_learning_executable_codes
🔑idString
🔗additionalContentIdString U
titleString?
descriptionString?
languageCodeLanguage
initialCodeString
isEditableBoolean
expectedResultString?
createdAtDateTime?
updatedAtDateTime?
e_learning_code_runs
🔑idString
🔗executableIdString
🔗userIdString
inputString?
outputString?
errorString?
executedAtDateTime?
executionTimeInt?
isSuccessBoolean?
ct_e_learning_quizzes
🔑idString
🔗textIdString U
titleString
descriptionString?
totalQuestionsInt?
timeLimitMinutesInt?
createdAtDateTime?
updatedAtDateTime?
ct_e_learning_questions
🔑idString
🔗quizIdString
questionTextString
optionsString[]
correctAnswersString[]
explanationString?
orderNumberInt?
createdAtDateTime?
e_learning_quiz_attempts
🔑idString
🔗quizIdString
🔗userIdString
scoreInt?
startedAtDateTime?
completedAtDateTime?
answersJson?
attemptNumberInt
isAutoGradedBoolean?
gradedByString?
gradedAtDateTime?
remarksString?
ct_e_learning_assignments
🔑idString
🔗textIdString U
titleString
descriptionString?
dueDaysInt?
createdAtDateTime?
updatedAtDateTime?
ct_e_learning_assignment_instructions
🔑idString
🔗assignmentIdString
instructionString
orderNumberInt
ct_e_learning_assignment_supporting_files
🔑idString
🔗assignmentIdString
nameString
typeSupportingFileType
urlString
pageCountInt?
formatString?
sizeKBInt?
createdAtDateTime?
e_learning_submissions
🔑idString
🔗assignmentIdString
🔗userIdString
attemptNumberInt
notesString?
filesString[]
submittedAtDateTime?
statusELearningSubmissionStatus
🔗reviewedByIdString?
reviewedAtDateTime?
feedbackString?
scoreInt?
gradeBreakdownJson?
isRevisionRequiredBoolean?
revisionDeadlineDateTime?
e_learning_subscription_plans
🔑idString
nameString
durationDayInt
priceDecimal
descriptionString?
isActiveBoolean
createdAtDateTime
updatedAtDateTime?
e_learning_subscriptions
🔑idString
🔗userIdString
🔗planIdString
🔗referralUsageIdString? U
startAtDateTime
endAtDateTime
statusString
createdAtDateTime
updatedAtDateTime?
e_learning_progress
🔑idString
🔗userIdString
🔗subBabIdString
isCompletedBoolean?
lastAccessedDateTime?
timeSpentInt?
lastActivityAtDateTime?
e_learning_sub_chapter_progress
🔑idString
🔗userIdString
🔗subChapterIdString
progressPercentFloat
lastActivityAtDateTime?
createdAtDateTime
updatedAtDateTime
e_learning_text_progress
🔑idString
🔗userIdString
🔗textIdString
progressFloat
lastAccessedAtDateTime?
createdAtDateTime
updatedAtDateTime
e_learning_block_progress
🔑idString
🔗userIdString
🔗blockIdString
progressInt
isCompletedBoolean
timeSpentInt?
lastActivityAtDateTime?
e_learning_reviews
🔑idString
🔗userIdString
🔗subChapterIdString
ratingDecimal
commentString?
isPublicBoolean
isAnonymousBoolean
createdAtDateTime?
e_learning_certificates
🔑idString
🔗subChapterIdString
🔗userIdString
certificateUrlString
certificatePathString?
issuedAtDateTime?
certificateNumberString U
displayNumberString U
statusString?
verifiedByString?
noteString?
e_learning_discussions
🔑idString
🔗courseIdString
🔗userIdString
contentString
🔗parentIdString?
createdAtDateTime?
e_learning_bookmarks
🔑idString
🔗userIdString
🔗subBabIdString
createdAtDateTime?
feedback
🔑idString
🔗sessionIdString
🔗userIdString
ratingDecimal
commentString?
submittedDateDateTime?
createdAtDateTime?
updatedAtDateTime?
isAnonymousBoolean
isVisibleBoolean
mentor_profiles
🔑idString
🔗userIdString U
expertiseString?
bioString?
experienceString?
availabilityScheduleJson?
hourlyRateDecimal?
isVerifiedBoolean?
linkedinString?
createdAtDateTime?
updatedAtDateTime?
mentor_earning_summaries
🔑idString
🔗mentorProfileIdString U
totalEarningsDecimal
totalThisMonthDecimal
totalLastMonthDecimal
growthPercentInt
updatedAtDateTime
createdAtDateTime
mentor_report
🔑idString
🔗sessionIdString
🔗mentorProfileIdString
understandingString?
participationString?
challengesString?
commonQuestionsString?
nextFocusString?
additionalNotesString?
createdAtDateTime
updatedAtDateTime
mentoring_services
🔑idString
serviceNameString
descriptionString?
priceDecimal
strikePriceDecimal?
serviceTypeString?
maxParticipantsInt?
durationDaysInt
startDateDateTime?
endDateDateTime?
thumbnailString?
whatsappGroupString?
programAboutString?
totalWeeksInt?
totalProjectsInt?
slugString? U
isFeaturedBoolean
difficultyOrderInt?
categoryString?
levelString?
isActiveBoolean?
installmentAvailableBoolean
maxInstallmentMonthsInt?
createdAtDateTime?
updatedAtDateTime?
mentoring_sections
🔑idString
🔗serviceIdString
typeMentoringSectionType
titleString
contentJson
orderInt
mentoring_tools
🔑idString
🔗serviceIdString
nameString
mentoring_schedules
🔑idString
🔗serviceIdString
dateDateTime
mentoring_portfolios
🔑idString
🔗serviceIdString
titleString
descriptionString?
menteeNameString
projectLinkString
thumbnailString?
mentoring_testimonials
🔑idString
🔗serviceIdString
nameString
roleString?
commentString
ratingInt
mentoring_service_mentors
🔑idString
🔗mentoringServiceIdString
🔗mentorProfileIdString
mentoring_sessions
🔑idString
🔗serviceIdString
dateString
startTimeString
endTimeString
durationMinutesInt
meetingLinkString?
meetingIdString?
passcodeString?
statusString?
notesString?
pptLinkString?
recordingLinkString?
createdAtDateTime?
updatedAtDateTime?
mentoring_session_mentors
🔑idString
🔗mentoringSessionIdString
🔗mentorProfileIdString
notifications
🔑idString
typeString
titleString
messageString?
deliveryMethodString?
actionUrlString?
sentAtDateTime?
metaJson?
targetRoleString[]
createdAtDateTime?
notification_recipients
🔑idString
🔗notificationIdString
🔗userIdString
isReadBoolean?
readAtDateTime?
payments
🔑idString
🔗bookingInvoiceIdString?
🔗practicePurchaseIdString? U
🔗eLearningSubscriptionIdString? U
🔗ayclBookingIdString? U
merchantOrderIdString? U
amountDecimal
installmentNumberInt?
dueDateDateTime?
reminderCountInt
lastReminderSentAtDateTime?
paymentDateDateTime?
paymentMethodString?
transactionIdString?
statusString?
createdAtDateTime?
updatedAtDateTime?
practice_files
🔑idString
🔗materialIdString
fileNameString
filePathString
fileTypeString
fileSizeInt?
orderNumberInt
createdAtDateTime?
updatedAtDateTime?
practice_materials
🔑idString
🔗practiceIdString
titleString
descriptionString?
orderNumberInt
statusString?
startDateDateTime?
endDateDateTime?
createdAtDateTime?
updatedAtDateTime?
practice_progress
🔑idString
🔗userIdString
🔗materialIdString
isCompletedBoolean?
lastAccessedDateTime?
timeSpentSecondsInt?
createdAtDateTime?
updatedAtDateTime?
practice_purchases
🔑idString
🔗userIdString
🔗practiceIdString
🔗referralUsageIdString? U
purchaseDateDateTime?
statusString?
createdAtDateTime?
updatedAtDateTime?
practice_reviews
🔑idString
🔗userIdString
🔗practiceIdString
ratingInt
commentString?
submittedDateDateTime?
createdAtDateTime?
updatedAtDateTime?
practice_submissions
🔑idString
🔗userIdString
🔗practiceIdString
notesString?
filesString[]
submittedAtDateTime?
statusString?
🔗reviewedByIdString?
reviewedAtDateTime?
kesesuaianString?
kualitasString?
kreativitasString?
kelengkapanString?
komentarString?
saranString?
perluRevisiBoolean?
practices
🔑idString
🔗mentorIdString
titleString
descriptionString?
thumbnailImagesString[]
priceDecimal
practiceTypeString?
categoryString?
tagsString[]
benefitsString?
toolsUsedString?
challengesString?
expectedOutcomesString?
estimatedDurationString?
targetAudienceString?
isActiveBoolean?
createdAtDateTime?
updatedAtDateTime?
projects
🔑idString
🔗serviceIdString
titleString
descriptionString?
createdAtDateTime?
updatedAtDateTime?
project_submissions
🔑idString
🔗projectIdString
🔗menteeIdString
🔗sessionIdString?
titleString?
filePathsString[]
projectLinkString?
submissionDateDateTime?
plagiarismScoreDecimal?
scoreDecimal?
briefScoreString?
technicalScoreString?
creativityScoreString?
completenessScoreString?
mentorFeedbackString?
mentorSuggestionString?
isReviewedBoolean?
reviewStatusReviewStatus
isRevisedRequiredBoolean?
revisionDeadlineDateTime?
🔗gradedByString?
createdAtDateTime?
updatedAtDateTime?
redeem_codes
🔑idString
codeString U
🔗planIdString
🔗createdByIdString
maxUsesInt
usedCountInt
expiresAtDateTime
isActiveBoolean
noteString?
createdAtDateTime
updatedAtDateTime?
redeem_code_usages
🔑idString
🔗redeemCodeIdString
🔗userIdString
🔗subscriptionIdString U
redeemedAtDateTime
redeem_code_attempts
🔑idString
🔗userIdString
successBoolean
createdAtDateTime
referral_commisions
🔑idString
🔗referralCodeIdString
transactionIdString
amountDecimal
tierAtTransactionString?
productTypeString
pointsAwardedInt?
🔗seasonIdString?
created_atDateTime
referral_codes
🔑idString
🔗ownerIdString
codeString U
createdDateDateTime?
expiryDateDateTime?
isActiveBoolean?
createdAtDateTime?
updatedAtDateTime?
referral_usages
🔑idString
🔗userIdString
🔗referralCodeIdString
usedAtDateTime
contextString
createdAtDateTime
updatedAtDateTime?
roles
🔑idString
roleNameString U
descriptionString?
createdAtDateTime?
short_links
🔑idString
shortCodeString U
originalUrlString
🔗createdByIdString?
expiresAtDateTime?
clickCountInt
isActiveBoolean
createdAtDateTime
updatedAtDateTime?
user_activity_logs
🔑idString
🔗userIdString
pageString
durationSecInt
accessedAtDateTime
user_behavior
🔑idString
🔗userIdString?
pageVisitedString
actionString?
timestampDateTime?
ipAddressString?
userAgentString?
createdAtDateTime?
user_roles
🔑idString
🔗userIdString
🔗roleIdString
assignedDateDateTime?
createdAtDateTime?
users
🔑idString
emailString U
passwordHashString?
googleIdString? U
fullNameString
phoneNumberString?
profilePictureString?
cityString?
provinceString?
isEmailVerifiedBoolean?
verificationTokenString?
verificationTokenExpiresDateTime?
registrationDateDateTime?
lastLoginDateTime?
isActiveBoolean?
fcmTokenString?
createdAtDateTime?
updatedAtDateTime?
instagramString?
twitterString?
youtubeString?
tiktokString?
otherSocialMediaString?
vouchers
🔑idString
codeString U
nameString
descriptionString?
discountTypeVoucherDiscountType
discountValueDecimal
maxDiscountAmountDecimal?
minimumPurchaseDecimal?
productScopeVoucherProductScope
usageLimitInt?
usageLimitPerUserInt
usageCountInt
startDateDateTime?
expiryDateDateTime?
isActiveBoolean
🔗createdByIdString?
createdAtDateTime
updatedAtDateTime
voucher_usages
🔑idString
🔗voucherIdString
🔗userIdString
statusVoucherUsageStatus
originalAmountDecimal
discountAmountDecimal
finalAmountDecimal
🔗bookingIdString? U
🔗practicePurchaseIdString? U
🔗eLearningSubscriptionIdString? U
🔗ayclBookingIdString? U
usedAtDateTime
withdrawal_methods
🔑idString
🔗userIdString
typeString
providerNameString
accountNumberString
accountNameString?
isActiveBoolean
createdAtDateTime
updatedAtDateTime
companies
🔑idString
companyNameString U
industryString?
companySizeString?
websiteString?
logoUrlString?
descriptionString?
createdAtDateTime
updatedAtDateTime
jobs
🔑idString
🔗companyIdString
jobTitleString
salaryMinInt?
salaryMaxInt?
cityString?
countryString?
workTypeString?
levelString?
experienceRequiredString?
descriptionString?
requirementsString?
isActiveBoolean
createdAtDateTime
updatedAtDateTime
🔑 = Primary Key · 🔗 = Foreign Key · scroll untuk zoom, Drag untuk geser, Klik tabel untuk highlight relasi dan buka dokumentasinya di bawah.