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