Mentoring

Tables (19)

T_ADMIN

  • ADMIN_ID — PK — Primary key — NOT NULL
  • CREATED_DATE — timestamp
  • CREATED_BY — varchar(100)
  • MODIFIED_DATE — timestamp
  • MODIFIED_BY — varchar(100)
  • IS_DELETED — varchar(1)
  • Field (ADMIN_NAME)
  • Field (PHONE) — varchar(8)
  • Field (EMAIL) — varchar(100)
  • Field (USE_YN)

T_CONSULT_QNA (T_COUNSEL_QNA)

  • ID — PK — Primary key — NOT NULL
  • MENTOR_ID — varchar(100)
  • STUDENT_ID — varchar(100)
  • TITLE — varchar(500)
  • CONTENT — TEXT
  • ANSWERED_DATE — varachar(100)

T_COUNSEL

  • ID — varchar(100) — Primary key — NOT NULL
  • COUNSEL_DATE — varchar(100)
  • MENTOR_ID — varchar(100)
  • SCHOOL_ID — varchar(100)
  • COUNSEL_TYPE — varchar(100)
  • MAX_STUDENT — Integer
  • IS_ENABLE — varchar(1)
  • START_TIME — varchar(100)
  • END_TIME — varchar(100)
  • STATUS — varchar(2)
  • CREATED_DATE — timestamp
  • CREATED_BY — varchar(100)
  • MODIFIED_DATE — timestamp
  • MODIFIED_BY — varchar(100)
  • IS_DELETED — varchar(1)

T_COUNSEL_APPLY

  • ID — varchar(100) — Primary key — NOT NULL
  • COUNSEL_ID — FK — Foreign key → T_COUNSEL.ID — NOT NULL
  • COUNSEL_DATE — varchar(100)
  • CREATED_DATE — timestamp
  • CREATED_BY — varchar(100)
  • MODIFIED_DATE — timestamp
  • MODIFIED_BY — varchar(100)
  • IS_DELETED — varchar(1)
  • STUDENT_ID — varchar(100)
  • MENTOR_ID — varchar(100)
  • START_TIME — varchar(100)
  • END_TIME — varchar(100)
  • Field (STATUS) — varchar(2)

T_MENTOR

  • MENTOR_ID — PK — Primary key — NOT NULL
  • LOGIN_ID — UK
  • LOGIN_PWD — varchar(100)
  • MENTOR_NAME — varchar(200)
  • GENDER — varchar(2)
  • PHONE — varchar(8)
  • EMAIL — varchar(100)
  • START_PERIOD — varchar(20)
  • END_PERIOD — varchar(20)
  • COMPANY_NAME — varchar(100)
  • COMPANY_TYPE — varchar(100)
  • WORKING_SEGMENT (WORK_SEGMENT) — varchar(10)
  • DEPT_NAME — varchar(100)
  • RANK — varchar(50)
  • GRAD_UNIV — varchar(100)
  • MAJOR_CAREER — TEXT
  • INTRO — TEXT
  • MENTOR_PLAN — TEXT
  • BANK_ACC — varchar(200)
  • CERT_EMPLOY — file
  • INQUIRY — TEXT
  • PROFILE_IMG (PROF_IMG) — varchar(100)
  • CREATED_DATE — timestamp
  • CREATED_BY — varchar(100)
  • MODIFIED_DATE — timestamp
  • MODIFIED_BY — varchar(100)
  • IS_DELETED — varchar(1)
  • FAIL_COUNT (FAIL_CNT) — Integer
  • WITHDRAW_YN — varchar(1)
  • WITHDRAW_REASON — TEXT
  • WITHDRAW_DATE — timestamp
  • PWD_MODIFIED_DATE (PWD_MOD_DATE) — varchar(100)
  • LAST_LOGIN_DATE — timestamp

T_MENTOR_REQUEST

  • ID — integer — Primary key — NOT NULL
  • MENTOR_ID — FK — Foreign key → T_MENTOR.MENTOR_ID — NOT NULL
  • SCHOOL_ID — FK — Foreign key → T_SCHOOL.SCHOOL_ID — NOT NULL
  • SCHOOL_NAME
  • DEPT_NAME — varchar(100)
  • CONTACT_PERSON
  • CONTACT_PHONE
  • CONTACT_EMAIL

T_REVIEW

  • ID — PK — Primary key — NOT NULL
  • MENTOR_ID — FK — Foreign key → T_MENTOR.MENTOR_ID — NOT NULL
  • CREATED_DATE — timestamp
  • CREATED_BY — varchar(100)
  • MODIFIED_DATE — timestamp
  • MODIFIED_BY — varchar(100)
  • IS_DELETED — varchar(1)
  • REV_POINT (REVIEW_POINT) — long(16)
  • STUDENT_ID — varchar(100)
  • COUNSEL_ID — varchar(50)

T_SCHOOL

  • SCHOOL_ID — PK — Primary key — NOT NULL
  • Field (SCHOOL_NAME)
  • Field (SCHOOL_PHONE)
  • Field (SCHOOL_EMAIL)
  • Field (ADDRESS)
  • Field (MNGR_NAME)
  • Field (MNGR_PHONE)
  • Field (MNGR_EMAIL)
  • Field (USE_YN) — varchar(1)
  • MODIFIED_DATE — timestamp
  • CREATED_BY — varchar(100)
  • CREATED_DATE — timestamp
  • IS_DELETED — varchar(1)
  • MODIFIED_BY — varchar(100)

T_STUDENT

  • STUDENT_ID — PK — Primary key — NOT NULL
  • Field (LOGIN_ID) — UK
  • Field (LOGIN_PWD) — varchar(100)
  • Field (STUDENT_NAME) — varchar(200)
  • Field (PHONE) — varchar(8)
  • Field (EMAIL) — varchar(100)
  • Field (SCHOOL_ID) — varchar(100)
  • Field (SCHOOL_NAME)
  • Field (GRADE) — int
  • Field (EMAIL_YN) — varchar(100)
  • Field (PHONE_YN)
  • Field (WITHDRAW_YN) — varchar(1)
  • Field (WITHDRAW_REASON) — TEXT
  • Field (WITHDRAW_DATE) — timestamp
  • CREATED_DATE — timestamp
  • CREATED_BY — varchar(100)
  • MODIFIED_DATE — timestamp
  • MODIFIED_BY — varchar(100)
  • IS_DELETED — varchar(1)

Untitled (T_POPUP)

  • Key (POPUP_ID) — Primary key — NOT NULL
  • Field (CATEGORY)
  • Field (DIVISION)
  • Field (POPUP_TYPE)
  • Field (TITLE)
  • Field (START_AT)
  • Field (END_AT)
  • Field (URL)
  • Field (CONTENT)
  • Field (IS_VISIBLE)
  • Field (CREATED_DATE)
  • Field (CREATED_BY)
  • Field (MODIFIED_DATE)
  • Field (MODIFIED_BY)
  • Field (HEIGHT)
  • Field (WIDTH)
  • Field (IS_DELETED)

Untitled (T_MENU)

  • Key (MENU_CODE) — Primary key — NOT NULL
  • Field (MENU_NM)
  • Field (MENU_URL)
  • Field (MENU_PARENT)
  • Field (ROLE_CODE)
  • Field (MENU_DEPTH)
  • Field (MENU_ORDER)

Untitled (T_KAKAO_SMS)

  • Key (SMS_ID) — Primary key — NOT NULL
  • Field (MEM_ID)
  • Field (PHONE)
  • Field (CALL_BACK)
  • Field (REQ_DATE)
  • Field (SMS_TEXT)
  • Field (TEMP_CODE)
  • Field (FAIL_TYPE)
  • Field (FAIL_SUBJECT)
  • Field (FAIL_MSG)
  • Field (RESULT_MSG)
  • Field (RESULT_CODE)
  • Field (CMID)
  • Field (CREATED_DATE)

Untitled (T_LOG_LOGIN)

  • Key (LOGIN_AUTHORITY) — Primary key — NOT NULL
  • Field (LOGIN_ID)
  • Field (USER_GROUP)
  • Field (RESULT)
  • Field (FAIL_MSG)
  • Field (LOGIN_IP)
  • Field (CREATED_DATE)
  • Field (USERNAME)

Untitled (T_FILES)

  • Key (ATT_ID) — Primary key — NOT NULL
  • Field (TABLE_NAME)
  • Field (REL_KEY_ID)
  • Field (REL_KEY_TYPE)
  • Field (FILE_PATH)
  • Field (FILE_URI)
  • Field (FILE_NAME)
  • Field (FILE_SIZE)
  • Field (FILE_EXT)
  • Field (CREATED_dATE)
  • Field (IS_DELETED)
  • Field (STORED_NAME)

Untitled (T_LOGIN_POLICY)

  • Key (ID) — varchar(100) — Primary key — NOT NULL
  • Field (HAS_TIME_POLICY)
  • Field (START_TIME)
  • Field (HAS_AUTO_LOGOUT)
  • Field (SESSION_DURATION)
  • Field (CREATED_BY)
  • Field (CREATED_DATE)
  • Field (MODIFIED_BY)
  • Field (MODIFIED_DATE)
  • Field (END_TIME)
  • Field (HAS_IP_CHECK)

Untitled (T_IP_RULE)

  • Key (ID) — varchar(100) — Primary key — NOT NULL
  • Field (US_IP_RANGE)
  • Field (START_IP)
  • Field (END_IP)
  • Field (MEMO)
  • Field (CREATED_BY)
  • Field (CREATED_DATE)
  • Field (MODIFIED_BY)
  • Field (MODIFIED_DATE)
  • Field (POLICY_ID)

Untitled (T_COMMON_CODE)

  • Key (DIVISION) — PK — Primary key — NOT NULL
  • Field (CODE2) — PK — Primary key
  • Field (CODE1) — PK — Primary key
  • Field (CODE3) — PK — Primary key
  • Field (VALUE1)
  • Field (VALUE2)
  • Field (VALUE3)
  • Field (ORD_NO)
  • Field (CREATED_DATE) — timestamp
  • Field (IS_DELETED) — varchar(1)

Untitled (T_BOARD)

  • Key (ID) — PK — Primary key — NOT NULL
  • Field (CODE)
  • Field (CATEGORY)
  • Field (IS_FEATURED)
  • Field (IS_ACTIVE)
  • Field (ATTACH_IMAGE)
  • Field (THUMBNAIL_ID)
  • Field (VIEW_COUNT)
  • Field (VIEW_COUNT_ADMIN)
  • Field (CREATED_BY) — varchar(100)
  • Field (CREATED_DATE) — timestamp
  • Field (MODIFIED_BY) — varchar(100)
  • Field (MODIFIED_DATE) — timestamp
  • Field (START_DATE) — varchar(20)
  • Field (DUE_DATE)
  • Field (THUMBNAIL_URL)
  • Field (TITLE) — varchar(500)
  • Field (CONTENT) — TEXT
  • Field (IS_DELETED) — varchar(1)
  • Field (ATTACH_FILES)
  • Field (ATTACH_PDF)
  • Field (EBOOK_URL)
  • Field (SUMMARY)
  • Field (MEMO)

Untitled (T_BOARD_CATEGORY)

  • Key (ID) — PK — Primary key — NOT NULL
  • Field (KR_NAME)
  • Field (EN_NAME)
  • Field (SORT)
  • Field (MODIFIED_BY) — varchar(100)
  • Field (MODIFIED_DATE) — timestamp