new_app

Tables (12)

CLASS_GOAL (수업목적)

  • goal_cd (Field2) — Primary key
  • goal_nm (Field)
  • reg_dt (Field3)
  • mod_dt (Field4)

CLASS_SPEC (수업특성)

  • class_spec_cd (Field2) — Primary key
  • class_type_cd (Field22) — Foreign key → CLASS_TYPE.class_type_cd
  • class_spec (Field)
  • score (Field3)
  • reg_dt (Field4)
  • mod_dt (Field5)

CLASS_TYPE (수업유형)

  • class_type_cd (Field2) — Primary key
  • class_type (Field)
  • class_desc (Field3)
  • coach_dir (Field4)
  • reg_dt (Field5)
  • mod_dt (Field6)

COACH_SPEC (코치특성)

  • coach_spec_cd (Field2) — Primary key
  • coach_type_cd (Field22) — Foreign key → COACH_TYPE.coach_type_cd
  • coach_spec (Field)
  • score (Field3)
  • reg_dt (Field4)
  • mod_dt (Field5)

COACH_TYPE (코치유형)

  • coach_type_cd (Field2) — Primary key
  • coach_type (Field)
  • coach_desc (Field3)
  • coach_dir (Field4)
  • reg_dt (Field5)
  • mod_dt (Field6)

NOTICE_GRADE (노출 학년)

  • grade_cd (Field2) — Primary key
  • grade (Field)
  • reg_dt (Field3)
  • mod_dt (Field4)

RATING (성적)

  • rating_cd (Field2) — Primary key
  • rating (Field)
  • reg_dt (Field3)
  • mod_dt (Field4)

SUBJECT_L (수업 대분류)

  • subejct_cd (Key) — Primary key — NOT NULL
  • subject_nm (Field2)
  • reg_dt (Field)
  • mod_dt (Field3)

SUBJECT_M (수업 세분류)

  • m_subject_cd (Key) — Primary key — NOT NULL
  • subejct_cd (Key2) — Foreign key → SUBJECT_L.subejct_cd — NOT NULL
  • m_subject_nm (Field2) — NOT NULL
  • grade_cd (Field)
  • rating_cd (Field3)
  • reg_dt (Field4)
  • mod_dt (Field5)

TYPE_ANLYS (유형종합평가)

  • anlys_cd (Field4) — Primary key
  • anlys_type (Field)
  • anlys_desc (Field2)
  • coach_type_cd (Field12)
  • class_type_cd (Field3)
  • user_type_cd (Field5)
  • reg_dt (Field6)
  • mod_dt (Field7)

USER_SPEC (회원특성)

  • user_spec_cd (Field2) — Primary key
  • user_type_cd (Field22) — Foreign key → USER_TYPE.user_type_cd
  • user_spec (Field)
  • score (Field3)
  • reg_dt (Field4)
  • mod_dt (Field5)

USER_TYPE (회원유형)

  • user_type_cd (Field2) — Primary key
  • user_type (Field)
  • user_desc (Field3)
  • coach_dir (Field4)
  • reg_dt (Field5)
  • mod_dt (Field6)