1017

Tables (9)

ClassRoom (Room)

  • id — char(8) — Primary key — NOT NULL
  • name — nvarchar(30)

Course

  • id — char(8) — Primary key — NOT NULL
  • name — nvarchar(30)

Department

  • id — char(8) — Primary key — NOT NULL
  • Name — nvarchar(30)
  • phone — char(11)
  • zip (Field) — char(5)
  • City (Field2) — nvarchar(10)

Lab (Untitled3)

  • id (Key) — char(8) — Primary key — NOT NULL
  • Field

Paper (Untitled2)

  • id (Key) — char(8) — Primary key — NOT NULL
  • id — char(8) — Foreign key → Professor.id — NOT NULL
  • title (Field) — navrchar(50)
  • date (Field2) — datetime2
  • id (id2) — char(8) — Foreign key → Student.id — NOT NULL

Paper_Participate (Untitled4)

  • id (Key) — char(8) — Foreign key → Paper.id — NOT NULL
  • id — char(8) — Foreign key → Paper.id — NOT NULL
  • id (id2) — char(8) — Foreign key → Professor.id — NOT NULL
  • paperid (Field) — char(8)
  • profid (Field2) — char(8)
  • studentid (Field3) — char(8)

Professor (Untitled)

  • id — char(8) — Primary key — NOT NULL
  • name — nvarchar(30)
  • phone — char(11)
  • deptid — char(8)
  • id (id2) — char(8) — Foreign key → Department.id — NOT NULL

Student

  • id — char(8) — Primary key — NOT NULL
  • name — nvarchar(30)
  • phone — char(11)
  • deptid — char(8) — NOT NULL
  • id (id2) — char(8) — Foreign key → Department.id — NOT NULL
  • id (id3) — char(8) — Foreign key → Professor.id — NOT NULL
  • id (Key) — char(8) — Foreign key → Lab.id — NOT NULL
  • zip (Field) — char(5)
  • City (Field2) — nvarchar(10)

Sugang

  • studentid — char(8) — Foreign key → Student.id — NOT NULL
  • id (id4) — char(8) — Foreign key → Course.id — NOT NULL
  • grade — char(2)
  • year — datetime2
  • roomid — char(8) — NOT NULL
  • id (id2) — char(8) — Foreign key → ClassRoom.id — NOT NULL
  • id (id3) — char(8) — Foreign key → Professor.id — NOT NULL