madangunivershcool

Tables (5)

culp (동아리)

  • c_id (동아리번호) — varchar(45) — Primary key — NOT NULL
  • c_name (동아리명) — varchar(45) — NOT NULL
  • c_budget (동아리예산) — int
  • c_office (동아리사무실) — varchar(45)
  • p_ssn (교수아이디) — varchar(45) — Foreign key → professor.p_ssn — NOT NULL

department (학과)

  • d_no (학과번호) — varchar(45) — Primary key — NOT NULL
  • d_name (학과명) — varchar(45) — NOT NULL
  • d_office (학과사무실) — varchar(45)
  • p_ssn (교수아이디) — varchar(45) — Foreign key → professor.p_ssn — NOT NULL

graduate (대학원생)

  • g_ssn (대학원생아이디) — varchar(45) — Primary key — NOT NULL
  • g_name (대학원생이름) — varchar(45) — NOT NULL
  • g_age (대학원생나이) — int — NOT NULL
  • deg_prog (학위과정) — varchar(45)
  • d_no (학과번호) — varchar(45) — Foreign key → department.d_no — NOT NULL
  • c_id (동아리번호) — varchar(45) — Foreign key → culp.c_id — NOT NULL
  • p_id (과제번호) — varchar(45) — Foreign key → project.p_id — NOT NULL
  • mentoring (선임대학원생유무) — varchar(45) — Foreign key → graduate.g_ssn
  • p_id (프로젝트번호) — varchar(45) — Foreign key → project.p_id — NOT NULL

professor (교수)

  • p_ssn (교수아이디) — varchar(45) — Primary key — NOT NULL
  • p_name (교수이름) — varchar(45) — NOT NULL
  • p_age (교수나이) — int — NOT NULL
  • rankk (직위) — varchar(45) — NOT NULL
  • speciality (연구분야) — varchar(45)
  • pct_time (참여백분율) — int — NOT NULL
  • p_id (과제번호) — varchar(45) — Foreign key → project.p_id — NOT NULL
  • d_no (학과번호) — varchar(45) — Foreign key → department.d_no — NOT NULL
  • c_id (동아리번호) — varchar(45) — Foreign key → culp.c_id — NOT NULL

project (프로젝트)

  • p_id (프로젝트번호) — varchar(45) — Primary key — NOT NULL
  • sponsor (지원기관) — varchar(45) — NOT NULL
  • start_date (시작일) — date — NOT NULL
  • end_date (마감일) — date
  • budget (예산액) — int
  • p_ssn (교수아이디) — varchar(45) — Foreign key → professor.p_ssn — NOT NULL