CB_TB

Code Bakery

테이블 (11)

공지댓글 (NOTICE_COMMENT)

  • PRIMARY KEY (NCOMMNET_NO) — NUMBER — 기본 키 — NOT NULL
  • FOREIGN KEY (NOTICE_NO) — NUMBER — 외래 키 → 공지사항.PRIMARY KEY — NOT NULL
  • (NCOMMENT_CONTENT) — VARCHAR2(300) — NOT NULL
  • (NCOMMENT_DATE) — DATE — NOT NULL
  • FOREIGN KEY (USER_ID) — VARCHAR2(20) — 외래 키 → 유저.PRIMARY KEY — NOT NULL

공지사항 (NOTICE)

  • PRIMARY KEY (NOTICE_NO) — NUMBER — 기본 키 — NOT NULL
  • (NOTICE_TITLE) — VARCHAR2(50) — NOT NULL
  • (NOTICE_CONTENT) — VARCHAR2(2000) — NOT NULL
  • (NOTICE_DATE) — DATE — NOT NULL
  • (NOTICE_VIEWS) — NUMBER — NOT NULL
  • (USER_ID) — VARCHAR2(50) — NOT NULL

답변 (ANSWER)

  • PRIMARY KEY (ANSWER_NO) — NUMBER — 기본 키 — NOT NULL
  • (ANSWER_TITLE) — VARCHAR2(500) — NOT NULL
  • (ANSWER_CONTENT) — VARCHAR2(2000) — NOT NULL
  • (ANSWER_DATE) — DATE — NOT NULL
  • FOREIGN KEY (QUESTION_NO) — NUMBER — 외래 키 → 질문게시판.PRIMARY KEY — NOT NULL
  • (USER_ID) — VARCHAR2(50) — NOT NULL

멘토리뷰 (MENTOR_REVIEW)

  • PRIMARY KEY (REVIEW_NO) — NUMBER — 기본 키 — NOT NULL
  • (REVIEW_CONTENT) — VARCHAR2(2000) — NOT NULL
  • (REVIEW_DATE) — DATE — NOT NULL
  • FOREIGN KEY (USER_ID) — VARCHAR2(20) — 외래 키 → 유저.PRIMARY KEY — NOT NULL
  • FOREIGN KEY (MENTOR_NO) — NUMBER — 외래 키 → 멘토소개.PRIMARY KEY — NOT NULL

멘토소개 (MENTOR_INTRO)

  • PRIMARY KEY (MENTOR_NO) — NUMBER — 기본 키 — NOT NULL
  • (MENTOR_CAREER) — VARCHAR2(1000) — NOT NULL
  • (MENTOR_CONTENT) — VARCHAR2(2000) — NOT NULL
  • FOREIGN KEY (USER_ID) — VARCHAR2(20) — 외래 키 → 유저.PRIMARY KEY — NOT NULL

문제게시판 (QUIZ)

  • PRIMARY KEY (QUIZ_NO) — NUMBER — 기본 키 — NOT NULL
  • (QUIZ_TITLE) — VARCHAR2(50) — NOT NULL
  • (QUIZ_CONTENT) — VARCHAR2(4000) — NOT NULL
  • (QUIZ_DATE) — DATE — NOT NULL
  • (CORRECT_USER) — NUMBER
  • (TRY_USER) — NUMBER
  • (CORRECT_RATE) — NUMBER
  • (QUIZ_VIEWS) — NUMBER
  • FOREIGN KEY (USER_ID) — VARCHAR2(20) — 외래 키 → 유저.PRIMARY KEY — NOT NULL
  • (INPUT_EXPLANATION) — VARCHAR2(4000)
  • (OUTPUT_EXPLANATION) — VAHRCHAR2(4000)
  • (INPUT_SAMLPLE) — VARCHAR2(4000)
  • (OUTPUB_SAMPLE) — VARCHAR2(4000)

유저 (USER_TB)

  • PRIMARY KEY (USER_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • (USER_PW) — VARCHAR2(50) — NOT NULL
  • (USER_GRADE) — VARCHAR2(20) — NOT NULL
  • (USER_NAME) — VARCHAR2(20) — NOT NULL
  • (USER_PHONE) — VARCHAR2(100) — NOT NULL
  • (USER_MAIL) — VARCHAR2(100) — NOT NULL
  • (USER_POINT) — NUMBER
  • (USER_PIC) — VARCHAR2(100)
  • (USER_LANG) — VARCHAR2(200) — NOT NULL

질문게시판 (QUESTION)

  • PRIMARY KEY (QUESTION_NO) — NUMBER — 기본 키 — NOT NULL
  • (QUESTION_TITLE) — VARCHAR2(500) — NOT NULL
  • (QUESTION_CONTENT) — VARCHAR2(2000) — NOT NULL
  • (QUESTION_DATE) — DATE — NOT NULL
  • (QUSTION_VIEWS) — NUMBER — NOT NULL
  • (QUSTION_TAG) — VARCHAR2(100)
  • FOREIGN KEY (USER_ID) — VARCHAR2(20) — 외래 키 → 유저.PRIMARY KEY — NOT NULL

질문댓글 (QNA_COMMENT)

  • PRIMARY KEY (QCOMMENT_NO) — NUMBER — 기본 키 — NOT NULL
  • FOREIGN KEY (QUESTION_NO) — NUMBER — 외래 키 → 질문게시판.PRIMARY KEY — NOT NULL
  • (QCOMMENT_CONTENT) — VARCHAR2(1000) — NOT NULL
  • (QCOMMENT_DATE) — DATE — NOT NULL
  • (GROUP_ID) — NUMBER
  • (PARENT_NO) — NUMBER(10)
  • (DEPTH) — NUMBER(10)
  • (USER_ID) — VARCHAR2(20) — NOT NULL
  • (USER_PIC) — VARCHAR(100) — NOT NULL

채점결과 (QUIZ_RESULT)

  • PRIMARY KEY (USER_ID) — VARCHAR2(50) — 외래 키 → 유저.PRIMARY KEY — NOT NULL
  • PRIMARY KEY (QUIZ_NO) — NUMBER — 외래 키 → 문제게시판.PRIMARY KEY — NOT NULL
  • (CODE_CONTENT) — VARCHAR2(4000) — NOT NULL
  • (EX_RESULT) — VARCHAR2(300) — NOT NULL
  • (PRINT_RESULT) — VARCHAR2(300) — NOT NULL
  • (QUIZ_RESULT) — VARCHAR2(20)

포인트사용내역 (POINT_TB)

  • PRIMARY KEY (POINT_NO) — NUMBER — 기본 키 — NOT NULL
  • (POINT_DATE) — DATE
  • (POINT_CHARGE) — VARCHAR2(50)
  • (POINT_USE) — VARCHAR2(50)
  • (POINT_HISTORY) — VARCHAR2(100)
  • PRIMARY KEY (USER_ID) — VARCHAR2(50) — 외래 키 → 유저.PRIMARY KEY — NOT NULL