4주차 과제

테이블 (6)

TB_MEMBER

  • MEMBER_IDX — NUMBER(38)
  • MEMBER_LOGIN_ID — VARCHAR2(50) — NOT NULL
  • MEMBER_PW — VARCHAR2(50) — NOT NULL

TB_SURVEY

  • SURVEY_ID — NUMBER
  • TITLE — VARCHAR2(200) — NOT NULL
  • START_DATE — DATE — NOT NULL
  • END_DATE — DATE — NOT NULL
  • REG_DATE — DATE
  • STATUS — CHAR(1)

TB_SURVEY_ANSWER

  • ANSWER_ID — NUMBER — 기본 키 — NOT NULL
  • RESPONSE_ID — NUMBER — 외래 키 → TB_SURVEY_RESPONSE.RESPONSE_ID — NOT NULL
  • QUESTION_ID — NUMBER — 외래 키 → TB_SURVEY_QUESTION.QUESTION_ID — NOT NULL
  • OPTION_ID — NUMBER — 외래 키 → TB_SURVEY_OPTION.OPTION_ID
  • ANSWER_TEXT — VARCHAR2(1000) — 기타

TB_SURVEY_OPTION

  • OPTION_ID — NUMBER — 기본 키 — NOT NULL
  • QUESTION_ID — NUMBER — 외래 키 → TB_SURVEY_QUESTION.QUESTION_ID — NOT NULL
  • OPTION_TEXT — VARCHAR2(500) — NOT NULL
  • IS_EXCLUSIVE — CHAR(1) — Y인
  • IS_ETC — CHAR(1) — Y인

TB_SURVEY_QUESTION

  • QUESTION_ID — NUMBER — 기본 키 — NOT NULL — 문항
  • SURVEY_ID — NUMBER — 외래 키 → TB_SURVEY.SURVEY_ID — NOT NULL — 설문조사
  • QUESTION_NO — NUMBER — NOT NULL — 문항
  • CATEGORY — VARCHAR2(50)
  • QUESTION_TEXT — VARCHAR2(1000) — NOT NULL
  • IS_REQUIRED — CHAR(1)
  • N)) — NOT — NOT NULL

TB_SURVEY_RESPONSE

  • RESPONSE_ID — NUMBER
  • SURVEY_ID — NUMBER — 외래 키 → TB_SURVEY.SURVEY_ID — NOT NULL — 어떤
  • MEMBER_IDX — NUMBER(38) — 외래 키 → TB_MEMBER.MEMBER_IDX — NOT NULL — 응답자
  • RESPONSE_DATE — DATE