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