haksa

Tables (7)

Untitled (department)

  • (dept_code) — int — Primary key — NOT NULL
  • Field (dept_name) — NVARCHAR(30) — NOT NULL
  • Field (dept_ename) — char(50)
  • Field (create_date) — date

Untitled (post)

  • Key (post_no) — char(7) — Primary key — NOT NULL — --우편번호
  • Field (post_dong) — NVARCHAR(30) — NOT NULL — --동이름
  • Field (post_address) — NVARCHAR(60) — NOT NULL — --주소
  • Field (ddd) — char(4) — --DDD 전화지역번호

Untitled (student)

  • Key (stu_no) — char(10) — Primary key — NOT NULL — --학번
  • (dept_code) — int — Foreign key → Untitled.dept_code — NOT NULL
  • Key (post_no2) — char(7) — Foreign key → Untitled.Key — NOT NULL — --우편번호
  • Field (stu_name) — NVARCHAR(10) — --학생이름
  • Field (stu_ename) — char(30) — NOT NULL — 영문이름
  • Field (grade) — int — NOT NULL — 학년
  • Field (class) — int — NOT NULL — 반
  • Field (juya) — char(2) — --주야구분
  • Field (id_num) — char(14) — NOT NULL — --주민등록번호
  • Field (address) — NVARCHAR(100) — --주소
  • Field2 (tel) — char(14) — --전화번호
  • Field (phone_no) — char(14) — --휴대전화번호
  • Field (birth_year) — char(4) — --출생년도

Untitled (subject)

  • Key (sub_code) — char(5) — Primary key — NOT NULL
  • Field (sub_name) — NVARCHAR(50) — NOT NULL
  • Field (sub_ename) — char(50) — --영문과목명
  • Field (create_year) — char(4) — --개설년도

Untitled (professor)

  • Key (prof_code) — char(4) — Primary key — NOT NULL — --교수번호
  • Field (prof_name) — NVARCHAR(10) — -교수명
  • Field (prof_ename) — char(30) — --교수영문이름
  • Field (Create_date) — date — --교수임용날짜

Untitled (attend)

  • Key (stu_no) — char(10) — Primary key — NOT NULL — --학번
  • Key (att_year) — char(4) — Primary key — NOT NULL — --수강년도
  • Key (att_term) — int — Primary key — NOT NULL — 수강학기
  • Key (att_jae) — char — Primary key — NOT NULL — 재수강 구분 1(본학기 수강), 2(재수강), 3(계절학기 수강)
  • Key (sub_code) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (prof_code) — char(4) — Foreign key → Untitled.Key — NOT NULL — --교수번호
  • Field (att_isu) — int — NOT NULL — --이수구분
  • Field (att_point) — int — NOT NULL — --이수학점
  • Field (att_grade) — int — --취득점수
  • Field (att_div) — char — NOT NULL — --수강신청구분
  • Field (att_date) — date — NOT NULL — --수강처리일자

Untitled (fee)

  • Key (stu_no) — char(10) — Primary key — NOT NULL — --학번
  • Field (fee_year) — char(4) — NOT NULL — --등록년도
  • Field (fee_term) — int — NOT NULL — --등록학기
  • Field (fee_enter) — int — --입학금
  • Field (fee_price) — int — --등록금(수업료)
  • Field (fee_total) — int — NOT NULL
  • Field (jang_code) — char — --장학코드
  • Field (jang_total) — int — --장학금액
  • Field (fee_pay) — int — NOT NULL — --납부총액=등록금총액-장학금액
  • Field (fee_div) — char(1) — NOT NULL — --등록구분
  • Field (fee_date) — date — NOT NULL — --등록날짜