Re:visit

Tables (75)

Ad

  • adId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • publishedAt — timestamp
  • title — varchar(255) — NOT NULL
  • image — varchar(255) — NOT NULL
  • type — enum — NOT NULL
  • location — enum — NOT NULL
  • link — varchar(255) — NOT NULL
  • views — int — NOT NULL
  • clicks — int — NOT NULL
  • startAt — timestamp — NOT NULL
  • endAt — timestamp — NOT NULL
  • orderNumber — int

AdTracking

  • adTrackingId — Primary key — NOT NULL
  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • type — enum — NOT NULL
  • etc — varchar(255)
  • userId — int
  • adId (adId2) — Foreign key → Ad.adId — NOT NULL
  • userId (userId2) — Foreign key → User.userId — NOT NULL

Admin

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • username — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • role — enum — NOT NULL
  • phone — varchar(255) — NOT NULL

Aftercare

  • aftercareId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • name — varchar(255) — NOT NULL
  • hospitalId — int
  • sendCount — int — NOT NULL
  • medicalDepartmentItemId — int
  • medicalType — enum — NOT NULL
  • order — int — NOT NULL
  • hospitalId (hospitalId2) — Foreign key → Hospital.hospitalId — NOT NULL

AftercareBookmark

  • aftercareBookmarkId — Primary key — NOT NULL
  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • order — int — NOT NULL
  • hospitalId (hospitalId2) — Foreign key → Hospital.hospitalId — NOT NULL
  • aftercareId (aftercareId2) — Foreign key → Aftercare.aftercareId — NOT NULL

AftercareTemplate

  • aftercareTemplateId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • daysToSend — int — NOT NULL
  • aftercareId — int
  • alimtalkTemplateId (alimtalkTemplateId2) — Foreign key → AlimtalkTemplate.alimtalkTemplateId — NOT NULL

AlimtalkMessage

  • alimtalkMessageId — Primary key — NOT NULL
  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • nhnRequestId — varchar(255)
  • nhnRequestSequence — int
  • phone — varchar(255) — NOT NULL
  • status — enum — NOT NULL
  • receivedAt — timestamp
  • etc — varchar(255)
  • sendAt — timestamp
  • reservatedAt — timestamp
  • templateCode — varchar(255) — NOT NULL
  • templateParameter — varchar(500)
  • failReason — varchar(255)
  • resendRequestId — varchar(255)
  • resendStatus — varchar(255)
  • alimtalkTemplateId — Foreign key → AlimtalkTemplate.alimtalkTemplateId — NOT NULL
  • userId (userId2) — Foreign key → User.userId — NOT NULL

AlimtalkMessageGroup

  • alimtalkMessageGroupId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • senderGroupingKey — varchar(255) — NOT NULL
  • type — enum — NOT NULL
  • templateCode — varchar(255) — NOT NULL
  • cancelReason — varchar(255)
  • nhnRequestId — varchar(255)
  • status — enum — NOT NULL
  • target — enum — NOT NULL
  • ages — text
  • sendCount — int — NOT NULL
  • reservatedAt — timestamp
  • successCount — int — NOT NULL
  • failCount — int — NOT NULL
  • viewTarget — enum
  • yearType — enum
  • tags — text
  • sendTags — text
  • aftercareIds — text
  • aftercareTemplateId — Foreign key → AftercareTemplate.aftercareTemplateId — NOT NULL
  • aftercareId (aftercareId2) — Foreign key → Aftercare.aftercareId — NOT NULL
  • hospitalId (hospitalId2) — Foreign key → Hospital.hospitalId — NOT NULL

AlimtalkTemplate

  • alimtalkTemplateId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • name — varchar(255) — NOT NULL
  • status — enum — NOT NULL
  • type — enum — NOT NULL
  • code — varchar(255) — NOT NULL
  • alimtalkKey — varchar(255) — NOT NULL
  • link — varchar(500)
  • link2 — varchar(500)
  • link3 — varchar(500)
  • link4 — varchar(500)
  • link5 — varchar(500)
  • templateTitle — varchar(255)
  • templateSubtitle — varchar(255)
  • templateContent — varchar(1000)
  • editStatus — enum
  • buttonName — varchar(30)
  • buttonName2 — varchar(30)
  • buttonName3 — varchar(30)
  • buttonName4 — varchar(30)
  • buttonName5 — varchar(30)
  • orderNumber — int
  • hospitalId — Foreign key → Hospital.hospitalId — NOT NULL

CRMAttachment

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • link — varchar(500) — NOT NULL
  • mimeType — varchar(20) — NOT NULL
  • password — varchar(255) — NOT NULL
  • messageGroupId — int
  • hospitalId — int
  • userId — int
  • type — enum — NOT NULL

CRMMessageTracking

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • type — enum — NOT NULL
  • action — enum — NOT NULL
  • link — varchar(500)
  • templateCode — varchar(255) — NOT NULL
  • hospitalId — int
  • userId — int
  • messageGroupId — int — NOT NULL
  • messageId — int — NOT NULL
  • osName — varchar(255)
  • osVersion — varchar(255)
  • browserName — varchar(255)
  • browserVersion — varchar(255)

CRMPaymentHistory

  • crmPaymentHistoryId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • paymentKey — varchar(255)
  • orderId — varchar(255) — NOT NULL
  • orderName — varchar(255) — NOT NULL
  • amount — int — NOT NULL
  • cancelAmount — int
  • status — enum — NOT NULL
  • canceledAt — timestamp
  • cancelReason — varchar(255)
  • requestedAt — timestamp
  • approvedAt — timestamp
  • failedAt — timestamp
  • failReason — varchar(255)
  • content — varchar(1000)
  • etc — varchar(255)
  • startedAt — timestamp
  • endedAt — timestamp
  • paymentType — enum — NOT NULL
  • hospitalId (hospitalId2) — Foreign key → Hospital.hospitalId — NOT NULL
  • hospitalBillingId (hospitalBillingId2) — Foreign key → HospitalBilling.hospitalBillingId — NOT NULL

Content

  • contentId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • publishedAt — timestamp
  • title — varchar(255) — NOT NULL
  • thumbnail — varchar(255)
  • content — mediumtext
  • type — enum — NOT NULL
  • url — varchar(255) — NOT NULL
  • hospitalId — int
  • views — int — NOT NULL
  • shares — int — NOT NULL
  • shareViews — int — NOT NULL
  • maker — enum — NOT NULL

ContentAssignContentHashtag

  • contentId (contentId2) — Foreign key → Content.contentId — NOT NULL
  • hashtagId (hashtagId2) — Foreign key → Hashtag.hashtagId — NOT NULL

ContentAssignMedicalDepartmentItem

  • contentId — int — Primary key — NOT NULL
  • medicalDepartmentItemId — int — Primary key — NOT NULL

ContentTracking

  • contentTrackingId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • type — enum — NOT NULL
  • startContentId — int
  • prevContentId — int
  • etc — varchar(255)
  • contentId (contentId2) — Foreign key → Content.contentId — NOT NULL
  • userId (userId2) — Foreign key → User.userId — NOT NULL

Doctor

  • doctorId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • publishedAt — timestamp
  • name — varchar(255) — NOT NULL
  • image — varchar(255) — NOT NULL
  • position — varchar(255) — NOT NULL
  • maxSlot — int — NOT NULL
  • duration — int — NOT NULL
  • phone — varchar(255) — NOT NULL
  • hospitalId (hospitalId2) — Foreign key → Hospital.hospitalId — NOT NULL

DoctorHoliday

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • startDate — date — NOT NULL
  • endDate — date — NOT NULL
  • name — varchar(255) — NOT NULL
  • type — enum — NOT NULL
  • occurrence — enum — NOT NULL
  • doctorId (doctorId2) — Foreign key → Doctor.doctorId — NOT NULL

DoctorHolidaySetting

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • interval — enum — NOT NULL
  • days — text — NOT NULL
  • biweeklyStartDate — timestamp
  • monthlyHolidayWeeks — text — NOT NULL
  • isNewYear — tinyint — NOT NULL
  • isPreLunarNewYear — tinyint — NOT NULL
  • isLunarNewYear — tinyint — NOT NULL
  • isPostLunarNewYear — tinyint — NOT NULL
  • isIndependenceMovementDay — tinyint — NOT NULL
  • isChildrenDay — tinyint — NOT NULL
  • isBuddhaBirthday — tinyint — NOT NULL
  • isMemorialDay — tinyint — NOT NULL
  • isLiberationDay — tinyint — NOT NULL
  • isPreChuseok — tinyint — NOT NULL
  • isChuseok — tinyint — NOT NULL
  • isPostChuseok — tinyint — NOT NULL
  • isNationalFoundationDay — tinyint — NOT NULL
  • isHangulDay — tinyint — NOT NULL
  • isChristmas — tinyint — NOT NULL
  • etc — varchar(255) — NOT NULL
  • doctorId (doctorId2) — Foreign key → Doctor.doctorId — NOT NULL

DoctorOperatingHour

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • days — text
  • type — enum — NOT NULL
  • temporaryOperatingDate — varchar(255)
  • operatingTime — varchar(255) — NOT NULL
  • breakTimes — text — NOT NULL
  • doctorId (doctorId2) — Foreign key → Doctor.doctorId — NOT NULL

Event

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • publishedAt — timestamp
  • name — varchar(255) — NOT NULL
  • description — text — NOT NULL
  • startDate — date
  • endDate — date
  • maxParticipants — int — NOT NULL
  • price — int — NOT NULL
  • thumbnail — varchar(255) — NOT NULL
  • hospitalId — int
  • budget — int — NOT NULL
  • dailyBudget — int — NOT NULL
  • discountPrice — int — NOT NULL
  • receptionCategoryId — int
  • currentParticipants — int — NOT NULL
  • approvedAt — timestamp
  • rejectedAt — timestamp
  • reason — varchar(255)
  • period — enum — NOT NULL
  • closedAt — timestamp
  • status — enum — NOT NULL
  • ratings — double — NOT NULL
  • reviews — int — NOT NULL
  • isVatIncluded — tinyint — NOT NULL
  • priceType — enum — NOT NULL

EventDeductionHistory

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • type — varchar(255) — NOT NULL
  • amount — int — NOT NULL
  • eventId — int
  • hospitalId — int
  • userId — int
  • name — varchar(255)
  • dateOfBirth — varchar(255)
  • phone — varchar(255)
  • utmSource — varchar(255)

EventHistory

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • eventId — int
  • etc — varchar(255)
  • contents — varchar(1500) — NOT NULL

EventImage

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • image — varchar(255) — NOT NULL
  • eventId — int

EventReview

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • contents — varchar(255) — NOT NULL
  • ratings — int — NOT NULL
  • additionalQuestions — text — NOT NULL
  • eventId — int
  • userId — int

EventViewHistory

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • name — varchar(255)
  • dateOfBirth — varchar(255)
  • funnel — varchar(255)
  • eventId — int

FaxHistory

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • receiptNumber — varchar(255) — NOT NULL
  • sender — varchar(255) — NOT NULL
  • receiver — varchar(255) — NOT NULL
  • receiverName — varchar(255)
  • status — enum — NOT NULL
  • code — varchar(255) — NOT NULL
  • hospitalId — int
  • userId — int

Hashtag

  • hashtagId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • name — varchar(255) — NOT NULL

Holiday

  • holidayId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • name — varchar(255) — NOT NULL
  • date — date — NOT NULL
  • isTemporary — tinyint — NOT NULL

Hospital

  • hospitalId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • publishedAt — timestamp
  • username — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • logo — varchar(255) — NOT NULL
  • role — enum — NOT NULL
  • address — varchar(255) — NOT NULL
  • addressDetail — varchar(255) — NOT NULL
  • aka — varchar(255) — NOT NULL
  • mainNumber — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL
  • kakaopay — varchar(255)
  • alimtalkKey — varchar(255)
  • activatedAt — timestamp
  • analyticsCode — varchar(255)
  • openingTime — varchar(255) — NOT NULL
  • checkinStartedAt — timestamp
  • telemedicineStartedAt — timestamp
  • receptionStartedAt — timestamp
  • accountHolder — varchar(255)
  • accountNumber — varchar(255)
  • bankName — varchar(255)
  • customerKey — varchar(255)
  • recentPlanType — enum
  • planDiscountAmount — int
  • planDiscount — varchar(255)
  • longitude — double
  • latitude — double
  • region1 — varchar(255)
  • region2 — varchar(255)
  • region3 — varchar(255)
  • hospitalEventBudgetId — int
  • eventStartedAt — timestamp
  • crmStartedAt — timestamp
  • smsNumber — varchar(255)
  • hospitalCRMId — int
  • contentShareImage — varchar(255)
  • paymentType — enum — NOT NULL
  • hospitalEventBudgetId (hospitalEventBudgetId2) — Foreign key → HospitalEventBudget.hospitalEventBudgetId — NOT NULL

HospitalAlert

  • hospitalAlertId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • title — varchar(255) — NOT NULL
  • contents — varchar(255) — NOT NULL
  • type — enum — NOT NULL
  • action — varchar(255) — NOT NULL
  • readAt — timestamp
  • hospitalId (hospitalId2) — Foreign key → Hospital.hospitalId — NOT NULL

HospitalAssignMedicalDepartment

  • hospitalId — int — Primary key — NOT NULL
  • medicalDepartmentId — int — Primary key — NOT NULL

HospitalBank

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • publishedAt — timestamp
  • accountHolder — varchar(255) — NOT NULL
  • accountNumber — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • hospitalId (hospitalId2) — Foreign key → Hospital.hospitalId — NOT NULL

HospitalBilling

  • hospitalBillingId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • billingKey — varchar(255) — NOT NULL
  • cardNumber — varchar(255) — NOT NULL
  • cardIssuerCode — varchar(255) — NOT NULL
  • acquireCode — varchar(255) — NOT NULL
  • cardType — varchar(255) — NOT NULL
  • ownerType — varchar(255) — NOT NULL
  • cardCompany — varchar(255) — NOT NULL
  • hospitalId (hospitalId2) — Foreign key → Hospital.hospitalId — NOT NULL

HospitalCRM

  • hospitalCrmId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • smsPrice — int — NOT NULL
  • lmsPrice — int — NOT NULL
  • alimtalkPrice — int — NOT NULL
  • alimtalkFreeCount — int — NOT NULL
  • alimtalkFreeMonthLimit — int — NOT NULL
  • csChannel — varchar(255)
  • templateChannel — varchar(255)
  • hospitalId — Foreign key → Hospital.hospitalId — NOT NULL

HospitalEventBudget

  • hospitalEventBudgetId — Primary key — NOT NULL
  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • publishedAt — timestamp
  • amount — int — NOT NULL
  • autoChargeAmount — int — NOT NULL

HospitalEventChargeHistory

  • hospitalEventChargeHistoryId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • name — varchar(255) — NOT NULL
  • type — varchar(255) — NOT NULL
  • amount — int — NOT NULL
  • paymentKey — varchar(255)
  • orderName — varchar(255) — NOT NULL
  • orderId — varchar(255) — NOT NULL
  • hospitalBillingId — int
  • hospitalId (hospitalId2) — Foreign key → Hospital.hospitalId — NOT NULL
  • hospitalBillingId (hospitalBillingId2) — Foreign key → HospitalBilling.hospitalBillingId — NOT NULL

HospitalNotification

  • hospitalNotificationId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • publishedAt — timestamp
  • type — enum — NOT NULL
  • value — varchar(255) — NOT NULL
  • hospitalId (hospitalId2) — Foreign key → Hospital.hospitalId — NOT NULL

HospitalNotificationHistory

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • template — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • type — varchar(255) — NOT NULL
  • value — varchar(255) — NOT NULL
  • success — tinyint — NOT NULL
  • hospitalId — int

HospitalPlan

  • hospitalPlanId — Primary key — NOT NULL
  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • startDate — date — NOT NULL
  • endDate — date — NOT NULL
  • canceledAt — timestamp
  • approvedAt — timestamp
  • doctorCount — int — NOT NULL
  • expectedAt — date — NOT NULL
  • failedAt — timestamp
  • failReason — varchar(255)
  • cancelReason — varchar(255)
  • planId (planId2) — Foreign key → Plan.planId — NOT NULL
  • hospitalId (hospitalId2) — Foreign key → Hospital.hospitalId — NOT NULL

HospitalSNS

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • type — enum — NOT NULL
  • url — varchar(255)
  • hospitalId — int

HospitalSetting

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • name — enum
  • value — varchar(255)
  • hospitalId — int

HospitalSettlement

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • month — varchar(255) — NOT NULL
  • amount — int — NOT NULL
  • fee — int — NOT NULL
  • total — int — NOT NULL
  • hospitalId — int

HospitalSettlementBank

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • publishedAt — timestamp
  • accountHolder — varchar(255) — NOT NULL
  • accountNumber — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • hospitalId (hospitalId2) — Foreign key → Hospital.hospitalId — NOT NULL

MedicalDepartment

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • name — varchar(255) — NOT NULL
  • code — varchar(255)

MedicalDepartmentItem

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • name — varchar(255) — NOT NULL
  • medicalDepartmentId — int

Notice

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • title — varchar(255) — NOT NULL
  • content — text — NOT NULL
  • tag — varchar(255)
  • thumbnail — varchar(255)

Plan

  • planId — Primary key — NOT NULL
  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • publishedAt — timestamp
  • name — varchar(255) — NOT NULL
  • amount — int — NOT NULL
  • discountPercentage — int — NOT NULL
  • type — enum — NOT NULL
  • orderNumber — int — NOT NULL
  • startDate — date — NOT NULL
  • endDate — date — NOT NULL

PlanPayment

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • paymentKey — varchar(255)
  • orderId — varchar(255) — NOT NULL
  • orderName — varchar(255) — NOT NULL
  • amount — int — NOT NULL
  • cancelReason — varchar(255)
  • cancelAmount — int
  • status — enum — NOT NULL
  • canceledAt — timestamp
  • requestedAt — timestamp
  • approvedAt — timestamp
  • failedAt — timestamp
  • failReason — varchar(255)
  • hospitalPlanId (hospitalPlanId2) — Foreign key → HospitalPlan.hospitalPlanId — NOT NULL
  • hospitalId (hospitalId2) — Foreign key → Hospital.hospitalId — NOT NULL
  • hospitalBillingId (hospitalBillingId2) — Foreign key → HospitalBilling.hospitalBillingId — NOT NULL

Reception

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • name — varchar(255) — NOT NULL
  • code — varchar(255) — NOT NULL
  • rrn — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL
  • visited — varchar(255) — NOT NULL
  • signImage — varchar(255) — NOT NULL
  • type — enum — NOT NULL
  • status — enum — NOT NULL
  • confirmedAt — timestamp
  • visitedAt — timestamp
  • reservedAt — timestamp
  • hopeReservedAt — timestamp
  • nextReservedAt — timestamp
  • telemedicineChangedAt — timestamp
  • userReservedChangedAt — timestamp
  • cancelReason — varchar(255)
  • requestReservationReason — varchar(255)
  • canceledAt — timestamp
  • completedAt — timestamp
  • noShowedAt — date
  • hospitalId — int
  • doctorId — int
  • userId — int
  • surveyId — int
  • memo — varchar(255)
  • utmSource — varchar(255)

ReceptionAssignEvent

  • receptionId — int — Primary key — NOT NULL
  • eventId — int — Primary key — NOT NULL

ReceptionAssignReceptionCategory

  • receptionId — int — Primary key — NOT NULL
  • receptionCategoryId — int — Primary key — NOT NULL

ReceptionCategory

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • publishedAt — timestamp
  • name — varchar(255) — NOT NULL
  • image — varchar(255)
  • hospitalId — int

ReceptionCategoryAnswer

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • question — varchar(255) — NOT NULL
  • answer — varchar(255) — NOT NULL
  • questionType — enum — NOT NULL
  • receptionId — int

ReceptionCategoryQuestion

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • publishedAt — timestamp
  • question — varchar(255) — NOT NULL
  • type — enum — NOT NULL
  • receptionCategoryId — int

ReceptionNotificationReservation

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • code — varchar(255) — NOT NULL
  • type — enum — NOT NULL
  • template — varchar(255) — NOT NULL
  • alimtalkKey — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL
  • templateParameter — varchar(2000) — NOT NULL
  • reservedAt — timestamp — NOT NULL
  • sentAt — timestamp
  • status — enum — NOT NULL
  • reason — varchar(255)
  • hospitalId — int

ReceptionPaperAnswer

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • question — varchar(255) — NOT NULL
  • answer — varchar(255) — NOT NULL
  • questionType — enum — NOT NULL
  • answerType — varchar(255) — NOT NULL
  • receptionPaperFormId — int

ReceptionPaperForm

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • hospitalId — int
  • userId — int
  • receptionId — int
  • receptionPaperTemplateId — int
  • status — enum — NOT NULL

ReceptionPaperHistory

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • status — varchar(255) — NOT NULL
  • receptionPaperFormId — int

ReceptionPaperQuestion

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • title — varchar(255) — NOT NULL
  • type — enum — NOT NULL
  • required — tinyint — NOT NULL
  • receptionPaperTemplateId — int
  • multiple — tinyint — NOT NULL

ReceptionPaperQuestionItem

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • title — varchar(255) — NOT NULL
  • type — varchar(255) — NOT NULL
  • receptionPapeQuestionId — int

ReceptionPaperTemplate

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • title — varchar(255) — NOT NULL
  • description — varchar(255) — NOT NULL
  • hospitalId — int

SMS

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • phone — varchar(255) — NOT NULL
  • code — varchar(255) — NOT NULL

SMSMessage

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • nhnRequestId — varchar(255)
  • nhnRequestSequence — int
  • phone — varchar(255) — NOT NULL
  • status — enum — NOT NULL
  • receivedAt — timestamp
  • etc — varchar(255)
  • smsMessageGroupId — int
  • userId — int
  • sendAt — timestamp
  • reservatedAt — timestamp
  • failReason — varchar(255)
  • title — varchar(255)
  • contents — varchar(2000)
  • templateParameter — varchar(500)

SMSMessageGroup

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • type — enum — NOT NULL
  • sendType — enum — NOT NULL
  • cancelReason — varchar(255)
  • isAds — tinyint — NOT NULL
  • nhnRequestId — varchar(255)
  • title — varchar(255)
  • contents — text — NOT NULL
  • status — enum — NOT NULL
  • hospitalId — int
  • target — enum — NOT NULL
  • ages — text
  • sendCount — int — NOT NULL
  • reservatedAt — timestamp
  • successCount — int — NOT NULL
  • failCount — int — NOT NULL
  • tags — text
  • sendTags — text
  • aftercareIds — text
  • yearType — enum
  • viewTarget — enum

SMSMessageUrl

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • phone — varchar(255) — NOT NULL
  • link — varchar(255) — NOT NULL
  • aka — varchar(255) — NOT NULL
  • smsMessageGroupId — int
  • hospitalId — int

SMSTemplate

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • name — varchar(255) — NOT NULL
  • sendType — enum — NOT NULL
  • isAds — tinyint — NOT NULL
  • status — enum — NOT NULL
  • type — enum — NOT NULL
  • title — varchar(255)
  • content — varchar(1000)
  • hospitalId — int

Survey

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • name — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL
  • birth — varchar(255) — NOT NULL
  • hospitalId — int

SurveyAnswer

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • questionId — varchar(255) — NOT NULL
  • answers — text
  • selfInput — varchar(255)
  • surveyId — int

Telemedicine

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • publishedAt — timestamp
  • name — varchar(255) — NOT NULL
  • code — varchar(255) — NOT NULL
  • rrn — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL
  • symptom — varchar(255) — NOT NULL
  • visited — varchar(255) — NOT NULL
  • price — int — NOT NULL
  • prescription — varchar(255) — NOT NULL
  • cancelReason — varchar(255)
  • delayReason — varchar(255)
  • paymentMethod — enum — NOT NULL
  • status — enum — NOT NULL
  • reservatedAt — timestamp
  • canceledAt — timestamp
  • calledAt — timestamp
  • paymentRequestedAt — timestamp
  • paymentCheckedAt — timestamp
  • repaymentRequestedAt — timestamp
  • completedAt — timestamp
  • hospitalId — int
  • telemedicineCategoryId — int
  • doctorId — int
  • userId — int
  • videoCallId — varchar(255)
  • memo — varchar(255)
  • utmSource — varchar(255)

TelemedicineCategory

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • publishedAt — timestamp
  • name — varchar(255) — NOT NULL
  • image — varchar(255)
  • hospitalId — int

TelemedicinePayment

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • paymentKey — varchar(255) — NOT NULL
  • orderId — varchar(255) — NOT NULL
  • code — varchar(255) — NOT NULL
  • amount — int — NOT NULL
  • method — varchar(255) — NOT NULL
  • cancelReason — varchar(255)
  • cancelAmount — int
  • status — enum — NOT NULL
  • canceledAt — timestamp
  • requestedAt — timestamp
  • approvedAt — timestamp
  • hospitalId — int
  • telemedicineId — int
  • hospitalSettlementId — int
  • totalAmount — int — NOT NULL
  • discountAmount — int — NOT NULL
  • provider — varchar(255)
  • easyPayAmount — int — NOT NULL

TelemedicineVideoCallHistory

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • status — enum — NOT NULL
  • date — timestamp — NOT NULL
  • telemedicineId — int

User

  • userId — Primary key — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • name — varchar(255) — NOT NULL
  • rrn — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL
  • address — varchar(255)
  • role — enum — NOT NULL
  • visitedAt — timestamp
  • visits — int — NOT NULL
  • hospitalId — int
  • uploadedAt — timestamp
  • marketingAgreedAt — timestamp
  • lastLinkViewAt — timestamp
  • linkViewCount — int — NOT NULL
  • chartNumber — varchar(255)
  • lastSentAt — timestamp
  • grade — varchar(255)
  • topDepartmentItem — text
  • signupPath — varchar(255)
  • memo — varchar(1000)

UserAftercareLabel

  • id — int
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • deletedAt — timestamp(6)
  • topDepartmentItem — text
  • grade — varchar(255)
  • responseRatio — int
  • userId — int
  • hospitalId — int