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)