2023-10-17

Tables (11)

Copy Of paper_parti (project_participate)

  • proid — char(10) — Foreign key → Professor.proid — NOT NULL
  • Key (id2) — char(8) — Foreign key → Untitled5.Key — NOT NULL
  • stuid — char(8) — Foreign key → Student.stuid — NOT NULL

Course

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

Department

  • deptid — char(8) — Primary key — NOT NULL
  • Name — nvarchar(30)
  • phone — char(11)

Lab

  • id — char(8) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • proid — char(10) — Foreign key → Professor.proid — NOT NULL

Professor (professor)

  • proid — char(10) — Primary key — NOT NULL
  • name — nvarchar(30)
  • phone — char(11)
  • deptid — char(8) — Foreign key → Department.deptid — NOT NULL
  • Field (zip) — char(5)
  • Field2 (city) — nvarchar(10)
  • Field3 (bunzi) — nvarchar(10)

Room

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

Student

  • stuid — char(8) — Primary key — NOT NULL
  • name — nvarchar(30)
  • phone — char(11)
  • deptid — char(8) — NOT NULL
  • deptid (deptid2) — char(8) — Foreign key → Department.deptid — NOT NULL
  • ID (id2) — char(10) — Foreign key → Professor.proid — NOT NULL
  • id (id3) — char(8) — Foreign key → Lab.id — NOT NULL
  • Field (zip) — char(5)
  • Field2 (city) — nvarchar(10)
  • Field3 (bunzi) — nvarchar(10)

Sugang

  • id (id2) — char(8) — Foreign key → Student.stuid — NOT NULL
  • id (id3) — char(8) — Foreign key → Course.id — NOT NULL
  • grade — char(2)
  • year — datetime2
  • roomid — char(8) — NOT NULL
  • ID (id4) — char(10) — Foreign key → Professor.proid — NOT NULL
  • id (id5) — char(8) — Foreign key → Room.id — NOT NULL

Untitled5 (project)

  • Key (id) — char(8) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (start) — datetime2
  • Field (end) — datetime2
  • Field (agency) — nvarchar(50)

paper

  • id — char(8) — Primary key — NOT NULL
  • title — nvarchar(50)
  • date — datetime2

paper_parti (paper_participate)

  • proid — char(10) — Foreign key → Professor.proid — NOT NULL
  • id (id2) — char(8) — Foreign key → paper.id — NOT NULL
  • stuid — char(8) — Foreign key → Student.stuid — NOT NULL