tuding2.0
Tables (43)
AvailableLectures
- id — AI — Primary key — NOT NULL
- lecturesId — AI — NOT NULL — 쿠폰의 사용을 제한하거나 허용할 강의
- couponId — AI — NOT NULL
- createdAt — VARCHAR(255)
BanWord
- id — AI — Primary key — NOT NULL
- word — varchar(255) — NOT NULL
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
- order — int — NOT NULL
Bank
- id — AI — Primary key — NOT NULL
- bankCode — string
- koreanName — string
Banner
- id — AI — Primary key — NOT NULL
- type — enum — NOT NULL
- status — enum — NOT NULL
- name — string — NOT NULL
- order — int — 메인 배너에만 순서가 부여됨
- mobileImageUrl — string — 모바일 환경에서 보일 배너의 이미지 주소
- mobileImageName — string — 업로드 된 배너의 파일 이름
- mobileLink — string — 모바일 환경에서 노출되는 배너를 눌렀을 때 이동할 페이지의 링크
- pcImageUrl — string — NOT NULL
- pcImageName — string — NOT NULL
- pcLink — string — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- authorCrew — JSON — NOT NULL
- crewId — AI
CommunityComments
- id — AI — Primary key — NOT NULL
- content — varchar(1000) — NOT NULL
- parentCommentId — varchar(255)
- depth — integer
- Field — VARCHAR(255)
- postId — AI — NOT NULL
- userId — AI — NOT NULL — Auto Increment ? 랜덤 문자열 ? UUID ?
- Field3 — VARCHAR(255)
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
- deletedAt — date
- noticeId — AI — NOT NULL
CommunityPostCategories
- id — int — Primary key — NOT NULL
- categoryName — string — NOT NULL — 시황, 매매일지, 수익인증, 매매법 질문, 자유 게시판
- categoryType — enum — NOT NULL
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
CommunityPosts
- id — int — Primary key — NOT NULL
- title — string — NOT NULL
- content — json — NOT NULL
- viewCount — unsigned — NOT NULL
- authorId — AI — NOT NULL — Auto Increment ? 랜덤 문자열 ? UUID ?
- categoryId — AI — NOT NULL
- recommendedPostOrder — int
- isRecommended — boolean — NOT NULL
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
- deletedAt — boolean
ConditionalCoupon
- id — AI — Primary key — NOT NULL
- couponId — AI — NOT NULL
- triggerEvent — enum — NOT NULL
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
Coupon
- id — AI — Primary key — NOT NULL
- couponNumber — string — NOT NULL
- kind — enum — NOT NULL
- issueStatus — enum — NOT NULL
- issueAmount — int
- Field — boolean — NOT NULL
- name — string — NOT NULL
- description — string — NOT NULL
- discountRatio — int — NOT NULL
- availableDate — date — NOT NULL
- validityDays — int — NOT NULL
- isLecturesAll — boolean — NOT NULL
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
Crew
- id — AI — Primary key — NOT NULL
- email — string — Primary key — NOT NULL
- status — enum — NOT NULL
- password — string — NOT NULL
- name — string — NOT NULL
- phone — string — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- firstPaasswordChanged — boolean — NOT NULL
- role — enum — NOT NULL
FAQ
- id — enum — Primary key — NOT NULL
- categoryId — varchar(255) — Foreign key → FaqCategories.id — NOT NULL
- title — varchar(255)
- content — TEXT
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
FaqCategories
- id — varchar(255) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- iconUrl — varchar(1000)
- description — varchar(1000)
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
FavoriteLectures
- id — AI — Primary key — NOT NULL
- lectureId — AI — NOT NULL
- userId — AI — NOT NULL — Auto Increment ? 랜덤 문자열 ? UUID ?
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
LectureCategories
- id — AI — Primary key — NOT NULL
- name — string — NOT NULL
- isDisplayed — boolean — NOT NULL
- order — int — NOT NULL
- depth — int — NOT NULL
- parentCategoryId — AI
- isDefault — boolean — NOT NULL
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
LectureChapters
- id — AI — Primary key — NOT NULL
- lectureId — AI — Foreign key → Lectures.id — NOT NULL
- name — string — NOT NULL
- order — int — NOT NULL
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
LectureKeywords
- id — AI — Primary key — NOT NULL
- lectureId — AI — NOT NULL
- string — varchar(255) — NOT NULL
LectureParts
- id — AI — Primary key — NOT NULL
- lectureChapterId — AI — Foreign key → LectureChapters.id — NOT NULL
- name — varchar(255) — NOT NULL
- order — int — NOT NULL
Lectures
- id — AI — Primary key — NOT NULL
- description — string — NOT NULL
- buyerCount — int — NOT NULL
- discountAmount — int — NOT NULL
- likeCount — int — NOT NULL
- viewCount — int — NOT NULL
- title — string — NOT NULL
- noticce — text
- price — int — NOT NULL
- coursePeriod — int — 강의 자체의 수강 가능 기간. 이 컬럼을 기준으로 구매일로부터 언제까지 수강 가능한지 결정 개월수로 표기, null 일 경우 무제한 수강,
- int — int — NOT NULL
- thumbnailImg — string
- averageStarScore — decimal(4, 2)
- totalDuration — int — NOT NULL
- order — int
- lectureCategoryId — varchar(255) — NOT NULL
- teacherId — varchar(255)
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
- deletedAt — date
Menu
- id — AI — Primary key — NOT NULL
- menuName — string — NOT NULL
- menuCode — AI — NOT NULL
- menuOrder — int — NOT NULL
- menuUrl — string — NOT NULL
- quickMenuStatus — enum('ON', 'OFF'
Notices
- id — AI — Primary key — NOT NULL
- title — varchar(255)
- content — varchar(255)
- isCommentAllowed — boolean — NOT NULL
- fileLink — VARCHAR(255)
- isFixed — boolean — NOT NULL
- viewCount — int — NOT NULL
- crewId — AI — NOT NULL
- categoryId — AI — NOT NULL
- order — int
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
- deletedAt — date
Order
- id — AI — Primary key — NOT NULL
- orderId — string — NOT NULL
- originalPrice — int — NOT NULL
- discountAmount — int — NOT NULL — 관리자 메뉴 > 강의 관리 > 할인액
- couponDiscoumtAmount — int — 사용자가 쿠폰을 사용해 할인받은 금액 (현재 투딩에서는 100% 할인액만 적용 중)
- status — enum — NOT NULL
- userId — AI — Auto Increment ? 랜덤 문자열 ? UUID ?
- cancelType — enum
- cancelRequestedAt — date
- cancelConfirmedAt — date
- refundRequestedAt — date
- refundConfirmedAt — date
- refundDeniedAt — date
- refundConfirmCrewId — AI — NOT NULL
- refundDenyCrewId — AI — NOT NULL
- refundAmount — int
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
- deletedAt — date — NOT NULL
OrderItem
- orderId — AI — NOT NULL
- lectureId — AI — NOT NULL
- quantity — int — NOT NULL
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
Otp
- phone — varchar(255) — NOT NULL
- code — integer — NOT NULL
- expiresAt — datetime
- retry — integer — NOT NULL
- isAuthenticated — boolean — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
ReferralCode
- id — AI — Primary key — NOT NULL
- code — string — NOT NULL
- ownerId — AI — NOT NULL — Auto Increment ? 랜덤 문자열 ? UUID ?
- isActive — boolean — NOT NULL
- createdAt — Date — NOT NULL
- updatedAt — Date — NOT NULL
ReferralRelationshipCode
- id — AI — Primary key — NOT NULL
- referralCodeId — AI — NOT NULL
- referrerUserId — AI — NOT NULL — Auto Increment ? 랜덤 문자열 ? UUID ?
- referredUserId — AI — NOT NULL — Auto Increment ? 랜덤 문자열 ? UUID ?
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
Refund
- id — AI — Primary key — NOT NULL
- paymentId — AI — NOT NULL
- cancelAmount — int — NOT NULL
- canceledAt — string — NOT NULL
- cancelStatus — string — NOT NULL
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
- orderId — VARCHAR(255) — NOT NULL
RefundReceiveAccount
- id — AI — Primary key — NOT NULL
- virtualAccountId — AI — NOT NULL
- accountNumber — string — NOT NULL
- bankId — AI — NOT NULL
- holderName — string — NOT NULL
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
Reviews
- id — AI — Primary key — NOT NULL
- content — varchar(1000) — NOT NULL — 강의당 1회에 한해 무료쿠폰 발급
- starScore — decimal(3, 1) — NOT NULL
- userId — AI — NOT NULL — Auto Increment ? 랜덤 문자열 ? UUID ?
- lectureId — AI — NOT NULL
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
- deletedAt — date
Teacher
- id — string — Primary key — NOT NULL
- name — string — NOT NULL
- email — string — NOT NULL
- phone — string — NOT NULL
- thumbnail — string — NOT NULL
- resume — text — NOT NULL
- greeting — string — NOT NULL
- careerYears — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
TempOrder
- id — AI — Primary key — NOT NULL
- originalPrice — int — NOT NULL
- discountAmount — Int — NOT NULL
- couponDiscountAmount — Int
- finalPrice — int — NOT NULL
- orderId — string — NOT NULL
- lectureId — int
- userCouponIds — int
- status — enum — NOT NULL
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
Terms
- id — varchar(255) — Primary key — NOT NULL
- userId — unsigned — NOT NULL — Auto Increment ? 랜덤 문자열 ? UUID ?
- isEmailConsent — boolean — NOT NULL
- isSmsConsent — boolean — NOT NULL
- emailConsentDate — date
- smsConsentDate — date
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
UserCoupons
- userCouponId — AI — Primary key — NOT NULL
- userId — AI — NOT NULL — Auto Increment ? 랜덤 문자열 ? UUID ?
- couponId — AI — NOT NULL
- orderId — AI
- couponStatus — enum — NOT NULL
- usedAt — date
- createdAt — date — NOT NULL
- expireAt — date — NOT NULL
- referralRelationshipId — AI
UserCourses
- id — AI — Primary key — NOT NULL
- userId — AI — NOT NULL — Auto Increment ? 랜덤 문자열 ? UUID ?
- lectureId — AI — NOT NULL
- progress — int — NOT NULL
- expirationDate — date
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
- lastWatchedPartId — int
- orderId — AI — NOT NULL
UserLevel
- id — AI — Primary key — NOT NULL
- levelName — varchar(255) — NOT NULL
- level — int — NOT NULL
- postCounts — int
- commentCounts — int
- celebrateText — string
- fileLinks — json
- isAutoLevelUp — boolean — NOT NULL
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
UserManage
- id — AI — Primary key — NOT NULL
- userId — AI — NOT NULL — Auto Increment ? 랜덤 문자열 ? UUID ?
- tier — enum — NOT NULL
- text — string
- textAt — datetime
- type — enum
- userManageCode — string
- toOpptyAt — datetime
- toOrderAt — datetime
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
Users
- id — AI — Primary key — NOT NULL — Auto Increment ? 랜덤 문자열 ? UUID ?
- email — string — NOT NULL
- newsLetterEmail — varchar(1000)
- password — string — NOT NULL
- phoneNumber — varchar(255) — NOT NULL — 대쉬를 포함하지 않은 휴대전화번호 문자열 11자리 / 11자리 이상은 입력 불가능
- userName — varchar(255) — NOT NULL — 이름 - 10자 이내 한국어로 구성된 문자열
- oAuthProvider — enum — NOT NULL
- naverId — string
- kakaoId — string
- profileImage — string
- nickname — string — NOT NULL — - 한영 숫자 조합 - 최대 10자 - 닉네임 중복 사용 불가 - 공백 사용 불가 - 이모티콘 , 특수문자 사용불가
- birthyear — string
- birthday — string
- gender — FEMALE
- nicknameChangeCount — int — NOT NULL
- nicknameUpdatedAt — date
- refreshToken — string
- isEnabled — boolean — NOT NULL
- inviteLink — string
- role — enum — NOT NULL
- userLastLevel — int — NOT NULL
- userLevelId — int
- levelUpdatedAt — date
- createdAt — date
- updatedAt — date
- deletedAt — date — 탈퇴 후 15일 경과 전까지 재가입 방지
- alert — boolean — NOT NULL
- withdrwalMemo — Json
VideoLearnProgress
- id — AI — Primary key — NOT NULL
- videoId — AI — NOT NULL
- lastWatchDuration — int — NOT NULL
- createdAt — VARCHAR(255) — NOT NULL
- updatedAt — date — NOT NULL
- userCourseId — AI — NOT NULL
- Field — VARCHAR(255)
Videos
- id — AI — Primary key — NOT NULL
- mediaContentKey — varchar(255) — Primary key — NOT NULL
- uploadFileKey — varchar(255) — Primary key — NOT NULL
- lecturePartId — AI — Foreign key → LectureParts.id — NOT NULL
- isPreview — boolean — NOT NULL
- isOrientation — boolean — NOT NULL
- duration — int — NOT NULL
- name — varchar(255) — NOT NULL
- createdAt — Date — NOT NULL
- updatedAt — Date — NOT NULL
VirtualAccount
- id — AI — Primary key — NOT NULL
- accountType — string
- accountNumber — string — NOT NULL
- bankId — AI — NOT NULL
- dueDate — date — NOT NULL
- expired — boolean — NOT NULL
- settlementStatus — enum
- refundStatus — enum — NOT NULL
- paymentId — AI — NOT NULL
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
payment
- id — AI — Primary key — NOT NULL
- createdId — bitint — Primary key — NOT NULL
- orderId — AI — Foreign key → Order.id — NOT NULL
- paymentMethod — enum — NOT NULL
- easyPayProvider — enum — NOT NULL
- paymentStatus — enum — NOT NULL
- paymentAmount — int — NOT NULL
- transactionId — string
- paidAt — date
- receiptUrl — string
- createdAt — date — NOT NULL
- updatedAt — date — NOT NULL
tradeRecord
- id — int — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- tradeDate — date
- enterPrice — varchar(255)
- leverageRatio — varchar(255)
- targetPrice — varchar(255)
- profitLossPrice — varchar(255)
- profitLossRatio — varchar(255)
- profit — varchar(255)
- profitRatio — varchar(255)
- communityPostId — int — NOT NULL