pjt_day01
Tables (7)
GRADE (grade)
- Key (ID) — INT — Primary key — NOT NULL
- Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → STUDENT.Key — NOT NULL
- Field (GRADE_FIRST_EXAM) — VARCHAR(3)
- Field (GRADE_SECOND_EXAM) — VARCHAR(3)
- Field (GRADE_THIRD_EXAM) — VARCHAR(3)
- Field (GRADE_PROJECT) — VARCHAR(3)
- Field (ALGORITHM_GRADE) — VARCHAR(20)
- Field (ALGORITHM_ACQUISITION_DATE) — DATETIME
PROJECT01 (project01)
- PK (PROJECT_NAME) — VARCHAR(50) — Primary key — NOT NULL
- (PROJECT_DEPLOY_URL) — VARCHAR(50)
- (PROJECT_CATEGORY)
REGION (region)
- PK (ID) — INT — Primary key — NOT NULL
- Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → STUDENT.Key — NOT NULL
- PK (STUDENT_REGION) — VARCHAR(20) — Foreign key → TEACHER.PK — NOT NULL
STUDENT (student)
- Key (STUDENT_ACCOUNT) — VARCHAR(20) — Primary key — NOT NULL
- (STUDENT_NAME) — VARCHAR(100)
- (STUDENT_HP) — VARCHAR(20)
- (STUDENT_AGE) — VARCHAR(5)
- (STUDENT_GENDER) — VARCHAR(20)
- (STUDENT_REGION) — VARCHAR(20)
- (REG_USER) — VARCHAR(20)
- (REG_DT) — DATETIME
- (LAST_USER) — VARCHAR(20)
- (LAST_DT) — DATETIME
STUDENT_PROJECT01 (student_proejct01)
- Key (ID) — INT — Primary key — NOT NULL
- FK (PROJECT_NAME) — VARCHAR(50) — Foreign key → PROJECT01.PK — NOT NULL
- Key (STUDENT_ACOUNT) — VARCHAR(20) — Foreign key → STUDENT.Key — NOT NULL
TEACHER (teacher)
- PK (REGION) — VARCHAR(20) — Primary key — NOT NULL
- Field (TEACHER_ID) — VARCHAR(20)
- (TEACHER_NAME) — VARCHAR(20)
- (TEACHER_HP) — VARCHAR(20)
Untitled (attendance)
- Key (ID) — INT — Primary key — NOT NULL
- Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → STUDENT.Key — NOT NULL
- Field (ATTENDANCE_1/1) — TINYINT(1)
- Field (ATTENDANCE_1/1_SIGN_IN) — DATETIME
- Field (ATTENDANCE_1/1_SIGN_OUT) — DATETIME
- Field (ATTENDANCE_1/2) — TINYINT(1)
- Field (ATTENDANCE_1/2_SIGN_IN) — DATETIME
- Field2 (ATTENDANCE_1/2_SIGN_OUT) — DATETIME
- Field2 (ATTENDANCE_1/3) — TINYINT(1)
- Field (ATTENDANCE_1/3_SIGN_IN) — DATETIME
- Field (ATTENDANCE_1/3_SIGN_OUT) — DATETIME
- Field (이하생략)