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