学生情報
Tables (19)
ApplyForDetailedMajor (Untitled8)
ApplyForStatusChange (Untitled7)
BasicMajorCurriculam (Untitled9)
- Key — Primary key — NOT NULL
- Field
- Field2 — varchar(20)
Department (Untitled2)
- Key — varchar(20) — Primary key — NOT NULL
- Field — varchar(20)
- Field2 — Int
- Field3 — Int
- Field4 — Int
Departments (Untitled11)
- Key — varchar(20) — Primary key — NOT NULL
- Field
- Field2 — Int
- Field3 — Int
DetailedMajor (Untitled4)
- Key — varchar(20) — Primary key — NOT NULL
- Field — varchar(20)
- Field2
- Field3
DetailedMajorCrriculam (Untitled5)
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL — 2年生から選んだ科目を全部聞くために必要な科目の集合
- Field
- Field2
EducationCurriculam (CopyOfCopyOfUntitled92)
- Key — Primary key — NOT NULL
- Field
- Field2 — varchar(20)
Grade (Untitled14)
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- Field
Grade (Untitled6)
- Foreign Key (Key) — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- Field
- Field2
IntensiveMajorCurriculam (CopyOfUntitled9)
- Key — Primary key — NOT NULL
- Field
- Field2 — varchar(20)
JointMajorCurriculam (CopyOfUntitled92)
- Key — Primary key — NOT NULL
- Field
- Field2 — varchar(20)
Major (Untitled13)
- Key — varchar(20) — Primary key — NOT NULL
- Field
- Field2 — 심화전공, 기본전공, 복수전공, 부전공, 연계전공, 교육전공
- Field3
MajorCurriculum (CopyOfUntitled13)
- ForeignKey (Major) — varchar(20) — Primary key — NOT NULL
- Field
- Field2
- Field3
Student (Untitled)
- Key4 — varchar(20) — Primary key — NOT NULL
- Field — Int
- Field2 — Int — 1부터 2까지만 가능
- Field3
- Field4
- Field5
- Field6
- Field7
- Field8
- Field9
- Field10
- Field11
SubMajorCurriculam (CopyOfCopyOfUntitled9)
- Key — Primary key — NOT NULL
- Field
- Field2 — varchar(20)
Subject (Untitled3)
- Key — varchar(20) — Primary key — NOT NULL
- Field — varchar(20)
- Field2 — Double
- Field3 — varchar(20)
Subjects (Untitled12)
- Key — varchar(20) — Primary key — NOT NULL
- Field
- Field2
- Field3 — 과목이 어떤 유형인지 전공, 교양필수, 교양선택, 일반선택 3중의 하나