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