123

Tables (9)

t_bedu_comm

  • COMM_NUM — int — Primary key — NOT NULL — 자유게시판 순번
  • TITLE — varchar(100) — NOT NULL — 제목
  • USER_ID — varchar(100) — NOT NULL — 글쓴이
  • CONTENT — varchar(100) — NOT NULL — 내용
  • COMM_LIKE_YN — int — 좋아요 수
  • COMM_CNT — int — 조회수
  • COMM_DATE — date — NOT NULL — 작성일자
  • REG_DATE — timestamp — NOT NULL — 등록일자
  • REG_ID — varchar(100) — NOT NULL — 등록 ID

t_bedu_lect

  • LECT_NUM — int — Primary key — NOT NULL — 강의고유번호
  • TITLE — varchar(100) — NOT NULL — 강의명
  • TEACHER — varchar(100) — NOT NULL — 강사이름
  • LECT_DESC — varchar(500) — NOT NULL — 강의 설명
  • THUMBNAIL — varchar(500) — NOT NULL — 썸네일
  • LECT_CNT — int — 조회수
  • LECT_LIKE_CNT — tinyint — 좋아요유무
  • LECT_PERIOD — int — NOT NULL — 수강기간
  • PRICE — int — NOT NULL — 수강료
  • CATEGORY — int — 미정
  • korCategory — varchar(45) — 미정
  • REG_DATE — timestamp — NOT NULL — 등록일자
  • REG_ID — varchar(100) — NOT NULL — 등록ID

t_bedu_lect_bot_cate

  • num — int — Primary key — NOT NULL
  • cate_code — int
  • cate_kor — varchar(100)
  • parent_code — int
  • parent_num — int

t_bedu_lect_dtl

  • LECT_DTL_NUM — int — Primary key — NOT NULL — 강의상세고유번호
  • LECT_DTL_TIME — int — NOT NULL — 강의상세시간
  • LECT_DTL_TITLE — varchar(400) — NOT NULL — 강의상세제목
  • LECT_NUM — int — NOT NULL — 강의순번
  • REG_DATE — timestamp — NOT NULL — 등록일자
  • REG_ID — varchar(100) — NOT NULL — 등록ID

t_bedu_lect_fild

  • LECT_FILD_NUM — int — Primary key — NOT NULL — 강의 분류 순번
  • TOP_CATE — int — NOT NULL — 대분류
  • TOP_CATE_KOR — varchar(100) — NOT NULL — 대분류 한글
  • MID_CATE — int — NOT NULL — 중분류
  • MID_CATE_KOR — varchar(100) — NOT NULL — 중분류 한글
  • BOT_CATE — int — NOT NULL — 소분류
  • BOT_CATE_KOR — varchar(100) — NOT NULL — 소분류 한글
  • LECT_NUM — int — NOT NULL — 강의 순번
  • REG_DATE — timestamp — NOT NULL — 등록일자
  • REG_ID — varchar(100) — NOT NULL — 등록ID

t_bedu_lect_like

  • LECT_LIKE_NUM — int — Primary key — NOT NULL
  • LECT_LIKE_USERID — varchar(45) — NOT NULL
  • LECT_LIKE_POSTID — varchar(45) — NOT NULL

t_bedu_lect_mid_cate

  • num — int — Primary key — NOT NULL
  • cate_code — int
  • cate_kor — varchar(100)
  • parent_num — int — NOT NULL
  • parent_code — int

t_bedu_lect_score

  • LECT_SCO_NUM — int — NOT NULL
  • LECT_SCO_USERID — varchar(45)
  • LECT_SCO_LECT_ID — varchar(45)
  • LECT_SCO_SCORE — varchar(45)

usercommunity

  • usercommunitynum — int — Primary key — NOT NULL
  • userid — varchar(100) — NOT NULL — 회원아이디
  • freeboardnum — int — 자유게시판 작성내역
  • qnaboardnum — int — 질문게시판 작성내역
  • reviewnum — int — 리뷰작성내역
  • commentnum — int — 댓글작성내역