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