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)