学生情報

Tables (19)

ApplyForDetailedMajor (Untitled8)

  • Field
  • Field2
  • Field3
  • Field4

ApplyForStatusChange (Untitled7)

  • Field
  • Field2
  • Field3
  • Field4

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

Students (Untitled10)

    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중의 하나