학사관리 시스템
테이블 (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