ssafy

Tables (6)

Attendance

  • Index — INT — Primary key — NOT NULL
  • Student_No — VARCHAR(20) — Foreign key → Student.Student_No — NOT NULL
  • Attendance1/1 — TINYINT(1)
  • Attendance1/1_Sign_In — DATETIME
  • Attendance1/1_Sign_Out — DATETIME
  • Attendance1/2 — TINYINT(1)
  • Attendance1/2_Sign_In — DATETIME
  • Attendance1/2_Sign_Out — DATETIME
  • Attendance1/3 — TINYINT(1)
  • Attendance1/3_Sign_In — DATETIME
  • Attendance1/3_Sign_Out — DATETIME

Grade

  • Index (PK) — INT — Primary key — NOT NULL
  • Student_No — VARCHAR(20) — Foreign key → Student.Student_No — NOT NULL
  • Grade_First_Exam — VARCHAR(3)
  • Grade_Second_Exam — VARCHAR(3)
  • Grade_Third_Exam — VARCHAR(3)
  • Algorithm_Grade — VARCHAR(20)
  • Algorithm_Acquisition_Date — datetime
  • Grade_First_Project — VARCHAR(3)
  • Grade_Second_Project — VARCHAR(3)
  • Grade_Third_Project — VARCHAR(3)

Region

  • Region_Name — VARCHAR(20) — Primary key — NOT NULL
  • Group_No — VARCHAR(20) — Primary key — NOT NULL
  • Teacher_id — VARCHAR(20) — Foreign key → Teacher.Teacher_id — NOT NULL

Student

  • Student_No — INT — Primary key — NOT NULL
  • Student_Account — VARCHAR(20)
  • Student_Name — VARCHAR(100)
  • Student_HP — VARCHAR(20)
  • Student_Age — VARCHAR(5)
  • Student_Gender — VARCHAR(20)
  • Student_Curriculum — VARCHAR(20)
  • Region_Name — VARCHAR(20) — Foreign key → Region.Region_Name — NOT NULL
  • Team_id — INT — Foreign key → Team.Team_id — NOT NULL
  • Group_No — VARCHAR(20) — Foreign key → Region.Group_No — NOT NULL

Teacher

  • Teacher_id — VARCHAR(20) — Primary key — NOT NULL
  • Teacher_Name — VARCHAR(20)
  • Teacher_Hp — VARCHAR(20)

Team

  • Team_id — INT — Primary key — NOT NULL
  • Team_Subject — VARCHAR(20)
  • Region_Name — VARCHAR(20) — Foreign key → Region.Region_Name — NOT NULL
  • Group_No — VARCHAR(20) — Foreign key → Region.Group_No — NOT NULL