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