Zoopito
Tables (16)
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)