MyNB 러닝세션
테이블 (10)
Ct_RunSession (러닝세션)
- rsIdx — int — 기본 키 — NOT NULL
- name — String
- type — String
- place — String
- sessionDate — datetime
- maxNum — int
- price — int
- applySDate — datetime
- applyEDate — datetime
- termsYn — char
- cancelYn — char
- cancelEDate — datetime
- useYn — char
- dispYn — char
- dispSDate — datetime
- dispEDate — datetime
- checkInCodeYn — char
- checkInCode — String
- checkInSDate — datetime
- checkInEDate — datetime
- caution — String
- listImg — varchar(300)
- bannerImg — varchar(300)
- description — String
- shareYn — char
- shareTitle — String
- shareImg — varchar(300)
- insId — int
- insDate — datetime
- uptId — int
- uptDate — datetime
Ct_RunSessionAttendance (출석)
- rsAttendanceIdx — int — 기본 키 — NOT NULL
- rsIdx — int
- custNo — String
- orderNo — String
- attendanceDate — yyyyMMdd
- checkInCode — String
- attendanceYn — char
- insId — String
- insDate — datetime
- uptId — String
- uptDate — datetime
Ct_RunSessionCustomer (참가자 정보)
- rsCustomerIdx — int — 기본 키 — NOT NULL
- rsIdx — int
- custNo — String
- orderNo — String
- custName — String
- webID — String
- brithday (custBirth) — String
- custSex (custGender) — String
- email — String
- cellNo — String
- addr1 — String
- addr2 — String
- zipCode — String
- ipAddr — String
- insDate — datetime
- uptDate — datetime
Ct_RunSessionCustomerTermsLog (참가자 약관 동의 내역)
- rsCustomerTermsLogIdx — int — 기본 키 — NOT NULL
- rsIdx — int
- custNo — String
- orderNo — String
- termsIdx — int
- termsTitle — String
- requireYn — char
- agreeYn — char
- insDate — datetime
- uptDate — datetime
Ct_RunSessionOrder (주문)
- orderNo — 기본 키 — NOT NULL
- rsIdx — int
- custNo — String
- price — int
- payAmt — int
- payType — String
- payMileage — int
- payCouponAmt — int
- cpSerialNo — String
- couponNo — int
- couponIssueNo — int
- couponName — String
- orderStatus — String
- commission — int
- tid — String
- orderDate — datetime
- payTotal — int
- discountAmt — int
- insId — int
- insDate — datetime
- uptId — int
- uptDate — datetime
Ct_RunSessionOrderCancel (주문취소)
- rsOrderCancelIdx — int — 기본 키 — NOT NULL
- orderNo — String — 기본 키 — NOT NULL
- custNo — String
- price — int
- payType — String
- payPgAmt — int
- payTotal — int
- payMileage — int
- payCouponAmt — int
- refundPgAmt — int
- refundMileage — int
- refundCouponAmt — int
- refundCouponNo — int
- refundCpSerialNo — String
- adminCancelYn — char
- cancelDate — datetime
- cancelStatus — String
- cancelReason — String
- refundTotal — int
- discountAmt — int
- insId — int
- insDate — datetime
- uptId — int
- uptDate — datetime
Ct_RunSessionStamp (출석스탬프)
- Key — 기본 키 — NOT NULL
Ct_RunSessionTerms (약관매핑)
- termsIdx — int — 기본 키 — NOT NULL
- rsIdx — int
- termsDtlIdx — int
- codeType
- sortOrder
- insId — int
- insDate — datetime
- uptId — int
- uptDate — datetime
Ct_RunSessionTermsDtl (약관상세)
- termsDtlIdx — int — 기본 키 — NOT NULL
- title — String
- contents — String
- requireYn — char
- insId — int
- insDate — datetime
- uptId — int
- uptDate — datetime
Ct_RunSessionTermsGroup (약관그룹)
- rsTermsGroupIdx — int — 기본 키 — NOT NULL
- name — String
- useYn — char
- insId — int
- insDate — datetime
- uptId — int
- uptDate — datetime