test
Tables (6)
TB_MEMBER
- MEMBER_IDX — NUMBER
- LOGIN_ID — VARCHAR2(100) — NOT NULL
- PASSWORD — VARCHAR2(100) — NOT NULL
TB_SURVEY
- SURVEY_ID — NUMBER
- TITLE — VARCHAR2(200) — NOT NULL
- START_DATE — VARCHAR2(20)
- END_DATE — VARCHAR2(20)
TB_SURVEY_ANSWER
- ANSWER_ID — NUMBER
- RESPONSE_ID — NUMBER — NOT NULL
- SURVEY_ID — NUMBER — NOT NULL
- QUESTION_ID — NUMBER — NOT NULL
- OPTION_ID — NUMBER
- ANSWER_TEXT — VARCHAR2(1000)
- MEMBER_IDX — NUMBER
- GUEST_TOKEN — VARCHAR2(100)
TB_SURVEY_OPTION
- OPTION_ID — NUMBER
- QUESTION_ID — NUMBER — NOT NULL
- OPTION_TEXT — VARCHAR2(500)
- IS_ETC — CHAR(1)
TB_SURVEY_QUESTION
- QUESTION_ID — NUMBER
- SURVEY_ID — NUMBER — NOT NULL
- QUESTION_NO — NUMBER — NOT NULL
- QUESTION_TEXT — VARCHAR2(1000)
- IS_REQUIRED — CHAR(1)
- ALLOW_MULTIPLE — NUMBER
- IS_EXCLUSIVE — CHAR(1)
- CATEGORY — VARCHAR2(100)
- PARENT_QUESTION_ID — NUMBER
- TB_SURVEY_QUESTION — TB_SURVEY_QUESTION
TB_SURVEY_RESPONSE
- RESPONSE_ID — NUMBER
- SURVEY_ID — NUMBER — NOT NULL
- MEMBER_IDX — NUMBER
- GUEST_TOKEN — VARCHAR2(100)