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)