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)