DOOWON
Tables (9)
CODE_INFO
- META_ID (META_ID2) — varchar(20) — Foreign key → META_INFO.META_ID — NOT NULL
- META_ID — varchar(20) — NOT NULL
- CODE_ID — varchar(20) — NOT NULL
- CODE_NAME — varchar(100)
- SEQ — int
- USE_YN — char(1)
- REF_CODE1 — varchar(20)
- REF_CODE2 — varchar(20)
- REF_CODE3 — varchar(20)
- MEMO — varchar(100)
- INPUT_ID — varchar(20)
- INPUT_DATETIME — datetime
COUNT_INFO
- SCHOOL_CODE — varchar(20) — Primary key — NOT NULL
- APP_COUNT1 — varchar(10)
- WRITE_COUNT1 — varchar(10)
- APP_COUNT2 — varchar(10)
- WRITE_COUNT2 — varchar(10)
- APP_COUNT3 — varchar(10)
- WRITE_COUNT3 — varchar(10)
- APP_COUNT4 — varchar(10)
- WRITE_COUNT4 — varchar(10)
- APP_COUNT5 — varchar(10)
- WRITE_COUNT5 — varchar(10)
- INPUT_ID — varchar(20)
- INPUT_DATETIME — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- SCHOOL_CODE (SCHOOL_CODE2) — varchar(20) — Foreign key → SCHOOL_INFO.SCHOOL_CODE — NOT NULL
MATCH_INFO
- SCHOOL_CODE — varchar(20) — Primary key — NOT NULL
- USER_ID — varchar(20) — Primary key — NOT NULL
- MATCH_DATE — datetime
- PARTNER_NAME — varchar(20)
- PARTNER_TEL — varchar(20)
- INPUT_ID — varchar(20)
- INPUT_DATETIME — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- USER_ID (USER_ID2) — varchar(20) — Foreign key → USER_INFO.USER_ID — NOT NULL
- SCHOOL_CODE (SCHOOL_CODE2) — varchar(20) — Foreign key → SCHOOL_INFO.SCHOOL_CODE — NOT NULL
META_INFO
- META_ID — varchar(20) — Primary key — NOT NULL
- META_NAME — varchar(50)
- INPUT_ID — varchar(20)
- INPUT_DATETIME — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
REGISTER_INFO
- SCHOOL_CODE — varchar(20) — Primary key — NOT NULL
- STD_YEAR — varchar(10) — Primary key — NOT NULL
- REGISTER_TYPE — varchar(20) — Primary key — NOT NULL
- EXAM_NO — varchar(10) — Primary key — NOT NULL
- STUDENT_NO — varchar(15) — Primary key — NOT NULL
- STUDENT_NAME — varchar(20) — NOT NULL
- DEPT_NAME — varchar(50)
- ADD_REGISTER — varchar(50)
- EXAM_TYPE — varchar(20)
- CERTI_YN — varchar(10)
- SEND_TYPE — varchar(20)
- NIGHT_TYPE — varchar(10)
- BIRTH_DAY — varchar(10)
- SEX_TYPE — varchar(10)
- SOLO_TYPE — varchar(10)
- BONUS_MEMO — varchar(100)
- BONUS_MONEY — varchar(20)
- BAEUM_ADD — varchar(20)
- ETC1 — varchar(20)
- ETC2 — varchar(20)
- ETC3 — varchar(20)
- INPUT_ID — varchar(20)
- INPUT_DATETIME — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- SCHOOL_CODE (SCHOOL_CODE2) — varchar(20) — Foreign key → SCHOOL_INFO.SCHOOL_CODE — NOT NULL
REPORT_INFO
- SCHOOL_CODE — varchar(20) — NOT NULL
- USER_ID — varchar(20) — NOT NULL
- VISIT_DATE — varchar(20) — NOT NULL
- DEPT_NAME — varchar(50)
- USER_NAME — varchar(50)
- VISIT_FROM — varchar(5)
- VISIT_TO — varchar(5)
- VISIT_RESULT_1 — varchar(50)
- VISIT_RESULT_2 — varchar(50)
- VISIT_RESULT_3 — varchar(50)
- VISIT_RESULT_4 — varchar(50)
- VISIT_RESULT_5 — varchar(50)
- VISIT_RESULT_6 — varchar(50)
- VISIT_RESULT_7 — varchar(50)
- VISIT_RESULT_8 — varchar(50)
- VISIT_RESULT_9 — varchar(50)
- VISIT_RESULT_10 — varchar(50)
- VISIT_RESULT_11 — varchar(50)
- VISIT_RESULT_12 — varchar(50)
- VISIT_RESULT_13 — varchar(50)
- VISIT_RESULT_14 — varchar(50)
- VISIT_RESULT_15 — varchar(50)
- VISIT_ETC — text
- INPUT_ID — varchar(20)
- INPUT_DATETIME — datetime
- USER_ID (USER_ID2) — varchar(20) — Foreign key → USER_INFO.USER_ID — NOT NULL
SCHOOL_INFO
- SCHOOL_CODE — varchar(20) — Primary key — NOT NULL
- SCHOOL_NAME — varchar(50)
- SCHOOL_TYPE — varchar(20)
- SCHOOL_LOCATION — varchar(20)
- SCHOOL_ADDRESS — varchar(200)
- SCHOOL_TEL — varchar(20)
- SCHOOL_CATEGORY — char(1)
- INPUT_ID — varchar(20)
- INPUT_DATETIME — datetime
TEACHER_INFO
- SCHOOL_CODE — varchar(20) — Primary key — NOT NULL
- USER_ID — varchar(20) — Primary key — NOT NULL
- VISIT_DATE — varchar(20) — Primary key — NOT NULL
- IDX — int — Primary key — NOT NULL
- TEACHER_NAME — varchar(20)
- TEACHER_TEL — varchar(20)
- INPUT_ID — varchar(20)
- INPUT_DATETIME — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- USER_ID (USER_ID2) — varchar(20) — Foreign key → USER_INFO.USER_ID — NOT NULL
USER_INFO
- USER_ID — varchar(20) — Primary key — NOT NULL
- USER_PW — varchar(100) — NOT NULL
- USER_NAME — varchar(100) — NOT NULL
- CAMPUS_NAME — varchar(10)
- DEPT_TYPE — varchar(50)
- F_DEPT_CODE — varchar(10)
- DEPT_CODE — varchar(10)
- DEPT_NAME — varchar(50)
- USER_TEL — varchar(20)
- USER_EMAIL — varchar(50)
- USER_TYPE — varchar(5)
- EMP_TYPE — varchar(5)
- MEMO — varchar(200)
- INPUT_ID — varchar(20)
- INPUT_DATETIME — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =