ERD과제_강채성
테이블 (4)
Assignment_Submit_T (Untitled)
- Asgn_Sub (Submit_Num) — int — 기본 키 — NOT NULL
- ID (Student_ID) — int — 외래 키 → Student_T.ID — NOT NULL
- File (Submit_File_ID) — int — 외래 키 → Submit_File.File — NOT NULL
- Sub_Date (Submit_Datetime) — datetime
- Grade (Assignment_Grade) — varchar(5)
Assignment_T (Untitled3)
- Asgn (Assign_Num) — int — 기본 키 — NOT NULL
- Asgn_Sub (Submit_Num) — int — 외래 키 → Assignment_Submit_T.Asgn_Sub — NOT NULL
- ID (Student_ID) — int — 외래 키 → Assignment_Submit_T.ID — NOT NULL
- File (Submit_File_ID) — int — 외래 키 → Assignment_Submit_T.File — NOT NULL
- Title (Assignment_Title) — varchar(255)
- Deadline (Assignment_Deadline) — datetime
- Stat (Submit_Status) — boolean
Student_T (Untitled2)
- ID (Student_ID) — int — 기본 키 — NOT NULL
- Dept (Department) — varchar(20)
- Name (Student_Name) — varchar(20)
- Email (Email_Address) — varchar(255)
- Ad (Student_Address) — varchar(255)
- Num (Phone_Num) — int
Submit_File (Untitled4)
- File (Submit_File_ID) — int — 기본 키 — NOT NULL
- EXT (Filename_Extension) — varchar(50)