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