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)