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