학사

테이블 (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)