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