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