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 — =