Share Learning

테이블 (3)

나의 학습 (tbl_bbs)

  • idx — int — 기본 키 — NOT NULL
  • member_id — varchar
  • title — varchar
  • content — varchar
  • reg_date — datetime
  • modify_date — datetime
  • good_count — int
  • view_status — varchar
  • start_view — datetime
  • end_view — datetime
  • field — varchar
  • tag — varchar
  • save_file — text

학습 공유 (tbl_share)

  • share_idx — int — 기본 키 — NOT NULL
  • board_idx — int
  • member_id — varchar
  • share_id — varchar
  • share_date — datetime

회원 (tbl_member)

  • member_id — varchar
  • name — varchar
  • pwd — varchar
  • phone — varchar
  • user_status — char
  • reg_date — timestamp
  • leave_date — datetime
  • pwd_change_date — datetime
  • email — varchar
  • last_login — datetime
  • login_fail_count — int
  • id_locked — int