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) — 주수업방식