1

Tables (6)

Department

  • subjectId (Key) — Number — Foreign key → Subject.subjectId — NOT NULL — primary key of subject
  • 신학과 (Field) — String
  • 신학부 (Field2) — String
  • 영어영문학과 (Field3) — String
  • 중어중문학과 (Field4) — String
  • 국어국문학과 (Field5) — String
  • 국제개발협력학과 (Field6) — String
  • 행정학과 (Field7) — String
  • 음악학부 (Field8) — String
  • 유아교육학과 (Field9) — String
  • 체육교육학과 (Field10) — String
  • 컴퓨터공학과 (Field11) — String
  • 미디어소프트웨어학과 (Field12) — String
  • 정보통신공학과 (Field13) — String
  • 산업경영공학과 (Field14) — String

Grade (Untitled)

  • subjectId (Key) — Number — Foreign key → Subject.subjectId — NOT NULL — primary key of subject
  • 1 (Field) — Number
  • 2 (Field2) — Number
  • 3 (Field3) — Number
  • 4 (Field4)

Subject

  • subjectId (Key) — Number — Primary key — NOT NULL — primary key of subject
  • grade (Field2) — Number
  • subjectName (Field3) — String
  • subjectType (Field4) — String
  • subjectPoint (Field5) — Number
  • subjectCode (Field6) — Number
  • professorName (Field7) — String
  • classroom (Field8) — String
  • division (Field9) — Number
  • date (Field10) — String
  • department (Field) — String

SubjectPoint (Untitled2)

  • subjectId (Key) — Number — Foreign key → Subject.subjectId — NOT NULL — primary key of subject
  • 0 (Field) — Number
  • 1 (Field2) — Number
  • 2 (Field3) — Number
  • 3 (Field4)

SubjectType (Untitled3)

  • subjectId (Key) — Number — Foreign key → Subject.subjectId — NOT NULL — primary key of subject
  • 전필 (Field) — String
  • 전선 (Field2) — String
  • 교필 (Field3) — String
  • 교선 (Field4) — String
  • 교직 (Field5)

User

  • userId (Key) — Token — Primary key — NOT NULL
  • role (Field) — String
  • email (Field2) — String
  • password (Field3) — Token
  • name (Field4) — String
  • image (Field5) — String
  • studentId (Field6) — Number
  • department (Field7) — String