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