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