cmsV2_latest

Tables (93)

AccountClosure

  • id — int
  • branchId — int — NOT NULL
  • year — smallint — NOT NULL
  • month — smallint — NOT NULL
  • isClosed — tinyint(1) — NOT NULL
  • managerId — int — NOT NULL
  • updatedAt — timestamp — NOT NULL

AppVersion

  • id — int
  • osType — enum — NOT NULL
  • version — varchar(10) — NOT NULL
  • effectiveAt — timestamp
  • obsoleteAt — timestamp
  • downloadUrl — varchar(1024)
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

Attachment

  • id — int
  • entityType — enum — NOT NULL
  • entityId — int — NOT NULL
  • type — enum — NOT NULL
  • name — varchar(200)
  • fileId — int — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

Bank

  • id — int
  • code — varchar(50) — NOT NULL
  • name — varchar(50) — NOT NULL
  • isUsed — tinyint(1) — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

Banner

  • id — int — 기본키' primary ke
  • type — enum — NOT NULL — 베네핏, 홈
  • benefitId — int — 베네핏 url 과 연관
  • title — varchar(255) — NOT NULL
  • subtitle — varchar(255)
  • imageUrl — varchar(1024)
  • url — varchar(1024) — 절대 path 또는 benefit 상대 path
  • startAt — datetime — NOT NULL
  • endAt — datetime — NOT NULL
  • announcement — varchar(1000) — 게시 적용시간 안내 문구
  • orderNo — int
  • managerId — int — 작성 매니저 Id
  • isPublic — tinyint(1) — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

Benefit

  • id — int — 기본키' primary ke
  • benefitCompanyId — int
  • managerId — int
  • usage — enum — NOT NULL — 온라인/오프라인/온라인+오프라인/기타
  • address — varchar(255)
  • title — varchar(255) — NOT NULL
  • type — enum — NOT NULL — 베네핏 유형 (플러스 혜택, 패파맛집, 제휴혜택)
  • isPublic — tinyint(1) — NOT NULL
  • imageUrl — varchar(1024) — 이미지 URL 1개
  • summary — varchar(255) — 제휴/플러스 혜택: 한줄요약, 패파맛집: 혜택 내용
  • detail — text — html
  • description — text — html
  • isAllowGuest — tinyint(1) — NOT NULL
  • contact — varchar(16) — type: restaurant 인 경우만
  • memo — varchar(1000)
  • postStart — datetime — 베네핏 게시 시작일
  • postEnd — datetime — 베네핏 게시 종료일
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BenefitBranchMapping

  • benefitId — int — Primary key — NOT NULL
  • branchId — int — Primary key — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BenefitCategory

  • id — int — 기본키' primary ke
  • managerId — int
  • parentId — int — BenefitCategory.id (self)
  • title — varchar(255) — NOT NULL
  • orderNo — int — index
  • depth — smallint — NOT NULL — 대분류 1, 중분류 2, 소분류 3, ...
  • isPublic — tinyint(1) — NOT NULL — 기본 공개(1)
  • isMain — tinyint(1) — NOT NULL — 메인페이지에 디스플레이 되는지 여부
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BenefitCategoryMapping

  • benefitId — int — Primary key — NOT NULL
  • benefitCategoryId — int — Primary key — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BenefitCompany

  • id — int — 기본키' primary ke
  • managerId — int
  • name — varchar(50) — NOT NULL
  • isPublic — tinyint(1) — NOT NULL
  • contractStart — datetime
  • contractEnd — datetime
  • profitSharing — tinyint(1)
  • email — varchar(200)
  • commission — bigint
  • representative — varchar(50)
  • contactPerson — varchar(50)
  • phone — varchar(16)
  • phoneEtc — varchar(255)
  • memo — varchar(1000)
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BenefitCuration

  • id — int — 기본키' primary ke
  • title — varchar(255) — NOT NULL
  • orderNo — int
  • isPublic — tinyint(1)
  • managerId — int
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BenefitCurationMapping

  • benefitId — int — Primary key — NOT NULL — PK
  • benefitCurationId — int — Primary key — NOT NULL — PK
  • orderNo — tinyint — 동일 benefitCurationId 내에서 정렬 순번
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BenefitHistory

  • id — int — 기본키' primary ke
  • benefitId — int — NOT NULL — 방문한 베네핏 ID
  • memberId — int — 검색자 ID
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BenefitRegion

  • id — int — 기본키' primary ke
  • name — varchar(50) — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BenefitRegionMapping

  • benefitRegionId — int — Primary key — NOT NULL — 기본키
  • branchId — int — Primary key — NOT NULL — 기본키
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BenefitSearchHistory

  • id — int — 기본키' primary ke
  • memberId — int — 검색자 ID
  • keyword — varchar(50) — NOT NULL — 검색어
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BenefitSearchKeyword

  • id — int — 기본키' primary ke
  • keyword — varchar(20) — NOT NULL
  • orderNo — int
  • managerId — int — 작성자 ID
  • isPublic — tinyint(1)
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

BenefitTag

  • id — int — 기본키' primary ke
  • name — varchar(50) — NOT NULL
  • type — enum — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BenefitTagMapping

  • benefitId — int — Primary key — NOT NULL
  • benefitTagId — int — Primary key — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BillingRequest

  • id — int
  • branchId — int — NOT NULL
  • title — varchar(255) — NOT NULL
  • type — enum — NOT NULL
  • issueDate — date — NOT NULL
  • status — enum — NOT NULL
  • managerId — int — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BillingRequestCharge

  • id — int
  • billingRequestId — int — NOT NULL
  • chargeId — int — NOT NULL
  • billingId — int
  • updatedAt — timestamp — NOT NULL

Branch

  • id — int
  • regionId — int — NOT NULL
  • brandCategory — enum — NOT NULL — 사업 유형
  • branchNo — smallint — NOT NULL
  • name — varchar(50) — NOT NULL
  • engName — varchar(50) — NOT NULL
  • registrationNo — varchar(14) — NOT NULL
  • address — varchar(255) — NOT NULL
  • zipcode — char(5) — NOT NULL
  • contactNo — varchar(16)
  • smsContactNo — varchar(16)
  • accountBank — varchar(50) — NOT NULL
  • accountNo — varchar(50) — NOT NULL
  • billingEmail — varchar(200) — NOT NULL
  • isOpen — tinyint(1) — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • brandSubCategory — enum — NOT NULL — 브랜드 서브 카테고리
  • subRegistrationNo — varchar(4) — 종사업자번호
  • sfId — varchar(40)

BranchGuide

  • id — int
  • branchId — int — NOT NULL
  • orderNo — smallint — NOT NULL
  • title — varchar(255) — NOT NULL
  • contents — text — NOT NULL
  • linkUrl — varchar(1024)
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BranchGuideImage

  • id — int
  • branchId — int — NOT NULL
  • name — varchar(20) — NOT NULL
  • orderNo — smallint — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

BranchInfo

  • id — int
  • branchId — int — NOT NULL
  • wifiInfo — text — NOT NULL
  • cmInfo — varchar(255) — NOT NULL
  • officeHours — text
  • buildingInfo — text — NOT NULL
  • parkingInfo — text — NOT NULL
  • postInfo — text — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • isActive — tinyint(1) — NOT NULL

BranchNotice

  • id — int
  • branchId — int — NOT NULL
  • priority — enum — NOT NULL
  • title — varchar(255) — NOT NULL
  • contents — text — NOT NULL
  • linkUrl — varchar(1024)
  • isMainNotice — tinyint(1) — NOT NULL
  • managerId — int — NOT NULL
  • messageJobId — int
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

Charge

  • id — int
  • contractId — int — NOT NULL
  • category — enum — NOT NULL
  • chargeNo — varchar(7) — NOT NULL
  • dueDate — date — NOT NULL
  • price — bigint — NOT NULL
  • description — text
  • taxIdentificationId — int
  • paymentType — enum — NOT NULL
  • paymentName — varchar(50)
  • paymentRelation — varchar(50)
  • billingType — enum — NOT NULL
  • billingName — varchar(50)
  • billingNo — varchar(14)
  • billingEmail — varchar(200)
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

ChargeBilling

  • id — int
  • chargeId — int — NOT NULL
  • orderNo — smallint — NOT NULL
  • billingType — enum — NOT NULL
  • billingName — varchar(50)
  • billingNo — varchar(14)
  • billingEmail — varchar(200)
  • date — date
  • price — bigint — NOT NULL
  • authCode — varchar(50)
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

ChargePayment

  • id — int
  • chargeId — int — NOT NULL
  • orderNo — smallint — NOT NULL
  • paymentType — enum — NOT NULL
  • paymentName — varchar(50)
  • paymentRelation — varchar(50)
  • date — date — NOT NULL
  • price — bigint — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

CommunityEvent

  • id — int
  • name — varchar(50) — NOT NULL
  • repName — varchar(50) — NOT NULL
  • contactNo — varchar(16)
  • email — varchar(200)
  • managerId — int — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

CommunityEventSession

  • id — int
  • communityEventId — int — NOT NULL
  • title — varchar(255) — NOT NULL
  • startDate — date — NOT NULL
  • endDate — date — NOT NULL
  • startTime — time
  • endTime — time
  • location — varchar(255) — NOT NULL
  • locationUrl — varchar(1024)
  • invitee — varchar(50) — NOT NULL
  • fee — varchar(50) — NOT NULL
  • dueDate — date
  • contents — text
  • registrationUrl — varchar(1024)
  • branchIds — text
  • isGuestInvited — tinyint(1) — NOT NULL
  • isBannerEvent — tinyint(1) — NOT NULL
  • isClosed — tinyint(1) — NOT NULL
  • managerId — int — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

CommunityNewsfeed

  • id — int
  • categoryId — int — NOT NULL
  • memberId — int — NOT NULL
  • contents — text
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

CommunityNewsfeedBlock

  • memberId — int — NOT NULL
  • entityType — enum — NOT NULL
  • entityId — int — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

CommunityNewsfeedCategory

  • id — int
  • code — varchar(50) — NOT NULL
  • name — varchar(50) — NOT NULL
  • description — text — NOT NULL
  • orderNo — smallint — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

CommunityNewsfeedReaction

  • id — int
  • communityNewsfeedId — int — NOT NULL
  • memberId — int — NOT NULL
  • isCanceled — tinyint(1) — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

CommunityNewsfeedReply

  • id — int
  • communityNewsfeedId — int — NOT NULL
  • memberId — int — NOT NULL
  • contents — text — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

Contract

  • id — int
  • memberGroupId — int — NOT NULL
  • branchId — int — NOT NULL
  • category — enum — NOT NULL
  • contractNo — varchar(14) — NOT NULL
  • startDate — date — NOT NULL
  • endDate — date — NOT NULL
  • isAutoExtension — tinyint(1) — NOT NULL
  • initialDay — tinyint — NOT NULL
  • standardReservationHours — smallint
  • reservationHours — smallint — NOT NULL
  • standardHeadcount — smallint
  • headcount — smallint — NOT NULL
  • additionalAgreement — text
  • deposit — bigint — NOT NULL
  • isExpendable — tinyint(1) — NOT NULL
  • standardPrice — bigint
  • price — bigint — NOT NULL
  • status — enum — NOT NULL
  • extendedDate — date
  • closeDate — date
  • isConfirmed — tinyint(1)
  • contractDate — date
  • closeRequestDate — date
  • closeReason — text
  • isRenewalVerified — tinyint(1) — NOT NULL
  • managerId — int — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL
  • additionalServiceType — enum
  • sfId — varchar(40)

ContractAssetRental

  • id — int
  • contractId — int — NOT NULL
  • orderNo — smallint — NOT NULL
  • date — date — NOT NULL
  • item — varchar(50) — NOT NULL
  • totalCount — smallint — NOT NULL
  • count — smallint — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

ContractChargeDetail

  • id — int
  • contractId — int — NOT NULL
  • taxIdentificationId — int
  • paymentType — enum — NOT NULL
  • paymentName — varchar(50)
  • paymentRelation — varchar(50)
  • billingType — enum — NOT NULL
  • billingName — varchar(50)
  • billingNo — varchar(14)
  • billingEmail — varchar(200)
  • paymentAccountBank — varchar(50)
  • paymentAccountNo — varchar(50)
  • refundAccountBank — varchar(50)
  • refundAccountNo — varchar(50)
  • refundAccountOwner — varchar(50)
  • updatedAt — timestamp — NOT NULL

ContractClosureChecklist

  • id — int
  • contractId — int — NOT NULL
  • category — enum — NOT NULL
  • item — varchar(50) — NOT NULL
  • isChecked — tinyint(1) — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

ContractMonthlyDiscount

  • id — int
  • contractId — int — NOT NULL
  • chargeMonth — char(7) — NOT NULL
  • discountPrice — bigint — NOT NULL
  • discountReason — varchar(255) — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

ContractSpace

  • id — int
  • contractId — int — NOT NULL
  • spaceId — int — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL
  • sfId — varchar(40)

Coupon

  • id — int
  • benefitId — int
  • deploymentId — int — NOT NULL
  • code — varchar(50) — NOT NULL
  • memberId — int
  • issuedAt — datetime
  • expiredAt — datetime
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

CouponDeployment

  • id — int
  • benefitId — int — NOT NULL — 베네핏 ID
  • type — enum — NOT NULL — 발행 유형 (link: URL, shareCode: 단일코드, privateCode: 개인화코드)
  • url — varchar(1024) — 쿠폰배포 url
  • code — varchar(50) — 공용 code
  • startAt — datetime — NOT NULL — 배포 시작시간
  • endAt — datetime — 배포 종료시간
  • managerId — int — 매니저 ID
  • isDeleted — tinyint(1) — NOT NULL — 삭제여부
  • deletedAt — timestamp
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

DepositRefundRequest

  • id — int
  • branchId — int — NOT NULL
  • title — varchar(255) — NOT NULL
  • isDepositExpendable — tinyint(1) — NOT NULL
  • dueDate — date — NOT NULL
  • status — enum — NOT NULL
  • managerId — int — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

DepositRefundRequestContract

  • id — int
  • depositRefundRequestId — int — NOT NULL
  • contractId — int — NOT NULL
  • chargePaymentId — int
  • refundPrice — bigint — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

EmailAuthentication

  • id — int
  • userId — int
  • email — varchar(200) — NOT NULL
  • authenticationCode — char(6) — NOT NULL
  • createdAt — timestamp — NOT NULL

Floor

  • id — int
  • branchId — int — NOT NULL
  • name — varchar(50) — NOT NULL
  • orderNo — smallint — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • sfId — varchar(40)

History

  • id — int
  • entityType — enum — NOT NULL
  • entityId — int — NOT NULL
  • memo — text — NOT NULL
  • managerId — int — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

IOTService

  • id — int
  • name — varchar(50) — NOT NULL
  • accessKey — char(36) — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

Manager

  • id — int
  • userId — int — NOT NULL
  • name — varchar(50) — NOT NULL
  • position — varchar(50) — NOT NULL
  • contactNo — varchar(16) — NOT NULL
  • email — varchar(200) — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL — 삭제여부
  • deletedAt — timestamp — NOT NULL — 삭제일시

MarketingAgreementLog

  • id — int
  • memberId — int — NOT NULL
  • isMarketingAgreed — tinyint(1) — NOT NULL
  • marketingUpdatedAt — timestamp
  • createdAt — timestamp — NOT NULL

Member

  • id — int
  • userId — int — NOT NULL
  • name — varchar(50) — NOT NULL
  • contactNo — varchar(16) — NOT NULL
  • birthday — date
  • occupation — varchar(50)
  • gender — enum
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL
  • sfId — varchar(40)

MemberCommunication

  • id — int
  • entityType — enum — NOT NULL
  • entityId — int — NOT NULL
  • memberCommunicationPurposeId — int — NOT NULL
  • actionTime — datetime — NOT NULL
  • channel — enum — NOT NULL
  • title — varchar(255) — NOT NULL
  • contents — text
  • managerId — int
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

MemberCommunicationPurpose

  • id — int
  • name — varchar(50) — NOT NULL
  • isMarketing — tinyint(1) — NOT NULL
  • isHistoryRequired — tinyint(1) — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

MemberGroup

  • id — int
  • category — enum — NOT NULL
  • name — varchar(50) — NOT NULL
  • registrationNo — varchar(14) — NOT NULL
  • subName — varchar(50) — NOT NULL
  • repName — varchar(255)
  • contactNo — varchar(16) — NOT NULL
  • email — varchar(200) — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • sfId — varchar(40)
  • vatType — enum

MemberGroupBillingPreset

  • id — int
  • memberGroupId — int — NOT NULL
  • name — varchar(50) — NOT NULL
  • billingType — enum — NOT NULL
  • billingName — varchar(50)
  • billingNo — varchar(14)
  • billingEmail — varchar(200)
  • isAlternative — tinyint(1) — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

MemberGroupInvitation

  • id — int
  • memberGroupId — int — NOT NULL
  • invitationCode — char(10) — NOT NULL
  • createdAt — timestamp — NOT NULL

MemberGroupNotification

  • id — int
  • memberGroupId — int — NOT NULL
  • title — varchar(255) — NOT NULL
  • contents — text — NOT NULL
  • isImportant — tinyint(1) — NOT NULL
  • managerId — int — NOT NULL
  • createdAt — timestamp — NOT NULL

MemberGroupPaymentPreset

  • id — int
  • memberGroupId — int — NOT NULL
  • name — varchar(50) — NOT NULL
  • paymentType — enum — NOT NULL
  • paymentName — varchar(50)
  • paymentRelation — varchar(50)
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

MemberQuoteMapping

  • id — int — 매핑 ID' primary ke
  • memberId — int — NOT NULL — 멤버 ID
  • quoteId — int — NOT NULL — 문구 ID

MemberRole

  • id — int
  • memberGroupId — int — NOT NULL
  • memberId — int — NOT NULL
  • role — enum — NOT NULL
  • nickname — varchar(50)
  • position — varchar(50)
  • email — varchar(200)
  • contactNo — varchar(16)
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL
  • sfId — varchar(40)

MemberSchedule

  • id — int
  • memberId — int — NOT NULL
  • entityType — enum — NOT NULL
  • entityId — int — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

MemberSetting

  • id — int
  • memberId — int — NOT NULL
  • isPushAgreed — tinyint(1) — NOT NULL
  • isMarketingAgreed — tinyint(1) — NOT NULL
  • marketingUpdatedAt — timestamp
  • updatedAt — timestamp — NOT NULL

Message

  • id — int
  • memberCommunicationId — int
  • messageJobId — int — NOT NULL
  • channel — enum — NOT NULL
  • receiverType — enum — NOT NULL
  • receiverId — int — NOT NULL
  • receiverName — varchar(50) — NOT NULL
  • receiverAddress — varchar(255) — NOT NULL
  • senderName — varchar(50)
  • senderAddress — varchar(255)
  • title — varchar(255) — NOT NULL
  • contents — text — NOT NULL
  • metaData — text — NOT NULL
  • state — enum — NOT NULL
  • failReason — text
  • referenceId — varchar(255)
  • completedAt — datetime
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

MessageJob

  • id — int
  • messageTypeId — int — NOT NULL
  • channel — enum — NOT NULL
  • receiverList — text — NOT NULL
  • receiverCount — int — NOT NULL
  • senderName — varchar(50)
  • senderAddress — varchar(255)
  • memberCommunicationPurposeId — int — NOT NULL
  • title — varchar(255) — NOT NULL
  • contents — text — NOT NULL
  • metaData — text — NOT NULL
  • reservedTime — datetime
  • state — enum — NOT NULL
  • managerId — int
  • registeredAt — datetime
  • queueingStartedAt — datetime
  • queueingCompletedAt — datetime
  • canceledAt — datetime
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

MessageSalesforce

  • id — int
  • state — enum — NOT NULL
  • bodyData — text — NOT NULL
  • tableName — varchar(50) — NOT NULL
  • referenceId — int — NOT NULL
  • referenceSfId — varchar(40)
  • version — int — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

MessageTemplate

  • id — int
  • messageTypeId — int — NOT NULL
  • channel — enum — NOT NULL
  • name — varchar(50) — NOT NULL
  • description — text — NOT NULL
  • memberCommunicationPurposeId — int
  • title — varchar(255) — NOT NULL
  • contents — text — NOT NULL
  • metaData — text — NOT NULL
  • managerId — int
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

MessageType

  • id — int
  • name — varchar(50) — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

Occupation

  • id — int
  • name — varchar(50) — NOT NULL
  • isUsed — tinyint(1) — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

Push

  • id — int
  • memberId — int — NOT NULL
  • pushToken — varchar(255) — NOT NULL
  • type — varchar(50)
  • title — varchar(255)
  • contents — text — NOT NULL
  • metaData — text — NOT NULL
  • queuedAt — timestamp
  • pushRequestedAt — timestamp
  • pushCompletedAt — timestamp
  • result — enum
  • failReason — text
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • key — enum
  • isRead — tinyint(1) — NOT NULL

Quote

  • id — int — 랜덤 문구 ID' primary ke
  • quote — varchar(30) — NOT NULL — 문구
  • branchId — int — NOT NULL — 지점 ID
  • memberId — int — NOT NULL — 작성자 ID
  • memberName — varchar(30) — NOT NULL — 작성자 이름
  • isVisible — tinyint(1) — NOT NULL — 노출 여부
  • status — enum — NOT NULL — 상태. requested: 응모, registered: 등록
  • managerId — int — 담당 매니저 ID
  • createdAt — timestamp — NOT NULL — 생성 시간
  • updatedAt — timestamp — NOT NULL — 최종 수정 시간
  • isDeleted — tinyint(1) — NOT NULL — 삭제 여부
  • deletedAt — timestamp — NOT NULL — 삭제 시간

Region

  • id — int
  • name — varchar(50) — NOT NULL
  • timeOffset — smallint — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • sfId — varchar(40)

Role

  • id — int
  • application — enum — NOT NULL
  • name — varchar(50) — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL

SealUsage

  • id — int
  • entityType — enum — NOT NULL
  • entityId — int — NOT NULL
  • sealDate — date — NOT NULL
  • usageCategory — varchar(255) — NOT NULL
  • usageDetail — text — NOT NULL
  • managerId — int — NOT NULL
  • isConfirmed — tinyint(1) — NOT NULL
  • confirmedAt — timestamp
  • confirmerId — int
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

Space

  • id — int
  • branchId — int — NOT NULL
  • floorId — int
  • spaceCategoryId — int — NOT NULL
  • name — varchar(50) — NOT NULL
  • capacity — smallint — NOT NULL
  • standardPrice — bigint — NOT NULL
  • area — decimal(11, 2) — NOT NULL
  • description — text
  • isReservable — tinyint(1) — NOT NULL
  • isUsed — tinyint(1) — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL
  • sfId — varchar(40)

SpaceCategory

  • id — int
  • serviceCategory — enum — NOT NULL
  • name — varchar(50) — NOT NULL
  • abbreviation — varchar(50) — NOT NULL
  • description — text
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • sfId — varchar(40)

SpaceReservation

  • id — int
  • spaceId — int — NOT NULL
  • memberGroupId — int
  • memberId — int
  • managerId — int
  • startTime — datetime — NOT NULL
  • endTime — datetime — NOT NULL
  • usedPoint — smallint — NOT NULL
  • status — enum — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

SpaceReservationPolicy

  • id — int
  • branchId — int
  • spaceCategoryId — int
  • spaceId — int
  • type — enum — NOT NULL
  • startTime — datetime
  • endTime — datetime
  • description — text — NOT NULL
  • policy — text — NOT NULL
  • errorMessage — text — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL

SpaceTag

  • id — int
  • spaceId — int — NOT NULL
  • tagId — int — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • isDeleted — tinyint(1) — NOT NULL
  • deletedAt — timestamp — NOT NULL

and 13 more tables