survey

Tables (4)

SURVEY (설문조사)

  • SN (pk) — Long — Primary key — NOT NULL
  • EVENT_SN (fk) — Long
  • SURVEY_TITLE (Field) — String
  • SURVEY_DSCR (Field3)
  • REG_DTTM (Field2) — datetime

SURVEY_QUESTION (CopyOfUntitled)

  • SN (pk) — Long — Primary key — NOT NULL
  • SURVEY_SN (fk) — Long
  • QUESTION_TEXT (Field) — String
  • ORDER_NUM (Field2) — Integer
  • MULTI_YN (Field4) — Char

SURVEY_RESPONSE (Untitled)

  • SN (pk) — Long — Primary key — NOT NULL
  • QUESTION_SN (fk) — Long
  • RESPONSE_TEXT (Field) — String
  • ORDER_NUM (Field2) — Integer

SURVEY_USER_RESPONSE (CopyOfUntitled2)

  • SN (pk) — Long — Primary key — NOT NULL
  • USER_ID (Field2) — String
  • QUESTION_SN (field) — Long
  • RESPONSE_SN (Field) — String
  • RESPONSE_DTTM (Field3)
  • Field4