srvy

Tables (7)

T_QSTN_OPT (문항아이템테이블)

  • QSTN_OPT_ID (Key) — NUMBER — Primary key — NOT NULL
  • SRVY_QSTN_ID (Key2) — NUMBER — Foreign key → T_SRVY_QSTN.SRVY_QSTN_ID — NOT NULL
  • OPT_ORDR (Field2) — NUMBER
  • OPT_CN (Field3) — VARCHAR2 — NOT NULL
  • OPT_ATCH_FILE_ID (Field) — VARCHAR2

T_RES_DET (응답상세테이블)

  • RES_DET_ID (Key) — NUMBER — Primary key — NOT NULL
  • SRVY_RES_ID (Key2) — NUMBER — Foreign key → T_SRVY_RES.SRVY_RES_ID — NOT NULL
  • SRVY_QSTN_ID (Key3) — NUMBER — Foreign key → T_SRVY_QSTN.SRVY_QSTN_ID — NOT NULL
  • QSTN_OPT_ID (Key4) — NUMBER — Foreign key → T_QSTN_OPT.QSTN_OPT_ID
  • DET_CN (Field4) — VARCHAR2

T_SRVY (설문테이블)

  • SRVY_ID (Key) — NUMBER — Primary key — NOT NULL
  • SRVY_TITLE (Field) — VARCHAR2 — NOT NULL
  • SRVY_CN (Field2) — VARCHAR2
  • START_DATE (Field3) — DATE — NOT NULL
  • END_DATE (Field4) — DATE — NOT NULL
  • POST_YN (Field5) — CHAR — NOT NULL
  • STATUS_CD (Field6) — VARCHAR2
  • REG_NM (Field7) — VARCHAR2 — NOT NULL
  • REG_DATE (Field8) — DATE
  • UPD_DATE (Field9) — DATE
  • USE_YN (Field10) — CHAR — NOT NULL

T_SRVY_MEDIA (첨부파일테이블)

  • MEDIA_ID (Key) — NUMBER — Primary key — NOT NULL
  • TARGET_TYPE (Filed) — VARCHAR2 — NOT NULL
  • TARGET_ID (Filed2) — NUMBER — NOT NULL
  • FILE_PATH (Field) — VARCHAR2
  • FILE_NM (Field4) — VARCHAR2
  • FILE_EXT (Field2) — VARCHAR2
  • FILE_SIZE (Field3) — NUMBER
  • USE_YN (Field5) — CHAR
  • REG_DATE (Field6) — DATE

T_SRVY_QSTN (문항테이블)

  • SRVY_QSTN_ID (Key) — NUMBER — Primary key — NOT NULL
  • SRVY_ID (Key2) — NUMBER — Foreign key → T_SRVY.SRVY_ID — NOT NULL
  • QSTN_ORDR (Field2) — NUMBER
  • QSTN_TITLE (Field3) — VARCHAR2 — NOT NULL
  • QSTN_CN (Field4) — VARCHAR2 — NOT NULL
  • QSTN_TYPE (Field5) — VARCHAR2 — NOT NULL
  • REQ_YN (Field6) — CHAR — NOT NULL
  • MAX_SEL (Field7) — NUMBER
  • MAX_SCORE (Field) — NUMBER

T_SRVY_RES (응답테이블)

  • SRVY_RES_ID (Key) — NUMBER — Primary key — NOT NULL
  • SRVY_ID (Key2) — NUMBER — Foreign key → T_SRVY.SRVY_ID — NOT NULL
  • USER_ID_PK (Key3) — NUMBER — Foreign key → T_USER.USER_ID_PK — NOT NULL
  • SBMT_DATE (Field3) — DATE
  • USE_YN (Field4) — CHAR — NOT NULL

T_USER (사용자테이블)

  • USER_ID_PK (Key) — NUMBER — Primary key — NOT NULL
  • USER_ID (Field) — VARCHAR2 — NOT NULL
  • PASSWORD (Field2) — VARCHAR2 — NOT NULL
  • USER_NM (Field3) — VARCHAR2 — NOT NULL