SENIORITY
Tables (11)
CRAMSCHOOL (학원)
- CSID — NUMBER — Primary key — NOT NULL — 학원ID
- BNUMBER — VARCHAR2(20) — 사업자번호
- ADDRESS — VARCHAR2(100) — 주소
- CSINFO — VARCHAR2(1000) — 학원소개
- TARGET — VARCHAR2(50) — 대상안내
- SUBJECT — VARCHAR2(50) — 과목소개
- CONTACT — VARCHAR2(30) — 연락처
LAVEL_TBL (학년)
- LCODE — NUMBER — Primary key — NOT NULL
- LNAME — VARCHAR2(6)
LESSON (수업)
- LID — NUMBER — Primary key — NOT NULL — 수업ID
- LTITLE — VARCHAR2(100) — 수업제목
- VINFO — VARCHAR2(100) — 수업소개영상
- LINFO — VARCHAR2(1000) — 수업소개글
- TINFO — VARCHAR2(1000) — 강사소개
- NOTICE — VARCHAR2(1000) — 유의사항
- LCODE — NUMBER — Foreign key → LAVEL_TBL.LCODE — NOT NULL — 학년코드
- SCODE — NUMBER — Foreign key → SUBJECT_TBL.SCODE — NOT NULL — 과목코드
- SSCODE — CHAR — Foreign key → SEMESTER_TBL.SSCODE — NOT NULL
- WCODE — CHAR(6) — Foreign key → WEEK_TBL.WCODE — NOT NULL — 주 수업 방식
- CSID (CSID2) — NUMBER — Foreign key → CRAMSCHOOL.CSID — NOT NULL
- STATUS — CHAR(2) — 수업상태
- UID — NUMBER — Foreign key → LOCKER.UID — NOT NULL — 학생ID
- UID (UID2) — NUMBER — Foreign key → LOCKER.UID — NOT NULL — 학생ID
LOCKER (보관함)
- UID — NUMBER — Foreign key → USER_TBL.UID — NOT NULL — 학생ID
- LK1 — NUMBER
- LK2 — NUMBER
- LK3 — NUMBER
- LK4 — NUMBER
- LK5 — NUMBER
- LK6 — NUMBER
PAY_TBL (결제)
- PCODE — VARCHAR2(30) — Primary key — NOT NULL
- LID — NUMBER — Foreign key → LESSON.LID — NOT NULL — 수업ID
- UID — NUMBER — Foreign key → USER_TBL.UID — NOT NULL — 학생ID
- PDATE — DATE — 결제일
- PAYMENT — VARCHAR2(20) — 결제내용
- ACOUNT — NUMBER
QNA_TBL (게시판)
- QID — NUMBER — Primary key — NOT NULL
- UID — NUMBER — Foreign key → USER_TBL.UID — NOT NULL — 학생ID
- LID — NUMBER — Foreign key → LESSON.LID — NOT NULL — 수업ID
- QUESTION — VARCHAR(100) — 문의글
- QTIME — DATE — 문의시간
- ANSWER — VARCHAR(100) — 답변글
- ATIME — DATE — 답변시간
REVIEW_TBL (리뷰)
- RVID — NUMBER — Primary key — NOT NULL — 후기ID
- UID — NUMBER — Foreign key → USER_TBL.UID — NOT NULL — 작성자
- RETEXT — VARCHAR2(2000) — 후기내용
- REDATE — DATE — 후기 작성일
- LID — NUMBER — Foreign key → LESSON.LID — NOT NULL — 수업ID
SEMESTER_TBL (학기)
- SSCODE — CHAR — Primary key — NOT NULL
- SSNAME — VARCHAR(20) — 학기명
SUBJECT_TBL (과목)
- SCODE — NUMBER — Primary key — NOT NULL — 과목명 코드
- SNAME — VARCHAR(20) — 과목명
USER_TBL (학생)
- UID — NUMBER — Primary key — NOT NULL — 학생ID
- UPW — VARCHAR2(30) — 패스워드
- UNAME — VARCHAR2(20) — 학생명
- UADDRESS — VARCHAR2(100) — 학생주소
- PHONE — VARCHAR2(30) — 연락처
- LAVEL — NUMBER — Foreign key → LAVEL_TBL.LCODE — NOT NULL
- STATUS — CHAR(2) — 탈퇴여부
WEEK_TBL (방식)
- WCODE — CHAR(6) — Primary key — NOT NULL — 주 수업 방식
- WNAME — VARCHAR2(10) — 주수업방식