ssafy-db-remodeling

Tables (10)

ATTENDANCE (Untitled4)

  • Datetime — datetime — Primary key — NOT NULL
  • UserId — varchar(20) — Foreign key → User.UserId — NOT NULL
  • SignInDatetime — datetime
  • SignOutDatetime — datetime

CLASS (Untitled)

  • ClassId (Key) — varchar(20) — Primary key — NOT NULL
  • RegionCode (Key22) — varChar(10) — Foreign key → Region.RegionCode — NOT NULL
  • CurriculumCode (Key2) — varChar(10) — Foreign key → Curriculum.CurriculumCode — NOT NULL

CLASS_GROUP (Untitled2)

  • ClassGroupNumber (GroupNumber) — tinyint(3) — Primary key — NOT NULL
  • Curriculum (Key) — Foreign key → CLASS.ClassId — NOT NULL
  • RegionCode (Key22) — varChar(10) — Foreign key → CLASS.RegionCode — NOT NULL
  • CurriculumCode (Key2) — varChar(10) — Foreign key → CLASS.CurriculumCode — NOT NULL
  • StudentAccount (student_account) — varchar(20) — Foreign key → STUDENT.StudentAccount — NOT NULL
  • teacher_id (GroupTeacherId) — varchar(20) — Foreign key → CLASS_TEACHER.teacher_id — NOT NULL

CLASS_TEACHER (GROUP_TEACHER)

  • teacher_id (GroupTeacherId) — varchar(20) — Primary key — NOT NULL
  • Name — varchar(100)
  • Phone — varchar(20)
  • UserId — varchar(20) — Foreign key → User.UserId — NOT NULL

Curriculum (CopyOfCopyOfUntitled)

  • CurriculumCode — varChar(10) — Primary key — NOT NULL
  • Name (Field)

EXAM (CopyOfUntitled3)

  • EXAM_ID (EXAMPLE_ID) — varchar(20) — Primary key — NOT NULL
  • Name — varchar(100)

EXAMPLE_RECORD (Untitled3)

  • EXAMPLE_RECORD_ID (Key) — Primary key — NOT NULL
  • EXAMPLE_ID — varchar(20) — Foreign key → EXAM.EXAM_ID — NOT NULL
  • StudentAccount (student_account) — varchar(20) — Foreign key → STUDENT.StudentAccount — NOT NULL
  • IsRetest (Boolean) — boolean
  • Score (Field) — varchar(3)

Region (CopyOfUntitled)

  • RegionCode — varChar(10) — Primary key — NOT NULL
  • Name (Field)

STUDENT (STUDENT_ACCOUNT)

  • StudentAccount (student_account) — varchar(20) — Primary key — NOT NULL
  • Name — varchar(100)
  • Phone — varchar(20)
  • Age — varchar(5)
  • Gender (gender) — varchar(20)
  • UserId — varchar(20) — Foreign key → User.UserId — NOT NULL

User (Untitled5)

  • UserId — varchar(20) — Primary key — NOT NULL
  • Name — varchar(100)
  • Phone — varchar(20)
  • RegUser — varchar(20)
  • RegDatetime — varchar(20)
  • LastUser — varchar(20)
  • LastDatetime — varchar(20)