haksadb

Tables (12)

Department

  • id — char(8) — Primary key — NOT NULL
  • name — nvarchar(30)
  • phone — char(11)
  • Field (Bunzi) — nvarchar(10)
  • Key (zip) — char(5) — Foreign key → Untitled.Key — NOT NULL

Student

  • id — char(8) — Primary key — NOT NULL
  • name — nvarchar(30)
  • phone — char(11)
  • depid — char(8) — Foreign key → Department.id — NOT NULL
  • Key (proid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (Lapid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Field (Bunzi) — nvarchar(10)
  • Key (zip) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (juminnum) — char(13)

Untitled (Professor)

  • Key (id) — char(8) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (phone) — char(11)
  • id (depid) — char(8) — Foreign key → Department.id — NOT NULL
  • Field (Bunzi) — nvarchar(10)
  • Key (zip) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (Paper)

  • Key (id) — char(8) — Primary key — NOT NULL
  • Field (tite) — nvarchar(50)
  • Field (date) — datetime2

Untitled (Paper_participate)

  • Key (id) — char(8) — Primary key — NOT NULL
  • Key (paperid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (proid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • id (studentid) — char(8) — Foreign key → Student.id — NOT NULL

Untitled (Lap)

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

Untitled (Project)

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

Untitled (Project_participate)

  • Key (proid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (projectid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • id (studentid) — char(8) — Foreign key → Student.id — NOT NULL

Untitled (adress)

  • Key (zip) — char(5) — Primary key — NOT NULL
  • Field (city) — nvarchar(30)
  • Field (Do) — nvarchar(30)

course (Course)

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

room (ClassRoom)

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

sugang (Sugang)

  • studentid — char(8) — Foreign key → Student.id — NOT NULL
  • id (courseid) — char(8) — Foreign key → course.id — NOT NULL
  • grade — char(2)
  • year — datetime2
  • roomid — char(8) — Foreign key → room.id — NOT NULL
  • Key (proid) — char(8) — Foreign key → Untitled.Key — NOT NULL