Haksa2023
Tables (14)
Student
- Key (id) — char(9) — Primary key — NOT NULL
- Field (name) — nchar(5)
- Field (mobile) — char(13)
- Key (lid) — char(9) — Foreign key → Untitled.Key — NOT NULL
- Key (zip) — char(5) — Foreign key → Untitled.Key — NOT NULL
- Key (did) — char(9) — Foreign key → Untitled.Key — NOT NULL
Untitled (Professor)
- Key (id) — char(9) — Primary key — NOT NULL
- Field (name) — nchar(5)
- Field (mobile) — char(13)
- Key (did) — char(9) — Foreign key → Untitled.Key — NOT NULL
- Key (lid) — char(9) — Foreign key → Untitled.Key — NOT NULL
- Key (zip) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (Course)
- Key (id) — char(10) — Primary key — NOT NULL
- Field (name) — nvarchar(20)
- Field2 (credit) — int
Untitled (학과)
- Key (id) — char(9) — Primary key — NOT NULL
- Field (name) — nvarchar(20)
- Field (phone) — char(13)
Untitled (수강)
- Key (sid) — char(9) — Foreign key → Student.Key — NOT NULL
- Key (cid) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (성적) — char(2)
- Field (수강년도) — datetime
- Field
- Key (pid) — char(9) — Foreign key → Untitled.Key — NOT NULL
Untitled (Lab)
- Key (ID) — char(9) — Primary key — NOT NULL
- Field (name) — nvarchar(20)
- Field
Untitled (Project)
- Key (id) — char(9) — Primary key — NOT NULL
- Field (name) — nvarchar(50)
- Field (From) — datetime
- Field (To) — datetime
Untitled (ProjParticipate)
- Key (id) — char(9) — Foreign key → Untitled.Key — NOT NULL
- Key (id2) — char(9) — Foreign key → Student.Key — NOT NULL
- Key (projid) — char(9) — Foreign key → Untitled.Key — NOT NULL
Untitled (Address)
- Key (zip) — char(5) — Primary key — NOT NULL
- Field (City) — char(10)
- Field (Apt) — nchar(30)
Untitled (관심분야)
- Key (id) — char(9) — Primary key — NOT NULL
- Field (name) — nchar(50)
Untitled (Lab관심)
- Key (관심id) — char(9) — Foreign key → Untitled.Key — NOT NULL
- Key (관id) — char(9) — Foreign key → Untitled.Key — NOT NULL
Untitled (논문)
- Key (paper_id) — char(8) — Primary key — NOT NULL
- Field (제목) — nvarchar(100)
- Field (권) — char(10)
- Field (호) — int
- Field (pp) — char(10)
- Key (jid) — char(8) — Foreign key → Untitled.Key — NOT NULL
Untitled (논문참여)
- Key (pid) — char(9) — Foreign key → Untitled.Key — NOT NULL
- Key (paper_id) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (sid) — char(9) — Foreign key → Student.Key — NOT NULL
Untitled (저널명)
- Key (jid) — char(8) — Primary key — NOT NULL
- Field (저널명) — nvarchar(100)
- Field (출판사) — nvarchar(100)