pinsight

Tables (8)

ADMIN_CodeMaster (코드마스터)

  • 메인코드 (Main_code) — varchar(50) — Primary key — NOT NULL — install_APP
  • 서브코드 (sub_code) — varchar(50) — Primary key — NOT NULL — survey1
  • 코드이름 (code_name) — varchar(255) — https://sv2.esurvey.kr/m/?p=P030660151
  • 코드크기 (code_size) — int — 2210456
  • 코드설명1 (ref_code1) — varchar(40) — 라이프스타일 기초 설문
  • 코드설명2 (ref_code2) — varchar(40) — 라이프스타일 기초 설문입니다
  • 코드설명3 (ref_code3) — varchar(40) — 설문 참여하기
  • 순서 (order_by) — int — 1
  • 사용여부 (use_YN) — varchar(2) — Y

ADMIN_FAQ (기본 질문 및 답변)

  • 타입 (strListType) — varchar(10) — Primary key — NOT NULL — A
  • 고유키 (intSeq) — int — Primary key — NOT NULL — 1
  • 질문 (strQuestion) — text — NOT NULL — IBP 패널은 어떻게 가입 할 수 있나요?
  • 답변 (strAnswer) — text — NOT NULL — 패널회원은 일반패널과 IBP패널로 구분됩니다....
  • 등록날짜 (dateRegDate) — datetime — NOT NULL — 2021-03-03 13:22:58.943
  • 사용여부 (use_YN) — varchar(2) — NOT NULL — Y

MEMBER_JOIN (설문진입)

  • 고유키 (intIndex) — int — NOT NULL — 20735121
  • intNum — int — NOT NULL — 457900
  • 프로젝트ID (strProjectID) — char(10) — NOT NULL — PP22305037
  • 패널ID (strLoginID) — varchar(20) — skdud1788
  • 진입일시 (dateJoining) — smalldatetime — 2023-07-25 14:25:00
  • 진입타입 (chrJoinType) — char(1) — E
  • 저장타입 (chrSaveType) — char(1) — 2
  • dateSaving — smalldatetime
  • 지급포인트 (intPoint) — int — 50
  • strGift — varchar(255)
  • 설문번호 (surveyID) — varchar(20) — PP22305037

MEMBER_POINT_ADD (포인트지급)

  • 고유키 (intIndex) — int — NOT NULL — 14517691
  • intNum — int — NOT NULL — 345623
  • 프로젝트ID (strProjectID) — char(10) — NOT NULL — PM22307017
  • 패널ID (strLoginID) — varchar(20) — fubu008
  • 진입일시 (dateJoining) — smalldatetime — 2023-07-25 14:33:00
  • 지급포인트 (intPoint) — int — NOT NULL — 50
  • 중복여부 (iDup_flag) — int — NOT NULL — 0
  • 설문번호 (surveyID) — varchar(20) — PM22307013

MEMBER_POINT_DEL (포인트차감)

  • 고유키 (intIndex) — int — Primary key — NOT NULL — 736035
  • intNum — int — NOT NULL — 59975
  • 패널ID (strLoginID) — varchar(20) — ahdmswn
  • 요청일시 (dateRequest) — smalldatetime — 2023-07-25 14:35:00
  • 차감포인트 (intPoint) — int — 5000
  • dateExpect — smalldatetime
  • dateAccept — smalldatetime
  • strProcessType — char(1) — NOT NULL — 1
  • strRequestType — char(1) — NOT NULL — 1

MPLUS_BOARD (문의게시판)

  • 게시판ID (strBoardID) — varchar(20) — Primary key — NOT NULL — MYQNA
  • intIndex — smallint — Primary key — NOT NULL — 26
  • intThread — int — Primary key — NOT NULL — 1277800
  • 고유키 (intSeq) — int — NOT NULL — 14055
  • intDepth — tinyint — NOT NULL — 0
  • 패널ID (strLoginID) — varchar(20) — NOT NULL — xhaksla0704
  • intCategory — tinyint — NOT NULL — 0
  • 패널이름 (strName) — varchar(20) — NOT NULL
  • 비밀번호 (strPassword) — varchar(20) — 김아람
  • 이메일 (strEmail) — varchar(64)
  • Field8 (strHomepage) — varchar(64)
  • 문의제목 (strSubject) — varchar(200) — NOT NULL — 성본변경
  • 문의내용 (strContent) — text — NOT NULL — 신청은 탈퇴를 하고 재가입을 해야하나요?ㅠㅠ
  • strSmallSubject — varchar(200)
  • strSmallContent — text
  • strLink1 — varchar(512)
  • strLink2 — varchar(512)
  • strBoardBg — varchar(64)
  • IP주소 (strIpAddr) — varchar(15) — 112.147.210.227
  • bitDelete — bit — NOT NULL — 0
  • bitCheck — bit — 1
  • bitHtml — bit — NOT NULL — 0
  • bitHtmlBr — bit — NOT NULL — 0
  • bitText — bit — NOT NULL — 0
  • bitNotice — bit — NOT NULL — 0
  • bitReMail — bit — NOT NULL — 0
  • bitSecret — bit — NOT NULL — 0
  • 패널ID (strSecretID) — varchar(20) — xhaksla0704
  • bitBad — bit — NOT NULL — 0
  • intRead — int — NOT NULL — 0
  • intVote — int — NOT NULL — 0
  • 답변여부 (intComment) — int — NOT NULL — 1
  • intFileCount — tinyint — NOT NULL — 0
  • strFileCode — varchar(13) — NOT NULL — 0000000000001
  • strFileName1 — varchar(64)
  • intFileSize1 — int — NOT NULL — 0
  • strFileDown1 — int — NOT NULL — 0
  • strFileName2 — varchar(64)
  • intFileSize2 — int — NOT NULL — 0
  • strFileDown2 — int — NOT NULL — 0
  • dateCmtDate — datetime
  • 등록일시 (dateRegDate) — datetime — NOT NULL — 2023-07-25 14:02:46.890

MPLUS_BOARD_COMMENT (문의게시판 답변)

  • 게시판ID (strBoardID) — varchar(20) — Primary key — NOT NULL — MYQNA
  • intIndex (intThread) — int — Primary key — NOT NULL — 1277800
  • 고유키 (intSeq) — int — Primary key — NOT NULL — 21109
  • intScore — tinyint — NOT NULL — 0
  • intIcon — tinyint — NOT NULL — 0
  • 답변ID (strLoginID) — varchar(20) — NOT NULL — admin
  • 답변이름 (strName) — varchar(20) — 인바이트
  • strPassword — varchar(20)
  • bitDelete — bit — NOT NULL — 0
  • 답변내용 (strContent) — text — NOT NULL — 안녕하세요. 인바이트입니다....
  • IP주소 (strIpAddr) — varchar(15) — NOT NULL — 222.106.218.180
  • 등록일시 (dateRegDate) — datetime — NOT NULL — 2023-07-25 14:42:03.927
  • 답변확인여부 (comment_read) — int — NOT NULL — 0

MPLUS_MEMBER_LIST (회원정보)

  • 패널ID (strLoginID) — varchar(20) — Primary key — NOT NULL — 458914
  • 고유키 (intNum) — int — NOT NULL — qmfnr45
  • strGroup — char(4) — NOT NULL — G001
  • 이름 (strLoginName) — varchar(20) — NOT NULL — 이솔범
  • 이메일 (strEmail) — varchar(64) — NOT NULL — [email protected]
  • bitMailing — bit — NOT NULL — 0
  • 생일 (strBirthday) — varchar(9) — 200208081
  • strNick — varchar(20)
  • strIcq — varchar(32)
  • strMsn — varchar(64)
  • strHomepage — varchar(64)
  • 우편번호 (strHomePost) — char(6) — 22781
  • 주소1 (strHomeAddr1) — varchar(100) — 인천 서구 새오개로54번안길 21
  • 주소2 (strHomeAddr2) — varchar(200)
  • strHomeTel — varchar(14)
  • 핸드폰번호 (strMobile) — varchar(13) — 010-6540-3365
  • strCompPost — char(6)
  • strCompAddr1 — varchar(100)
  • strCompAddr2 — varchar(200)
  • strCompTel — varchar(14)
  • strJob — varchar(100)
  • strJobLevel — varchar(32)
  • strHobby — varchar(32)
  • strMarry — varchar(9)
  • 성별 (strJoinMemo) — varchar(32) — 남
  • strPhotoFile — varchar(64)
  • strNameFile — varchar(64)
  • strMemo — varchar(1000)
  • bitUserInfo — bit — NOT NULL — 0
  • strRecLoginID — varchar(20)
  • strMemberAdd1 — varchar(50)
  • strMemberAdd2 — varchar(50)
  • strMemberAdd3 — varchar(50)
  • strMemberAdd4 — varchar(50)
  • strMemberAdd6 — varchar(50)
  • strMemberAdd7 — varchar(50)
  • strMemberAdd8 — varchar(50)
  • strMemberAdd9 — varchar(50) — 2
  • strMemberAdd10 — varchar(50) — 2023.07.25
  • bitAuth — bit — 1
  • intVisit — int — NOT NULL — 0
  • intPoint — smallmoney — NOT NULL — 0.00
  • intBoardCount — smallint — 0
  • intCommentCount — smallint — 0
  • intVote — smallint — 0
  • strAdmin — char(1) — 0
  • dateSignDate — smalldatetime
  • strSignIP — varchar(15)
  • bitSecession — bit — NOT NULL — 0
  • strSecessionMemo — text
  • dateSecessionDate — smalldatetime
  • 가입일시 (dateRegDate) — smalldatetime — NOT NULL — 2023-07-25 06:03:00
  • strIPINDi — varchar(1000) — MC0GCCqGSIb3DQIJ...
  • strIPINCi — varchar(1000) — AgAFRzIzMTR3G3XaU4...
  • new_strBirthday — varchar(9) — 0208081
  • strMemberAdd5_new — varbinary(128)
  • 성별 (strGender) — varchar(1) — 1
  • strBirthYear — varchar(8) — 20020808
  • dateinfoUpdateDate — smalldatetime
  • datememberUpdateDate — smalldatetime
  • … +18