Zoopito

Tables (17)

Refund (Untitled)

  • Field

course (코스)

  • course_id (코스아이디) — bigint — Primary key — NOT NULL
  • created_date (생성일자) — datetime(6)
  • last_modified_date (수정일자) — datetime(6)
  • price (가격) — int
  • title (제목) — varchar(255)

lecture (강의)

  • lecture_id (강의아이디) — bigint — Primary key — NOT NULL
  • section_id (섹션아이디) — bigint — Foreign key → section.section_id — NOT NULL
  • created_date (생성일자) — datetime(6)
  • last_modified_date (수정일자) — datetime(6)
  • classify (분류) — varchar(20)
  • duration (영상시간(초)) — double
  • is_preview (미리보기 가능 여부) — bit
  • seq (순서) — int
  • sub_seq (부 순서) — int
  • thumbnail_url (썸네일 링크) — varchar(500)
  • tip (팁) — varchar(1000)
  • title (제목) — varchar(255)
  • video_url (비디오 링크) — varchar(255)

login_history (로그인 기록)

  • login_history_id (로그인기록아이디) — bigint — Primary key — NOT NULL
  • member_id (회원아이디) — bigint — Foreign key → member.member_id — NOT NULL
  • host (호스트) — varchar(255)
  • user_agent (유저에이전트) — varchar(255)
  • created_date (생성일자) — datetime(6)
  • last_modified_date (수정일자) — datetime(6)

member (회원)

  • member_id (회원아이디) — bigint — Primary key — NOT NULL
  • created_date (생성일자) — datetime(6)
  • last_modified_date (수정일자) — datetime(6)
  • age_policy_consent (14세이상입니다 약관 동의) — bit
  • birth_date (생년월일) — date
  • email (이메일) — varchar(100)
  • email_consent (이메일 수신동의 여부) — bit
  • is_lock (계정잠금 여부) — bit
  • last_login_date (마지막 로그인 날짜) — datetime(6)
  • nickname (닉네임) — varchar(20)
  • password (패스워드) — varchar(500)
  • password_last_modified_date (패스워드 수정일자) — datetime(6)
  • personal_info_policy_consent (개인정보 약관 동의) — bit
  • phone (핸드폰번호) — varchar(11)
  • phone_key (핸드폰 고유 키) — varchar(100)
  • profile_url (프로필 주소) — varchar(500)
  • remove_date (삭제날짜) — datetime(6)
  • remove_reason (삭제사유) — varchar(50)
  • role (권한) — varchar(10)
  • service_policy_consent (서비스 이용약관 동의) — bit
  • sms_consent (sms 수신 동의 여부) — bit
  • username (이름) — varchar(10)

metaverse (메타버스)

  • metaverse_id (메타버스아이디) — bigint — Primary key — NOT NULL
  • member_id (회원아이디) — bigint — Foreign key → member.member_id — NOT NULL
  • package_goods_id (패키지상품_아이디) — bigint — Foreign key → package_goods.package_goods_id — NOT NULL
  • created_date (생성일자) — datetime(6)
  • last_modified_date (수정일자) — datetime(6)
  • actual_days (실수강일) — int
  • email (이메일) — varchar(100)
  • service_consent_policy (서비스이용약관동의여부) — bit
  • phone (핸드폰번호) — varchar(11)
  • start_date (시작날짜) — datetime(6)
  • stop_date (끝난날짜) — datetime(6)
  • waiting_date (대기시작날짜) — datetime(6)
  • status (상태) — varchar(255)
  • metaverse_url (메타버스경로) — varchar(500)
  • personal_info_policy_consent (개인이용약관동의여부) — bit

my_lecture (나의강의)

  • my_lecture_id (나의강의아이디) — bigint — Primary key — NOT NULL
  • lecture_id (강의아이디) — bigint — Foreign key → lecture.lecture_id — NOT NULL
  • created_date (생성일자) — datetime(6)
  • last_modifieid_date (수정일자) — datetime(6)
  • duration (강의시간) — double
  • memo (메모) — varchar(1000)
  • progress (진행상태) — varchar(20)
  • is_writing (작문완료) — bit
  • member_id (회원아이디) — bigint — Foreign key → member.member_id — NOT NULL

my_writing (나의 작문)

  • my_writing_id (나의작문아이디) — bigint — Primary key — NOT NULL
  • writing_id (작문아이디2) — bigint — Foreign key → writing.writing_id — NOT NULL
  • member_id (회원아이디) — bigint — Foreign key → member.member_id — NOT NULL
  • sentence (작문) — varchar(255)
  • created_date (생성일자) — datetime(6)
  • last_modified_date (수정일자) — datetime(6)

notice (공지사항)

  • notice_id (공지사항아이디) — bigint — Primary key — NOT NULL
  • member_id (회원아이디) — bigint — Foreign key → member.member_id — NOT NULL
  • created_date (생성일자) — datetime(6)
  • last_modified_date (수정일자) — datetime(6)
  • content (내용) — varchar(3000)
  • title (제목) — varchar(255)

order (주문)

  • order_id (주문아이디) — bigint — Primary key — NOT NULL
  • member_id (회원아이디) — bigint — Foreign key → member.member_id — NOT NULL
  • package_goods_id (패키지상품_아이디) — bigint — Foreign key → package_goods.package_goods_id — NOT NULL
  • created_date (생성일자) — datetime(6)
  • last_modified_date (수정일자) — datetime(6)
  • actual_days (실수강일) — int
  • cost_price (정가) — int
  • discount (할인율) — int
  • discount_title (할인제목) — varchar(50)
  • effective_months (수강기간) — int
  • order_price (주문가격) — int
  • remain_period (남은기간) — int
  • repurchase_discount (재구매 할인율) — int
  • status (주문상태) — varchar(20)
  • title (제목) — varchar(255)
  • service_consent_policy (서비스 이용약관 동의 여부) — bit

package_goods (패키지상품)

  • package_goods_id (패키지상품_아이디) — bigint — Primary key — NOT NULL
  • created_date (생성일자) — datetime(6)
  • last_modifieid_date (수정일자) — datetime(6)
  • actual_days (실 수강일) — int
  • discount (할인율) — int
  • discount_title (할인제목) — varchar(50)
  • effective_months (수강기간) — int
  • is_lock (잠금여부) — bit
  • repurchase_discount (재구매할인율) — int
  • thumbnail_url (썸네일 링크) — varchar(500)
  • title (제목) — varchar(255)

package_goods_course (패키지상품_코스)

  • package_goods_course_id (패키지상품_코스_아이디) — bigint — Primary key — NOT NULL
  • package_goods_id (패키지상품_아이디) — bigint — Foreign key → package_goods.package_goods_id — NOT NULL
  • course_id (코스아이디) — bigint — Foreign key → course.course_id — NOT NULL
  • course_count (개수) — int
  • created_date (생성일자) — datetime(6)
  • last_modified_date (수정일자) — datetime(6)

payment (결제)

  • payment_id (결제아이디) — bigint — Primary key — NOT NULL
  • order_id (주문아이디) — bigint — Foreign key → order.order_id — NOT NULL
  • created_date (생성일자) — datetime(6)
  • last_modified_date (수정일자) — datetime(6)
  • amount (총금액) — int
  • failed_reason (실패사유) — varchar(50)
  • imp_uid (아임포트고유아이디) — varchar(50)
  • pay_method (결제메소드) — varchar(50)
  • pg_provider (pg사) — varchar(50)
  • pg_tid (결제내역아이디) — varchar(255)
  • refund_policy (환불정책) — varchar(50)
  • refuned_reason (환불사유) — varchar(50)
  • status (결제상태) — varchar(20)

qna (질문및답변)

  • qna_id (질문및답변아이디) — bigint — Primary key — NOT NULL
  • member_id (회원아이디) — bigint — Foreign key → member.member_id — NOT NULL
  • lecture_id (강의아이디) — bigint — Foreign key → lecture.lecture_id — NOT NULL
  • qna_id (질문및답변아이디2) — bigint — Foreign key → qna.qna_id — NOT NULL
  • created_date (생성일자) — datetime(6)
  • last_modified_date (수정일자) — datetime(6)
  • content (내용) — varchar(3000)
  • title (제목) — varchar(255)

reference_download (자료다운로드)

  • reference_download_id (자료다운로드아이디) — bigint — Primary key — NOT NULL
  • member_id (회원아이디) — bigint — Foreign key → member.member_id — NOT NULL
  • section_id (섹션아이디) — bigint — Foreign key → section.section_id — NOT NULL
  • created_date (생성일자) — datetime(6)
  • last_modified_date (수정일자) — datetime(6)
  • download_count (다운로드 횟수) — int

section (섹션)

  • section_id (섹션아이디) — bigint — Primary key — NOT NULL
  • course_id (코스아이디) — bigint — Foreign key → course.course_id — NOT NULL
  • created_date (생성일자) — datetime(6)
  • last_modified_date (수정일자) — datetime(6)
  • description (설명) — varchar(255)
  • pdf_original_name (pdf 이름) — varchar(50)
  • pdf_url (pdf링크) — varchar(500)
  • seq (순서) — int
  • title (제목) — varchar(255)

writing (작문)

  • writing_id (작문아이디) — bigint — Primary key — NOT NULL
  • lecture_id (강의아이디) — bigint — Foreign key → lecture.lecture_id — NOT NULL
  • sentence (작문) — varchar(255)
  • created_date (생성일자) — datetime(6)
  • last_modified_date (수정일자) — datetime(6)