Event Survey ERD

테이블 (10)

서베이 결제 정보 (SurveyPaymentInfo)

  • Survey Response Sequence (sr_seq) — int(11) — 외래 키 → 서베이 응답.Survey Response Sequence — NOT NULL
  • Survey Payment Method (payment_method) — varchar(50) — NOT NULL
  • Survey Payment Card Number (card_number) — char(4)
  • Survey Payment Card Owner (owner_name) — varchar(50)
  • Survey Payment Card Birth Date (birth_date) — char(6)
  • Survey Payment Card Password (password) — char(2)
  • Survey Payment Card Installment (installment) — varchar(2)
  • Survey Payment Info Creation Time (creation_time) — datetime — NOT NULL
  • Survey Payment Info Modification Time (modification_time) — datetime — NOT NULL

서베이 마스터 (Survey)

  • Survey Code (s_code) — varchar(10) — 기본 키 — NOT NULL
  • Survey Wave Number (wave_number) — int(2) — 기본 키
  • Survey Title (title) — varchar(100) — NOT NULL
  • Survey Open Date (open_date) — datetime
  • Survey Due Date (due_date) — datetime
  • Survey Wave Start Date (start_date) — datetime
  • Survey Wave End Date (end_date) — datetime
  • Survey Pin (pin) — varchar(10)
  • Survey Creation TIme (creation_time) — datetime — NOT NULL

서베이 선택지 (SurveyExample)

  • Survey Example Code (se_code) — varchar(10) — 기본 키 — NOT NULL
  • Survey Question Code (sq_code) — varchar(10) — 외래 키 → 서베이 질문.Survey Question Code — NOT NULL
  • Survey Example Value (value) — varchar(100) — NOT NULL
  • Survey Example Display Text (display_text) — varchar(100) — NOT NULL
  • Survey Example Pin (pin) — varchar(10) — NOT NULL — 없음: "N" PT이상: "P" 다이아몬드이상: "Y"
  • Survey Example Sequence (sequence) — int(2)
  • Survey Example Creation Time (creation_time) — datetime

서베이 약관 (SurveyConsent)

  • Consent Code (c_code) — varchar(10) — 기본 키 — NOT NULL
  • Survey Code (s_code) — varchar(10) — 외래 키 → 서베이 마스터.Survey Code — NOT NULL
  • Consent Title (title) — varchar(100) — NOT NULL
  • Consent Description (description) — longtext — NOT NULL
  • Consent Required (required) — tinyint(1) — NOT NULL
  • Consent Creation Time (creation_time) — datetime — NOT NULL

서베이 약관 응답 (SurveyConsentReponse)

  • Survey Response Sequence (sr_seq) — int(11) — 외래 키 → 서베이 응답.Survey Response Sequence — NOT NULL
  • Consent Code (c_code) — varchar(10) — 외래 키 → 서베이 약관.Consent Code — NOT NULL
  • Survey Consent Reponse Agreement (agree_yn) — char(1) — NOT NULL
  • Survey Consent Reponse Date (res_date) — datetime — NOT NULL
  • Survey Consent Response Creation Time (creation_time) — datetime — NOT NULL

서베이 응답 (SurveyResponse)

  • Survey Response Sequence (sr_seq) — int(11) — 기본 키 — NOT NULL
  • Survey Code (s_code) — varchar(10) — 외래 키 → 서베이 마스터.Survey Code — NOT NULL
  • Survey Wave Number (wave_number) — int(2) — 외래 키 → 서베이 마스터.Survey Wave Number
  • Survey Response Abo Uid (abo_uid) — varchar(20) — NOT NULL
  • Survey Response Name (name) — varchar(20) — NOT NULL
  • Survey Response Type (type) — char(1) — NOT NULL — 단독사업자 : "E" 공동사업자 : "P" 배우자 : "S" 가족 : "F"
  • Survey Response Type Sequence (type_seq) — int(2)
  • Survey Response Attendance (attendance_yn) — char(1) — NOT NULL
  • Survey Response Creation Time (creation_time) — datetime
  • Survey Response Modification Time (modification_time) — datetime

서베이 응답 기록 (SurveyResponseHistory)

  • Survey Response History Sequence (srh_seq) — int(11) — 기본 키 — NOT NULL
  • Survey Response History ABO UID (abo_uid) — varchar(20) — NOT NULL
  • Survey Response History name (name) — varchar(20) — NOT NULL
  • Survey Response History Type (type) — char(1) — NOT NULL — 단독사업자 : "E" 공동사업자 : "P" 배우자 : "S" 가족 : "F"
  • Survey Response History Type Sequence (type_seq) — int(2)
  • Survey Response History Question Code (sq_title) — varchar(100) — NOT NULL
  • Survey Response History Response Data (res_value) — varchar(100) — NOT NULL
  • Survey Response History Creation Time (creation_time) — datetime — NOT NULL

서베이 응답 데이터 (SurveyResponseData)

  • Survey Response Data Sequence (srd_seq) — int(11) — 기본 키 — NOT NULL
  • Survey Response Sequence (sr_seq) — int(11) — 외래 키 → 서베이 응답.Survey Response Sequence — NOT NULL
  • Survey Question Code (sq_code) — varchar(10) — 외래 키 → 서베이 질문.Survey Question Code — NOT NULL
  • Survey Example Code (se_code) — varchar(10) — 외래 키 → 서베이 선택지.Survey Example Code
  • Survey Example Count (se_count) — int(2)
  • Survey Response Data Raw Data (raw_data) — varchar(100)
  • Survey Attachment Path (path) — varchar(100)
  • Survey Attachment Original Name (original_name) — varchar(100)
  • Survey Response Data Note (note) — varchar(100)
  • Survey Response Data Creation Time (creation_time) — datetime — NOT NULL
  • Survey Response Data Modification Time (modification_time) — datetime

서베이 잔여 인원 (SurveyRemainingCount)

  • Survey Code (s_code) — varchar(10) — 외래 키 → 서베이 마스터.Survey Code — NOT NULL
  • Survey Wave Number (wave_number) — int(2) — 외래 키 → 서베이 마스터.Survey Wave Number
  • Survey Example Code (se_code) — varchar(10) — 외래 키 → 서베이 선택지.Survey Example Code — NOT NULL
  • Survey Remain People Count (count) — int(4) — NOT NULL
  • Survey Remain Count Modification Time (modification_time) — datetime

서베이 질문 (SurveyQuestion)

  • Survey Question Code (sq_code) — varchar(10) — 기본 키 — NOT NULL
  • Survey Code (s_code) — varchar(10) — 외래 키 → 서베이 마스터.Survey Code — NOT NULL
  • Survey Question Title (title) — varchar(100) — NOT NULL
  • Survey Question Area (area) — char(1) — NOT NULL — Info : "I" Question : "Q"
  • Survey Question Type (type) — char(1) — NOT NULL — 객관식: "A" 주관식: "B" 파일첨부: "F"
  • Survey Question Required (required) — tinyint(1) — NOT NULL
  • Survey Question Pin (pin) — varchar(10) — NOT NULL — 없음: "N" PT이상: "P" 다이아몬드이상: "Y"
  • Survey Question Response Type (res_type) — char(1)
  • Survey Question Sequence (sequence) — int(2)
  • Survey Question Alert Text (alert_text) — text
  • Survey Question Creation Time (creation_time) — datetime