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)