merry

Tables (11)

Copy Of Untitled (data)

  • Key (data_idx) — Primary key — NOT NULL
  • Field (data_title)
  • Field (data_content)
  • Field (data_org_file_name)
  • Field2 (data_save_file_name)
  • Field (data_type)
  • Field (data_reg_date)
  • Field (data_modify_date)
  • Field (member_idx)

Copy Of Untitled2 (qna)

  • Key (qna_idx) — Primary key — NOT NULL
  • Field (qna_title)
  • Field (qna_content)
  • Field (qna_reg_date)
  • Field (qna_modify_date)
  • Field (member_idx)
  • Field (qna_answer)
  • Field (qna_answer_yn)
  • Field (qna_answer_reg_date)
  • Field (qna_answer_modify_date)

Copy Of Untitled3 (board_reply)

  • Key (reply_idx) — Primary key — NOT NULL
  • Field (reply_comment)
  • Field (reply_writer)
  • Field (reply_reg_date)
  • Field (reply_modify_date)
  • Field (board_idx)

Untitled (lecture)

  • Key (lec_idx) — Primary key — NOT NULL
  • Field (lec_title)
  • Field (lec_content)
  • Field (lec_state)
  • Field (lec_reg_date)
  • Field (lec_modify_date)
  • Field (member_idx)
  • Field (lec_img)

Untitled (chapter)

  • Key (chap_idx) — Primary key — NOT NULL
  • Field (chap_title)
  • Field (chap_video)
  • Field (chap_time)
  • Field (lec_idx)

Untitled (lecture_review)

  • Key (review_idx) — Primary key — NOT NULL
  • Field (lec_idx)
  • Field (member_idx)
  • Field (comment)
  • Field (review_reg_date)
  • Field (review_modify_date)

Untitled (member_lecture)

  • Key (ml_idx) — Primary key — NOT NULL
  • Field (member_idx)
  • Field (lec_idx)
  • Field (status)

Untitled (notice)

  • Key (notice_idx) — Primary key — NOT NULL
  • Field (notice_title)
  • Field (notice_content)
  • Field (notice_type)
  • Field (notice_reg_date)
  • Field (notice_modify_date)
  • Field (member_idx)

Untitled (board)

  • Key (board_idx) — Primary key — NOT NULL
  • Field (board_title)
  • Field (board_content)
  • Field (board_writer)
  • Field (board_reg_date)
  • Field (board_modify_date)
  • Field (member_idx)

Untitled (teacher)

  • Key (teacher_idx) — Primary key — NOT NULL
  • Field (member_idx)
  • Field (subject)

member

  • Key (member_idx) — Primary key — NOT NULL
  • Field (member_id)
  • Field (pwd)
  • Field (name)
  • Field (email)
  • Field (birthday)
  • Field (addr)
  • Field (addr_detail)
  • Field (zipcode)
  • Field (phone)
  • Field (reg_date)
  • Field (modify_date)
  • Field (member_type)
  • Field (member_state)