Dept_new

Tables (15)

Untitled (학생)

  • Key (학번) — char(8) — Primary key — NOT NULL
  • Field (이름) — char(4)
  • Field (전화) — char(11)
  • Field (주소) — varchar(30)
  • Key (학과명) — varchar(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (실험id) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (이메일) — varchar(30)

Untitled (교과목)

  • Key (과목코드) — char(7) — Primary key — NOT NULL
  • Field (과목명) — varchar(40)
  • Field (학점) — int
  • Key (직번) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (시간) — int

Untitled (교수)

  • Key (직번) — char(5) — Primary key — NOT NULL
  • Field (이름) — char(4)
  • Field (전화) — char(11)
  • Field (주소) — varchar(30)
  • Key (학과명) — varchar(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (실험실)

  • Key (실험id) — char(5) — Primary key — NOT NULL
  • Field (roomNo) — char(5)
  • Field (실험실명) — varchar(20)
  • Key (학과명) — varchar(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (직번) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (학과)

  • Key (학과명) — varchar(30) — Primary key — NOT NULL
  • Field (roomNo) — char(5)
  • Field (phone) — char(11)
  • Field (fax) — char(11)
  • Key (시설줄코드) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (수강신청)

  • Key (과목코드) — char(7) — Foreign key → Untitled.Key — NOT NULL
  • Key (학번) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Field (학기) — char(7)
  • Field (성적) — char(2)

Untitled (주소)

  • Key (우편번호) — char(5) — Primary key — NOT NULL
  • Field (도시명(10)) — char(10)
  • Field (구) — char(10)
  • Field (번 길) — varchar(30)

Untitled (주소연결)

  • Key (일련번호) — char(5) — Primary key — NOT NULL
  • Key (우편번호) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (학과명) — varchar(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (직번) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (학번) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (시설줄코드) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (시설)

  • Key (시설줄코드) — char(5) — Primary key — NOT NULL
  • Field (명칭) — varchar(20)
  • Field (관리명칭) — char(10)
  • Key (부서명) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (학과명) — varchar(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (직원)

  • Key (직번) — char(5) — Primary key — NOT NULL
  • Field (이름) — varchar(20)
  • Field (전화번호) — char(11)
  • Field (개인 이메일) — varchar(30)
  • Key (부서명) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (논문)

  • Key (논문명) — varchar(20) — Primary key — NOT NULL
  • Field (출판일시) — date
  • Field (학술지 이름) — varchar(20)
  • Field

Untitled (논문참여)

  • Key (논문명) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (학번) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (직번) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (부서)

  • Key (부서명) — char(10) — Primary key — NOT NULL

Untitled (프로젝트 참여)

  • Key (id) — int — Primary key — NOT NULL
  • Key (직번) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (학번) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (프로젝트 코드) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (프로젝트)

  • Key (프로젝트 코드) — char(5) — Primary key — NOT NULL
  • Field (프로젝트명) — varchar(20)
  • Field (시작기간) — date
  • Field (끝기간) — date
  • Field (예산) — int