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