학사관리 시스템

테이블 (8)

BOARD (게시판 테이블)

  • Key (SEQ) — INT — 기본 키 — NOT NULL
  • Key (STUDENT_ID) — INT — 외래 키 → STUDENT.Key — NOT NULL
  • Field (STUDENT_NAME) — VARCHAR(20) — 외래 키 → STUDENT.Field
  • Field (TITLE) — NVARCHAR(1000)
  • Field (TYPE) — CHAR(1)
  • Field (CONTENT) — NVARCHAR(MAX)
  • Field (REGDATE) — DATETIME
  • Field (CHANGEDATE) — DATETIME
  • Field (VIEWCNT) — INT

CLASS_CHECK (출석체크 테이블)

  • Key (STUDENT_ID) — INT — 외래 키 → STUDENT.Key — NOT NULL
  • Field (STUDENT_NAME) — VARCHAR(20) — 외래 키 → STUDENT.Field
  • Field (SUBJECT_CODE) — INT
  • Field (SUBJECT_NAME) — VARCHAR(50)
  • Field (REGDATE) — DATETIME

COURSE (수강신청 테이블)

  • Key (STUDENT_ID) — INT — 외래 키 → STUDENT.Key — NOT NULL
  • Key (SUBJECT_CODE) — INT — 외래 키 → SUBECT.Key — NOT NULL
  • Field (SEMESTER) — VARCHAR(30)
  • Field (REGDATE) — DATETIME

GRADE (학점 테이블)

  • Key (STUDENT_ID) — INT — 외래 키 → STUDENT.Key — NOT NULL
  • Field (SUBJECT_CODE) — INT
  • Field (GRADE) — FLOAT
  • Field (REGDATE) — DATETIME

MEMBER_GRADE (회원 등급 테이블)

  • Field (GRADE) — VARCHAR(20)
  • Field (POINT_ACCUMULATION_RATE) — INT

POINT (포인트 현황 테이블)

  • Key (STUDENT_ID) — INT — 기본 키 — NOT NULL
  • Field (STUDENT_NAME) — VARCHAR(20)
  • Field (POINT_TYPE) — CHAR(1)
  • Field (POINT_OCCURRENCE_AMOUNT) — money
  • Field (POINT_ACCUMULATED_AMOUNT) — money
  • Field (REGDATE) — DATETIME

STUDENT (학생 테이블)

  • Key (STUDENT_ID) — INT — 기본 키 — NOT NULL
  • Field (STUDENT_NAME) — VARCHAR(20) — 기본 키
  • Field (STUDENT_EMAIL) — VARCHAR(100)
  • Field (STUDENT_MAGOR) — VARCHAR(10)
  • Field (STUDENT_PHONE_NUMBER) — VARCHAR(100)
  • Field (STUDENT_ADDRESS) — VARCHAR(100)
  • Field (STUDENT_GENDER) — CHAR(10)

SUBECT (과목 테이블)

  • Key (SUBJECT_CODE) — INT — 기본 키 — NOT NULL
  • Field (SUBJECT_NAME) — VARCHAR(50)
  • Field (SUBJECT_GRADE) — BIGINT
  • Field (SUBJECT_TYPE) — CHAR(1)
  • Field (REGDATE) — DATETIME