학사
테이블 (6)
attend
- stu_no — char(10) — 기본 키 — NOT NULL
- att_year — char(4) — 기본 키 — NOT NULL
- att_term — int — 기본 키 — NOT NULL
- sub_code — char(5) — 기본 키 — NOT NULL
- prof_code — char(4) — 기본 키 — NOT NULL
- att_isu — int — NOT NULL
- att_point — int — NOT NULL
- att_grade — int
- att_div — char — NOT NULL
- att_jae — char
- att_date — date — NOT NULL
fee
- stu_no — char(10) — 기본 키 — NOT NULL
- fee_year — char(4) — 기본 키 — NOT NULL
- fee_term — int — 기본 키 — NOT NULL
- fee_enter — int
- fee_price — int — NOT NULL
- fee_total — int — NOT NULL
- jang_code — char
- jang_total — int
- fee_pay — int — NOT NULL
- fee_div — char(1) — NOT NULL
- fee_date — date — NOT NULL
professor
- prof_code — char(4) — 기본 키 — NOT NULL
- prof_name — NVARCHAR(10) — NOT NULL
- prof_ename — char(30)
- Create_date — date
score
- stu_no — char(10) — 기본 키 — NOT NULL
- fee_year — char(4) — 기본 키 — NOT NULL
- fee_term — int — 기본 키 — NOT NULL
- fee_enter — int
- fee_price — int — NOT NULL
- fee_total — int — NOT NULL
- jang_code — char(2)
- jang_total — int
- fee_pay — int — NOT NULL
- fee_div — char(1) — NOT NULL
- fee_date — date — NOT NULL
student
- stu_no — char(10) — 기본 키 — NOT NULL
- stu_name — NVARCHAR(10) — NOT NULL
- stu_ename — char(30)
- dept_code — int — NOT NULL
- grade — int — NOT NULL
- class — int — NOT NULL
- juya — char(2)
- id_num — char(14) — NOT NULL
- post_no — char(7)
- address — NVARCHAR(100)
- tel — char(14)
- phone_no — char(14)
- birth_year — char(4)
subject
- sub_code — char(5) — 기본 키 — NOT NULL
- sub_name — NVARCHAR(50) — NOT NULL
- sub_ename — char(50)
- create_year — char(4)