StudentManagement
Tables (10)
Copy Of Grade (CopyOfGrade)
- sub_Id (Key) — varchar(45) — Primary key — NOT NULL
- g_s_Id (Key2) — int — Primary key — NOT NULL
- sub_Id (Key3) — varchar(45) — Foreign key → Copy Of Subject.sub_Id — NOT NULL
- g_sub_Name (Field) — varchar(45)
- g_Score (Field2) — int
- g_Grade (Field3) — varchar(10)
Copy Of Member (CopyOfMember)
- userId (Key) — int — Primary key — NOT NULL
- userPwd (Field) — varchar(20)
- userName (Field2) — varchar(10)
- userRole (Field3) — varchar(10)
Copy Of Professor (CopyOfProfessor)
- p_Id (Key) — int — Primary key — NOT NULL
- p_Name (Field) — varchar(45)
- p_Birth (Field2) — varchar(45)
Copy Of Student (CopyOfStudent)
- s_Id (Key) — int — Primary key — NOT NULL
- s_Name (Field) — varchar(45)
- s_Birth (Field2) — varchar(45)
Copy Of Subject (CopyOfSubject)
- sub_Id (Key) — varchar(45) — Primary key — NOT NULL
- sub_Name (Field) — varchar(45)
- sub_p_Id (Field2) — int
- sub_Credit (Field3) — int
Grade
- g_sub_Id (Key) — varchar(45) — Primary key — NOT NULL
- g_s_Id (Key2) — int — Primary key — NOT NULL
- g_sub_Name (Field) — varchar(45)
- g_Score (Field2) — int
- g_Grade (Field3) — varchar(10)
Member
- userId (Key) — int — Primary key — NOT NULL
- userPwd (Field) — varchar(20)
- userName (Field2) — varchar(10)
- userRole (Field3) — varchar(10)
Professor
- p_Id (Key) — int — Primary key — NOT NULL
- p_Name (Field) — varchar(45)
- p_Birth (Field2) — varchar(45)
Student
- s_Id (Key) — int — Primary key — NOT NULL
- s_Name (Field) — varchar(45)
- s_Birth (Field2) — varchar(45)
Subject
- sub_Id (Key) — varchar(45) — Primary key — NOT NULL
- sub_Name (Field) — varchar(45)
- sub_p_Id (Field2) — int
- sub_Credit (Field3) — int