BTA2_user

Tables (9)

ARTICLES (게시글)

  • ARTICLES_SEQ (id) — Primary key — NOT NULL
  • 글 제목 (title)
  • 글 내용 (contents)
  • 글 등록일 (regdate)
  • 글 블러처리 (blur)
  • USER_SEQ (user_id) — Foreign key → USERS_ARTICLES.USER_SEQ — NOT NULL

EXAMS (시험)

  • EXAM_SEQ (id) — Primary key — NOT NULL
  • 시험 제목 (title)
  • 시험 콘텐츠 (content)
  • lecture seq (lecture_id) — Foreign key → LECTURES.LECTURE_SEQ — NOT NULL

GRADINGS (시험성적)

  • GRADING_SEQ (id) — Primary key — NOT NULL
  • 시험성적 (score)
  • 시험성적등록일 (regdate)
  • exam id (exam_id) — Foreign key → EXAMS.EXAM_SEQ — NOT NULL
  • USER_SEQ (id2) — Foreign key → USERS_LECTURE.USER_SEQ — NOT NULL

LEARNING (학생 수강 정보)

  • LEARNING_SEQ (id) — Primary key — NOT NULL
  • 수강한 USER ID (user_id)
  • 별점 (rate)
  • lecture seq (lecture_id) — Foreign key → LECTURES.LECTURE_SEQ — NOT NULL
  • USER_SEQ (id2) — Foreign key → USERS_LECTURE.USER_SEQ — NOT NULL

LECTURES (강의)

  • LECTURE_SEQ (id) — Primary key — NOT NULL
  • 강의 제목 (title)
  • 강의 컨텐츠 (content)
  • 업로드 날짜 (regdate)
  • 강의노출 (blur)
  • 강사 USER ID (lecture_id) — Foreign key → USERS_LECTURE.USER_SEQ — NOT NULL

Replies (댓글)

  • REPLY_SEQ (id) — Primary key — NOT NULL
  • 댓글 내용 (contents)
  • ARTICLES_ID (article_id) — Foreign key → ARTICLES.ARTICLES_SEQ — NOT NULL
  • USER_SEQ (user_id) — Foreign key → USERS_ARTICLES.USER_SEQ — NOT NULL
  • 등록일짜 (regdate)
  • 블러처리유무 (blur)

USERS (회원)

  • USER_SEQ (id) — Primary key — NOT NULL
  • 유저 아이디 (username)
  • 비밀번호 (password)
  • 역할 (role)

USERS_ARTICLES (커뮤니티 회원정보)

  • USER_SEQ (id) — Primary key — NOT NULL
  • 유저 아이디 (username)
  • 비밀번호 (password)
  • 역할 (role)

USERS_LECTURE (강의 회원정보)

  • USER_SEQ (id) — Primary key — NOT NULL
  • 유저 아이디 (username)
  • 비밀번호 (password)
  • 역할 (role)