SecondProject

Tables (48)

ADMIN (CopyOfUntitled82)

  • ADMINID (Key) — VARCHAR2(20) — Primary key — NOT NULL — <학번 만드는 형식> 1+(입학년도2숫자)+(단대번호2숫자)+(학과전공2숫자)+(고유번호3숫자)
  • STATUSNUM (Key2) — NUMBER(3) — Foreign key → USERREASON.STATUSNUM — NOT NULL
  • NAME (Field2) — VARCHAR2(60) — NOT NULL
  • BIRTHDAY (Field) — DATE — NOT NULL
  • PHONENUM (Field3) — VARCHAR2(20) — NOT NULL
  • ADDRESS (Field4) — VARCHAR2(300) — NOT NULL
  • ENTERDATE (Field5) — DATE — NOT NULL
  • GRADUATEATE (Field6) — DATE
  • PARTNUM (Field7) — VARCHAR2(20) — NOT NULL — 학기
  • EMAIL (Field8) — VARCHAR2(30)
  • INDATE (Field9) — DATE
  • WID (Key3) — VARCHAR2(20) — Foreign key → ADMIN.ADMINID — <학번 만드는 형식> 1+(입학년도2숫자)+(단대번호2숫자)+(학과전공2숫자)+(고유번호3숫자)
  • PASSWORD (Field10) — VARCHAR2(20)

ALUMI (CopyOfUntitled6)

  • SREGINUM (Key) — VARCHAR2(20) — Primary key — NOT NULL
  • ApplicantSeq (Key3) — NUMBER — Foreign key → Applicant.ApplicantSeq — NOT NULL
  • NAME (Field4) — VARCHAR2(60)
  • BIRTHDAY (Field5) — DATE
  • PASSWORD (Field6) — VARCHAR2(20)
  • PHONENUM (Field7) — VARCHAR2(20)
  • ADDRESS (Field8) — VARCHAR2(300)
  • EMAIL (Field9) — VARCHAR2(30)
  • INDATE (Field10) — DATE — NOT NULL
  • WID (Field) — VARCHAR2(20) — 서류미비, 작성중 등을 저장
  • PIC_NAME (Field3) — VARCHAR2(50)
  • ENTERDATE (Field2) — DATE — NOT NULL
  • SEMESTER (Field11) — NUMBER(2)
  • UDATE (Field12) — DATE
  • LID (Field13) — VARCHAR2(20)
  • GRADATE (Field14) — DATE
  • STATUSNUM (Key2) — NUMBER(3) — Foreign key → USERREASON.STATUSNUM — NOT NULL — <규칙> 세자리 숫자로 입력. -백의자리 수 100 재학 200 휴학 300 졸업 400 제적 500 자퇴(재입학 가능) 600 퇴학(재입학 안됨) 700 재직(교수, 교직원) 800 퇴직(교수, 교직원) 900…

ANSWER (Untitled31)

  • AnswSeq (Key) — NUMBER — Primary key — NOT NULL
  • Exam_Seq2 (Key3) — NUMBER — Foreign key → ExamQuestion.Exam_Seq2 — NOT NULL
  • ANSWER (Field) — VARCHAR2(4000)
  • INDATE (Field2) — DATE
  • intime (Field3) — VARCHAR2(40)
  • SREGINUM (Key2) — VARCHAR2(20) — Foreign key → StudentMember.SMSeq — NOT NULL

ASS_FILE (CopyOfCopyOfUntitled13)

  • FILEASEQ (Key) — NUMBER — Primary key — NOT NULL
  • ASubSeq (Key2) — NUMBER — Foreign key → Assignment_Submit.ASubSeq — NOT NULL
  • ORG_NAME (Field) — VARCHAR2(300)
  • NAME (Field2) — VARCHAR2(300)
  • SREGINUM (Field3) — VARCHAR2(20)
  • WDATE (Field4) — DATE

ATTENDANCE_DATA (CopyOfUntitled24)

  • ADSEQ (Key) — NUMBER — Primary key — NOT NULL
  • ATIME (Field3) — NUMBER(10)
  • starttime (Field4) — VARCHAR2(15)
  • endtime (Field5) — VARCHAR2(15)
  • courseSeq (Key3) — NUMBER — Foreign key → course.courseSeq — NOT NULL
  • SMSeq (Key2) — NUMBER — Foreign key → StudentMember.SMSeq — NOT NULL

Applicant (Untitled6)

  • ApplicantSeq (Key) — NUMBER — Primary key — NOT NULL
  • MajorSeq (Key3) — NUMBER — Foreign key → Major.MajorSeq — NOT NULL
  • NAME (Field4) — VARCHAR2(60)
  • BIRTHDAY (Field5) — DATE
  • PASSWORD (Field6) — VARCHAR2(20)
  • PHONENUM (Field7) — VARCHAR2(20)
  • ADDRESS (Field8) — VARCHAR2(300)
  • EMAIL (Field9) — VARCHAR2(30)
  • requirement_File (Field2) — VARCHAR2(60)
  • INDATE (Field10) — DATE
  • PROCEDDING (Field) — VARCHAR2(60) — 서류미비, 작성중 등을 저장
  • PIC_NAME (Field3) — VARCHAR2(50)
  • WDATE (Field11) — DATE

Assignment (CopyOfCopyOfUntitled112)

  • ASSSeq (Key) — NUMBER — Primary key — NOT NULL
  • LectureNum (Key2) — VARCHAR2(10) — Foreign key → lecture.LectureNum — NOT NULL
  • TITLE (Field2) — VARCHAR2(120)
  • CONTENTS (Field3) — VARCHAR2(3000)
  • INDATE (Field4) — DATE
  • STARTDATE (Field5) — DATE
  • ENDDATE (Field6) — DATE

Assignment_Submit (CopyOfCopyOfCopyOfUntitled112)

  • ASubSeq (Key) — NUMBER — Primary key — NOT NULL
  • ASSSeq (Key2) — NUMBER — Foreign key → Assignment.ASSSeq — NOT NULL
  • TITLE (Field2) — VARCHAR2(120)
  • CONTENTS (Field3) — VARCHAR2(3000)
  • INDATE (Field4) — DATE
  • UDATE (Field) — DATE
  • SMSeq (Key3) — NUMBER — Foreign key → StudentMember.SMSeq — NOT NULL

BILL (Untitled16)

  • ENSEQ (Key) — NUMBER — Primary key — NOT NULL
  • isPayed (Field6) — VARCHAR2(1)
  • TotScolaship (Field) — NUMBER
  • subtotal (Field2) — NUMBER
  • SRSEQ (Key2) — NUMBER — Foreign key → SEMESTER.SRSEQ — NOT NULL
  • SREGINUM (Field3) — VARCHAR2(20)
  • TOTALCOST (Field4) — NUMBER
  • TOTALCREDIT (Field5) — NUMBER

COUNTIME (Untitled33)

  • COUNSEQ (Key) — NUMBER — Primary key — NOT NULL
  • MPSEQ (Key2) — NUMBER — Foreign key → Major_Professor.MPSEQ — NOT NULL
  • COUNDATE (Field) — VARCHAR2(20)
  • STARTTIME (Field2) — DATE
  • ENDTIME (Field3) — DATE

Cancel_Counsel (CopyOfCopyOfUntitled5)

  • CCSeq (Key) — NUMBER — Primary key — NOT NULL
  • COUNSEL_SEQ (Key2) — NUMBER — Foreign key → counsel.COUNSEL_SEQ — NOT NULL
  • INDATE (Field) — DATE
  • IsPermitted (Field2) — VARCHAR2(1) — 승인 완료시 T
  • REASON (Field3) — VARCHAR2(3000)
  • WDATE (Field4) — DATE

College_Category (Untitled)

  • CATEGORIES (Key) — NUMBER(2) — Primary key — NOT NULL
  • NAME (Field) — VARCHAR2(30)

CounselType (CopyOfUntitled26)

  • typeNum (Key) — NUMBER(2) — Primary key — NOT NULL — 두자리 수로 10. 가정사정 20. 학업관련, 전공문의 30. 학교생활관련 40. 강의관련 50. 정기상담 60. 논문관련 90. 기타상담 일의자리는 각 항목값
  • NAME (Field) — VARCHAR2(90)

Exam (Untitled15)

  • ExamSeq (Key) — NUMBER — Primary key — NOT NULL
  • LectureNum (Key2) — VARCHAR2(10) — Foreign key → lecture.LectureNum — NOT NULL
  • Exam_Num (Field) — VARCHAR2(1) — 중간M 기말F
  • Start_date (Field2) — DATE
  • End_date (Field3) — DATE
  • TIMELimit (Field4) — VARCHAR2(10)
  • INDATE (Field5) — DATE
  • WId (Field6) — VARCHAR2(20)

ExamQuestion (Untitled30)

  • Exam_Seq2 (Key) — NUMBER — Primary key — NOT NULL
  • ExamSeq (Key2) — NUMBER — Foreign key → Exam.ExamSeq — NOT NULL
  • Question (Field) — VARCHAR2(3000)
  • Question_Score (Field2) — NUMBER
  • QuestionNum (Field3) — NUMBER

Grade_Type (Untitled29)

  • GR_Seq (Key) — NUMBER — Primary key — NOT NULL
  • SCoreType_SEQ (Key4) — NUMBER — Foreign key → lecture.SCoreType_SEQ — NOT NULL
  • name (Field) — VARCHAR2(3)
  • latio (Field2) — NUMBER

LECTURETYPE (Untitled34)

  • TYPENUM (Key) — NUMBER — Primary key — NOT NULL
  • TYPENAME (Field) — VARCHAR2(30)

LectureNoticeFile (CopyOfCopyOfCopyOfUntitled132)

  • FILELSEQ (Key) — NUMBER — Primary key — NOT NULL
  • LNSeq (Key2) — NUMBER — Foreign key → Lecture_Notice.LNSeq — NOT NULL
  • ORG_NAME (Field) — VARCHAR2(300)
  • NAME (Field2) — VARCHAR2(300)
  • IDATE (Field3) — DATE
  • PREGINUM (Field4) — VARCHAR2(60)

Lecture_Notice (Untitled11)

  • LNSeq (Key) — NUMBER — Primary key — NOT NULL
  • LectureNum (Key2) — VARCHAR2(10) — Foreign key → lecture.LectureNum — NOT NULL
  • TITLE (Field2) — VARCHAR2(120)
  • CONTENTS (Field3) — VARCHAR2(3000)
  • INDATE (Field4) — DATE
  • PREGINUM (Field5) — VARCHAR2(20)

Major (Untitled2)

  • MajorSeq (Key) — NUMBER — Primary key — NOT NULL
  • CATEGORIES (Key2) — NUMBER(2) — Foreign key → College_Category.CATEGORIES — NOT NULL
  • NAME (Field) — VARCHAR2(60)
  • EXPLAINATION (Field3) — VARCHAR2(3000)
  • GOAL (Field2) — VARCHAR2(3000)
  • ROADMAP (Field4) — VARCHAR2(3000)
  • ROADMAP_PIC (Field5) — VARCHAR2(60)

Major_Professor (Untitled14)

  • MPSEQ (Key2) — NUMBER — Primary key — NOT NULL
  • PREGINUM (Key3) — VARCHAR2(20) — Foreign key → Professor.PREGINUM — NOT NULL — <학번 만드는 형식> 1+(입학년도2숫자)+(단대번호2숫자)+(학과전공2숫자)+(고유번호3숫자)
  • MajorSeq (Key) — NUMBER — Foreign key → Major.MajorSeq — NOT NULL
  • TEL (Field) — VARCHAR2(20)
  • career (Field2) — VARCHAR2(300)
  • subject (Field3) — VARCHAR2(300)
  • TITLE (Field4) — VARCHAR2(300)
  • EMAIL (Field5) — VARCHAR2(30)

Major_curriculum (Untitled21)

  • MCSeq (Key) — NUMBER — Primary key — NOT NULL
  • MajorSeq (Key2) — NUMBER — Foreign key → Major.MajorSeq — NOT NULL
  • GRADE (Field) — NUMBER
  • SUBJECT (Field3) — VARCHAR2(300)
  • explanation (Field4) — VARCHAR2(3000)
  • CREDIT (Field2) — NUMBER(3)

NoticeFile (CopyOfCopyOfUntitled132)

  • FILESEQ (Key) — NUMBER — Primary key — NOT NULL
  • NOTICESEQ (Key2) — NUMBER — Foreign key → totNotice.NOTICESEQ — NOT NULL
  • ORG_NAME (Field) — VARCHAR2(300)
  • NAME (Field2) — VARCHAR2(300)
  • IDATE (Field3) — DATE
  • WID (Field4) — VARCHAR2(60)

PAYMENT_STATEMENT (Untitled18)

  • paymentNum (Key) — VARCHAR2(60) — Primary key — NOT NULL
  • ENSEQ (Key2) — NUMBER — Foreign key → BILL.ENSEQ — NOT NULL
  • isSucess (Field) — VARCHAR2(2)
  • meansOfPayment (Field2) — VARCHAR2(60)
  • ResultCode (Field3) — VARCHAR2(10)
  • totPrice (Field4) — VARCHAR2(13)
  • OrderNum (Field5) — VARHCAR2(60)
  • INDATE (Field6) — DATE
  • receipt_URL (Field8) — VARCHAR2(300)

Professor (CopyOfUntitled8)

  • PREGINUM (Key) — VARCHAR2(20) — Primary key — NOT NULL — <교수직번 만드는 형식> 2+(입학년도2숫자)+(단대번호2숫자)+(학과전공2숫자)+(고유번호3숫자)
  • STATUSNUM (Key2) — NUMBER(3) — Foreign key → USERREASON.STATUSNUM — NOT NULL
  • NAME (Field2) — VARCHAR2(60)
  • BIRTHDAY (Field) — DATE
  • PHONENUM (Field3) — VARCHAR2(20)
  • ADDRESS (Field4) — VARCHAR2(300)
  • ENTERDATE (Field5) — DATE
  • ENDDATE (Field6) — DATE
  • EMAIL (Field7) — VARCHAR2(30)
  • WID (Field8) — VARCHAR2(20)
  • WDATE (Field9) — DATE
  • LID (Field10) — VARCHAR2(20)
  • LDATE (Field11) — DATE
  • PASSWORD (Field12) — VARCHAR2(20)
  • PPICTURE (Field13) — VARCHAR2(50)

QnAAnswer (CopyOfCopyOfUntitled114)

  • ASEQ (Key) — NUMBER — Primary key — NOT NULL
  • PREGINUM (Key3) — VARCHAR2(20) — Foreign key → Professor.PREGINUM — NOT NULL — <교수직번 만드는 형식> 2+(입학년도2숫자)+(단대번호2숫자)+(학과전공2숫자)+(고유번호3숫자)
  • QSEQ (Key2) — NUMBER — Foreign key → QnAQuestion.QSEQ — NOT NULL
  • TITLE (Field2) — VARCHAR2(120)
  • CONTENTS (Field3) — VARCHAR2(3000)
  • INDATE (Field4) — DATE

QnAQuestion (CopyOfUntitled11)

  • QSEQ (Key) — NUMBER — Primary key — NOT NULL
  • LectureNum (Key2) — VARCHAR2(10) — Foreign key → lecture.LectureNum — NOT NULL
  • TITLE (Field2) — VARCHAR2(120)
  • CONTENTS (Field3) — VARCHAR2(3000)
  • INDATE (Field4) — DATE
  • COUNT (Field) — NUMBER(1)
  • SREGINUM (Field5) — VARCHAR2(20)

SCORE (Untitled27)

  • SCORE_SEQ (Key) — NUMBER — Primary key — NOT NULL
  • SMSeq (Key2) — NUMBER — Foreign key → StudentMember.SMSeq — NOT NULL
  • ASSIGNMENT1 (Field) — NUMBER(5)
  • ASSIGNMENT2 (Field2) — NUMBER(5)
  • SCORE1 (Field3) — NUMBER(5)
  • SCORE2 (Field4) — NUMBER(5)
  • ATTENDSCORE (Field5) — NUMBER(5)
  • ETCSCORE (Field6) — NUMBER(5)
  • TOTALSCORE (Field13) — NUMBER(10)
  • SCORE_GRADE (Field14) — VARCHAR2(4)
  • IsFinal (Field15) — VARCHAR2(2)

SCoreType_Seq (CopyOfUntitled272)

  • SCoreType_SEQ (Key) — NUMBER — Primary key — NOT NULL
  • ASSIGNMENT1_PCT (Field7) — NUMBER(5)
  • ASSIGNMENT2_PCT (Field8) — NUMBER(5)
  • SCORE1_PCT (Field9) — NUMBER(5)
  • SCORE2_PCT (Field10) — NUMBER(5)
  • ATTENDSCORE_PCT (Field11) — NUMBER(5)
  • ETCSCORE_PCT (Field12) — NUMBER(5)

SEMESTER (Untitled32)

  • SRSEQ (Key) — NUMBER — Primary key — NOT NULL
  • YEAR (Field) — NUMBER(4)
  • SEMESTER (Field2) — VARCHAR2(12)

SchoolEvents (Untitled25)

  • dateseq (Key) — NUMBER — Primary key — NOT NULL
  • STARTDATE (Field) — DATE
  • name (Field2) — VARCHAR2(90)
  • ENDDATE (Field3) — DATE
  • WId (Field4) — VARCHAR2(20)
  • WDATE (Field5) — DATE

SignUp (Untitled5)

  • SUSeq (Key) — NUMBER — Primary key — NOT NULL
  • SREGINUM (Key2) — VARCHAR2(20) — Foreign key → Student.SREGINUM — NOT NULL — <학번 만드는 형식> 1+(입학년도2숫자)+(단대번호2숫자)+(학과전공2숫자)+(고유번호3숫자)
  • LectureNum (Key4) — VARCHAR2(10) — Foreign key → lecture.LectureNum — NOT NULL
  • SRSEQ (Key3) — NUMBER — Foreign key → SEMESTER.SRSEQ — NOT NULL
  • INDATE (Field) — DATE
  • TIMESTAMP (Field2) — TIMESTAMP

Student (Untitled8)

  • SREGINUM (Key) — VARCHAR2(20) — Primary key — NOT NULL — <학번 만드는 형식> 1+(입학년도2숫자)+(단대번호2숫자)+(학과전공2숫자)+(고유번호3숫자)
  • ApplicantSeq (Key3) — NUMBER — Foreign key → Applicant.ApplicantSeq — NOT NULL
  • ENTERDATE (Field5) — DATE — NOT NULL
  • SEMESTER (Field7) — NUMBER(2) — NOT NULL — 학기
  • PASSWORD (Field9) — VARCHAR2(20)
  • IDATE (Field) — DATE
  • IADMIN (Field2) — VARCHAR2(20)
  • UDATE (Field3) — DATE
  • STATUSNUM (Key2) — NUMBER(3) — Foreign key → USERREASON.STATUSNUM — NOT NULL — <규칙> 세자리 숫자로 입력. -백의자리 수 100 재학 200 휴학 300 졸업 400 제적 500 자퇴(재입학 가능) 600 퇴학(재입학 안됨) 700 재직(교수, 교직원) 800 퇴직(교수, 교직원) 900…

StudentMajor (Untitled3)

  • SMSEQ (Key) — NUMBER — Primary key — NOT NULL
  • MajorSeq (Key3) — NUMBER — Foreign key → Major.MajorSeq — NOT NULL
  • SREGINUM (Key2) — VARCHAR2(20) — Foreign key → Student.SREGINUM — NOT NULL — <학번 만드는 형식> 1+(입학년도2숫자)+(단대번호2숫자)+(학과전공2숫자)+(고유번호3숫자)
  • INDATE (Field) — DATE
  • WID (Field2) — VARCHAR2(20)
  • TYPE (Field3) — VARCHAR2(1)

StudentMember (CopyOfUntitled52)

  • SMSeq (Key) — NUMBER — Primary key — NOT NULL
  • SUSeq (Key2) — NUMBER — Foreign key → SignUp.SUSeq — NOT NULL
  • LectureNum (Key3) — VARCHAR2(10) — Foreign key → lecture.LectureNum — NOT NULL
  • STATUS (Field4) — VARCHAR2(30)
  • ETC (Field3) — VARCHAR2(300)
  • SNAME (Field2) — VARCHAR2(60)
  • SREGINUM (Key22) — VARCHAR2(20) — Foreign key → SignUp.SREGINUM — NOT NULL — <학번 만드는 형식> 1+(입학년도2숫자)+(단대번호2숫자)+(학과전공2숫자)+(고유번호3숫자)

Student_Status_History (Untitled9)

  • SSSeq (Key) — NUMBER — Primary key — NOT NULL
  • SREGINUM (Key2) — VARCHAR2(20) — Foreign key → Student.SREGINUM — NOT NULL — <학번 만드는 형식> 1+(입학년도2숫자)+(단대번호2숫자)+(학과전공2숫자)+(고유번호3숫자)
  • STATUSNUM (Key3) — NUMBER(3) — Foreign key → USERREASON.STATUSNUM — NOT NULL — <규칙> 세자리 숫자로 입력. -백의자리 수 100 재학 200 휴학 300 졸업 400 제적 500 자퇴(재입학 가능) 600 퇴학(재입학 안됨) 700 재직(교수, 교직원) 800 퇴직(교수, 교직원) 900…
  • APPLY_DATE (Field) — DATE
  • STARTDATE (Field2) — DATE
  • ENDDATE (Field3) — DATE
  • AUT_ID (Field4) — VARCHAR2(20)
  • GRADE (Field5) — NUMBER(2)
  • MEMO (Field6) — VARCHAR2(3000)
  • AUTDATE (Field7) — DATE
  • ISAUTH (Field8) — VARCHAR2(2)

TYPE_CERTIFICATION (Untitled26)

  • typeNum (Key) — NUMBER(2) — Primary key — NOT NULL
  • NAME (Field) — VARCHAR2(90)

TYPE_SCHOLARSHIP (Untitled20)

  • TYPESEQ (Key) — NUMBER — Primary key — NOT NULL
  • TYPENAME (Field) — VARHCAR2(60)
  • SPONSER (Field2) — VARCHAR2(60)
  • INFO (Field3) — VARCHAR2(3000)

USERREASON (Untitled10)

  • STATUSNUM (Key) — NUMBER(3) — Primary key — NOT NULL — <규칙> 세자리 숫자로 입력. -백의자리 수 100 재학 200 휴학 300 졸업 400 제적 500 자퇴(재입학 가능) 600 퇴학(재입학 안됨) 700 재직(교수, 교직원) 800 퇴직(교수, 교직원) 900…
  • STATUSNAME (Field) — VARCHAR2(60)

assessment(교수평가) (CopyOfUntitled27)

  • ASS_SEQ (Key) — NUMBER — Primary key — NOT NULL
  • SMSeq (Key2) — NUMBER — Foreign key → StudentMember.SMSeq — NOT NULL
  • fidelity (Field) — NUMBER(5)
  • professionality (Field2) — NUMBER(5)
  • understanding (Field3) — NUMBER(5)
  • FIDLITY_REASON (Field4) — VARCHAR2(1500)
  • PROFESSION_REASON (Field5) — VARCHAR2(1500)
  • UNDERSTANDING_REASON (Field6) — VARCHAR2(1500)

certification (Untitled23)

  • Key — varchar2(30) — Primary key — NOT NULL
  • SREGINUM (Key2) — VARCHAR2(20) — Foreign key → Student.SREGINUM — NOT NULL — <학번 만드는 형식> 1+(입학년도2숫자)+(단대번호2숫자)+(학과전공2숫자)+(고유번호3숫자)
  • typeNum (Key3) — NUMBER(2) — Foreign key → TYPE_CERTIFICATION.typeNum — NOT NULL
  • indate (Field2) — DATE
  • File_Name (Field4) — VARCHAR2(600)
  • WDATE (Field5) — DATE

counsel (Untitled28)

  • COUNSEL_SEQ (Key) — NUMBER — Primary key — NOT NULL
  • PREGINUM (Key2) — VARCHAR2(20) — Foreign key → Professor.PREGINUM — NOT NULL — <교수직번 만드는 형식> 2+(입학년도2숫자)+(단대번호2숫자)+(학과전공2숫자)+(고유번호3숫자)
  • SREGINUM (Key4) — VARCHAR2(20) — Foreign key → Student.SREGINUM — NOT NULL — <학번 만드는 형식> 1+(입학년도2숫자)+(단대번호2숫자)+(학과전공2숫자)+(고유번호3숫자)
  • typeNum (Key3) — NUMBER(2) — Foreign key → CounselType.typeNum — NOT NULL
  • COUNDATE (Field) — DATE
  • MEMO (Field2) — VARCHAR2(3000)
  • IsCounsel (Field3) — VARCHAR2(1) — NOT NULL — A:상담신청 B:교수열람 C:상담왼료 F:상담취소 --반드시 대문자--
  • ENDDATE (Field4) — DATE
  • Key (Field5) — VARCHAR2(300)
  • WDATE (Field6) — DATE

course (Untitled22)

  • courseSeq (Key) — NUMBER — Primary key — NOT NULL
  • LectureNum (Key2) — VARCHAR2(10) — Foreign key → lecture.LectureNum — NOT NULL
  • TITLE (Field) — VARCHAR2(60) — 기본적으로 강의계획서에 있는 커리큘럼을 기본값으로 보여주고, 수정할 경우 UPDATE 수행.
  • FILE_NAME (Field3) — VARCHAR2(300)
  • ORG_NAME (Field2) — VARCHAR2(300)
  • STARTDATE (Field4) — DATE
  • ENDDATE (Field5) — DATE
  • ATIME (Field6) — NUMBER(10)
  • WID (Field7) — VARCHAR2(20)
  • WDATE (Field8) — DATE
  • courseNUM (Field9) — number(2)

courseFile (Untitled12)

  • CFSeq (Key) — NUMBER — Primary key — NOT NULL
  • courseSeq (Key2) — NUMBER — Foreign key → course.courseSeq — NOT NULL
  • FileContents (Field) — VARCHAR2(4000)
  • INDATE (Field2) — DATE

lecture (Untitled4)

  • LectureNum (Key) — VARCHAR2(10) — Primary key — NOT NULL
  • MPSEQ (Key22) — NUMBER — Foreign key → Major_Professor.MPSEQ — NOT NULL
  • SRSEQ (Key3) — NUMBER — Foreign key → SEMESTER.SRSEQ — NOT NULL
  • MCSeq (Key2) — NUMBER — Foreign key → Major_curriculum.MCSeq — 전공 커리큘럼에 있는 데이터의 경우 연계해준다. Null의 경우 전공 커리큘럼에 없는 정보
  • SCoreType_SEQ (Key4) — NUMBER — Foreign key → SCoreType_Seq.SCoreType_SEQ — NOT NULL
  • NAME (Field) — VARCHAR2(90)
  • occupancy (Field2) — VARCHAR2(5)
  • CONTENTS (Field3) — VARCHAR2(3000)
  • GRADE (Field4) — NUMBER
  • Is_real_Time (Field5) — varchar2(1)
  • DIVIDE (Field6) — varchar2(2)
  • CREDIT (Field7) — NUMBER(3)
  • note (Field12) — VARCHAR2(4000)
  • IsPermitted (Field13) — VARCHAR2(1)
  • FILENAME (Field8) — VARCHAR2(300)
  • TYPENUM (Key5) — NUMBER(2) — Foreign key → LECTURETYPE.TYPENUM — NOT NULL

lectureTime (Untitled13)

  • LTSeq (Key) — NUMBER — Primary key — NOT NULL
  • LectureNum (Key2) — VARCHAR2(10) — Foreign key → lecture.LectureNum — NOT NULL
  • STARTTIME (Field) — DATE
  • ENDTIME (Field2) — DATE
  • DAY (Field3) — VARCHAR2(3)

scholarship (Untitled17)

  • scSeq (Key) — NUMBER — Primary key — NOT NULL
  • TYPESEQ (Key2) — VARCHAR2(2) — Foreign key → TYPE_SCHOLARSHIP.TYPESEQ — NOT NULL
  • SREGINUM (Key3) — VARCHAR2(20) — Foreign key → Student.SREGINUM — NOT NULL — <학번 만드는 형식> 1+(입학년도2숫자)+(단대번호2숫자)+(학과전공2숫자)+(고유번호3숫자)
  • ENSEQ (Key4) — NUMBER — Foreign key → BILL.ENSEQ — NOT NULL
  • SCHOLARSHIP (Field2) — NUMBER(10)
  • MEMO (Field) — VARCHAR2(1500)
  • INDATE (Field4) — DATE
  • WID (Field3) — VARCHAR2(20)

totNotice (CopyOfUntitled112)

  • NOTICESEQ (Key) — NUMBER — Primary key — NOT NULL
  • WRITER (Field) — VARCHAR2(60)
  • TITLE (Field2) — VARCHAR2(120)
  • CONTENTS (Field3) — VARCHAR2(3000)
  • INDATE (Field4) — DATE
  • LDATE (Field5) — DATE
  • LID (Field6) — VARCHAR2(60)