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