MindAlive_v1

Tables (6)

Date (기간 차원)

  • YearMonth (Key) — Primary key — NOT NULL
  • Month (Field2) — Date
  • Quarter (Field3) — Date
  • Year (Field4) — Date

RegistrationHistory (편성내역)

  • ProgramID (Key) — Primary key — NOT NULL
  • StudentID (Key3) — Date — Foreign key → tb_student.std_cd — NOT NULL
  • StudentID (Field2) — Date
  • CenterID (Field3)
  • InvoiceFee (Field4)
  • ActualFee (Field5)
  • Field
  • ym (Key2) — Foreign key → Date.YearMonth — NOT NULL

tb_company (센터 마스터)

  • cmp_cd (Key) — Primary key — NOT NULL
  • fc_cls_sn (Field)
  • cmp_cuc_sn (Field2)
  • city (Field3)
  • cmp_nm (Field6)

tb_student (회원 차원)

  • std_cd (Key) — Date — Primary key — NOT NULL
  • School (Field) — Date
  • Grade (Field2) — Date

tb_sub_company (서브센터 마스터)

  • tsc_seq (Key) — Primary key — NOT NULL
  • cmp_cd (Key2) — Foreign key → tb_company.cmp_cd — NOT NULL
  • sub_cmp_nm (Field2)
  • cmp_gb (Field)

tb_subject (과목 마스터)

  • sbj_cd (Key) — char — Primary key — NOT NULL
  • sbj_spc_sn (Field2) — char
  • sbj_cls_sn (Field3) — char
  • brn_cls (Field5) — char
  • crl_cls (Field) — char
  • sjb_grp_nm (Field6) — char
  • sbj_nm (Field4) — char
  • ini_sbj_nm (Field7) — char