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 — --등록날짜