qwe

Tables (8)

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)

Room

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

Student

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

Sugang

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

Untitled (Porfeseor)

  • id (id2) — char(8) — Foreign key → Department.id — NOT NULL
  • id (id3) — char(8) — Foreign key → Student.id — NOT NULL
  • id (id22) — char(8) — Foreign key → Student.id — NOT NULL
  • Field (id) — char(8)
  • Field (name) — nvarchar(30)
  • Field (phono) — char(11)
  • Field (deplid) — char(8)

Untitled (Paper)

  • Field (id) — char(8)
  • Field (Utio) — nvarchar(50)
  • Field (date) — datarime

Untitled (Paper_Participate)

  • id (id2) — char(8) — Foreign key → Untitled.id — NOT NULL
  • id (id3) — char(8) — Foreign key → Untitled.id — NOT NULL
  • id (id22) — char(8) — Foreign key → Untitled.id — NOT NULL
  • Field (paperid) — char(8)
  • Field (profid) — char(8)
  • Field (studentid) — char(8)