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)