ff

Tables (20)

ASK

  • DSCSN_SN — integer — NOT NULL
  • USER_SEQ — integer — NOT NULL
  • DSCSN_TTL — character — NOT NULL
  • DSCSN_CN — character — NOT NULL
  • DSCSN_REG_DT — character(30) — NOT NULL
  • DSCNC_ANS_SEQ — integer
  • DSCSN_ANS_CN — character
  • DSCSN_ANS_DT — character(30)
  • DSCSN_ANS_YN — character(1) — NOT NULL

ATTENDANCE_CHECK

  • LCTR_NO — integer — NOT NULL
  • LCTR_ID — character — NOT NULL
  • USER_SEQ — integer — NOT NULL
  • ATT_STATUS — integer

CLASSROOM

  • ROOM_NAME — character

CLASS_BOOKMARK

  • CONTS_ID — character — NOT NULL
  • CONTS_CHPTIME — integer — NOT NULL — (타임라인)
  • CONTS_CHPTTL — character — (타임라인)
  • CHP_SN — integer

CLASS_SCHEDULE

  • LCTR_NO — integer — NOT NULL
  • LCTR_ID — character — NOT NULL
  • CONTS_ID — character — NOT NULL
  • USER_SEQ — integer — NOT NULL
  • CONTS_FINAL — integer
  • CONTS_MAX — integer
  • CONTS_PRGRT — integer

COMM

  • GROUP_CD — integer — NOT NULL
  • CD — integer — NOT NULL
  • CD_NM — character

COURSE_REGISTRATION

  • LCTR_ID — character — NOT NULL
  • USER_SEQ — integer — NOT NULL
  • APLY_DATE — character(10)
  • REG_STATE — character — 수강신청
  • PAY_DATE — character(10)
  • PAY_STATE — character
  • REFUND_DATE — character(10)
  • ATNDC_SCR — integer
  • ASMT_SCR — integer
  • TOTAL_SCR — integer
  • LCTR_SCHD_RT — integer

FILE_GROUP

  • FILE_GROUP — integer — NOT NULL
  • FILE_SEQ — integer — NOT NULL
  • IDNTF_NO — character — 서버파일명
  • FILE_NM — character — NOT NULL
  • FILE_EXTN_NM — character — NOT NULL
  • FILE_SZ — integer — NOT NULL
  • FILE_PATH_NM — character — NOT NULL

GRADE

  • LCTR_ID — character — NOT NULL
  • USER_SEQ — integer — NOT NULL
  • ATNDC_SCR — integer
  • ASMT_SCR — integer
  • LAST_SCR — integer
  • FNSH_YN — character(1)

HOMEWORK

  • ASMT_NO — integer — NOT NULL
  • LCTR_ID — character — NOT NULL
  • ASMT_NM — character
  • ASMT_CN — character
  • SBMSN_BGNG_YMD — character(10) — NOT NULL
  • SBMSN_END_YMD — character(10)
  • FILE_GROUP — integer

HOMEWORK_SUBMISSION

  • USER_SEQ — integer — NOT NULL
  • ASMT_NO — integer — NOT NULL
  • ASMT_SCR — integer
  • SBMSN_YN — character(1)
  • SBMSN_YMD — character(10)
  • FILE_GROUP — integer

LECTURE

  • LCTR_ID — character — NOT NULL
  • USER_SEQ — integer — NOT NULL
  • LCTR_NAME — character
  • LCTR_COUNT — integer
  • RCRT_DATE — character(10) — 모집기간은
  • LCTR_COST — integer
  • EVAL_CRITERIA — character — 교수가
  • LCTR_START_DATE — character(10)
  • LCTR_CNTSCHD — integer
  • FILE_GROUP — integer — NOT NULL
  • LCTR_SCHD — character
  • ONOFF — integer
  • LCTR_CATEGORY — integer
  • LCTR_STATE — integer
  • REGISTER_COUNT — integer

LECTURE_VIDEO

  • CONTS_ID — character — NOT NULL
  • VDO_FILE_NM — character — NOT NULL
  • VDO_URL_ADDR — character — NOT NULL
  • VIEWING_PERIOD — character — NOT NULL
  • VDO_LENGTH — integer — NOT NULL
  • LCTR_NO — integer
  • FILE_GROUP — integer — NOT NULL
  • LCTR_ID — character

LOGIN_INFO

  • USER_SEQ — integer — NOT NULL
  • USER_ID — character — NOT NULL
  • PASSWORD — character — NOT NULL
  • PW_ERR_NUM — integer
  • LAST_LOGIN — character(10)
  • USER_STATUS — integer

NOTE

  • NOTE_SN — integer — NOT NULL
  • BFR_NOTE_SN — integer
  • SNDPTY_SEQ — integer — NOT NULL
  • RCVR_SEQ — integer — NOT NULL
  • DSPTCH_DT — character — NOT NULL
  • RCPTN_DT — character
  • NOTE_TTL — character — NOT NULL
  • NOTE_CN — character — NOT NULL
  • SNDPTY_NOTE_YN — character(1) — NOT NULL
  • RCVR_NOTE_YN — character(1) — NOT NULL

NOTICE

  • NTC_MTTR_SN — integer — NOT NULL
  • USER_SEQ — integer — NOT NULL
  • NTC_MTTR_GUBUN — character — NOT NULL — 일정한
  • NTC_MTTR_TTL — character — NOT NULL
  • NTC_MTTR_CN — character — NOT NULL
  • NTC_MTTR_DT — character — NOT NULL
  • NTC_MTTR_YN — character(1) — NOT NULL — 여러
  • LCTR_ID — character
  • FILE_GROUP — integer

SYLLABUS

  • LCTR_NO — integer — NOT NULL
  • LCTR_ID — character — NOT NULL
  • CONTS_ID — character
  • LCTR_OTLN — character

TIMETABLE

  • LCTR_ID — character — NOT NULL
  • LCTR_ROOM — character — NOT NULL
  • LCTR_HR — character

USER_INFO

  • USER_SEQ — integer — NOT NULL
  • USER_ID — character — NOT NULL
  • USER_NAME — character — NOT NULL
  • BIRTH — character(10)
  • PROFILE_NAME — character
  • PROFILE_ADDR — character
  • ADDRESS — character — NOT NULL
  • EMAIL — character — NOT NULL
  • PHONE_NUM — character — NOT NULL
  • DEL_STATE — character(1)
  • FILE_GROUP — integer
  • ADDR_DETAIL — character

Z_TIMETABLE

  • LCTR_ID — character
  • LCTR_ROOM — character
  • LCTR_HR — character