..
Tables (4)
AT_BASIC_INQUIRY_VAL (기본인적사항)
- USER_TESTING_NO (사용자검사번호(=온라인코드)) — varchar(100) — Foreign key → PSY_ONLINE_CODE.PSY_ONLINE_CODE — NOT NULL
- PSY_ITEM_ID (검사상품아이디) — varchar(20)
- PSY_ITEM_VER (검사상품버전) — varchar(20)
- SUB_PSY_ITEM_ID (서브검사상품아이디) — varchar(20)
- TESTING_ORG (검사기관) — varchar(1000)
- BIRTHDAY (생년월일) — varchar(200)
- SEX (성별) — varchar(4)
- AT_REGION_CD (지역코드) — varchar(10)
- TESTING_DATE (검사일자) — char(8)
- NAME (이름) — varchar(200)
- AT_AGE_CD (생활월령코드) — varchar(10)
- AT_SCHOOL_TYPE_CD (학교타입코드) — varchar(10)
- AT_SCHOOL_AGE_CD (학령코드) — varchar(10)
- MEMBER_NO (회원번호) — varchar(20)
- TESTER_NAME (검사자성명) — varchar(200)
- REG_DATE (등록일시) — datetime
MEMBER_MASTER (회원마스터)
- MEMBER_NO (회원번호) — varchar(20) — Primary key — NOT NULL
- LOGIN_ID (로그인아이디) — varchar(30)
- PASSWORD (비밀번호) — varchar(200)
- RELATION_COMPANY_CODE (연결회사아이디) — varchar(10)
- MEMBER_NM (이름) — varchar(200)
- MEMBER_TYPE_CD (회원유형코드) — varchar(4)
- SCHOOL_NM (학교명) — varchar(200)
- EMAIL (이메일) — varchar(200)
- TELEPHONE_NUM (전화번호) — varchar(200)
- CELLPHONE_AGENCY_TYPE_CD (휴대폰통신사코드) — varchar(4)
- CELLPHONE_NUM (휴대폰번호) — varchar(200)
- ZIPCODE (우편번호) — varchar(7)
- ADDR (주소) — varchar(1000)
- DETAIL_ADDR (상세주소) — varchar(1000)
- SUB_ID_YN (서브ID여부) — char(1)
- MEMBER_STATUS_CD (회원상태코드) — varchar(4)
- MEMBER_POINT_STATUS (포인트리스트정보) — varchar(1)
- EMAIL_RECEIVE_YN (이메일수신여부) — char(1)
- SMS_RECEIVE_YN (SMS수신여부) — char(1)
- POSTPAID_YN (후불결제이용여부) — char(1)
- REG_DATE (등록일시) — datetime
- MOD_DATE (수정일시) — datetime
- PASSWORD_MOD_YMD (비밀번호변경일자) — varchar(10)
- AUTH_NUM (인증번호) — varchar(10)
- CI (CI인증정보) — varchar(100)
MEMBER_SUB_ID (서브아이디)
- MEMBER_NO (회원번호) — varchar(20) — Foreign key → MEMBER_MASTER.MEMBER_NO — NOT NULL
- LEVEL_1_MEMBER_NO (레벨1회원번호) — varchar(20)
- USE_YN (사용여부) — char(1)
PSY_ONLINE_CODE (온라인코드)
- PSY_ONLINE_CODE (온라인코드) — varchar(30) — Primary key — NOT NULL
- MEMBER_NO (구매회원번호) — varchar(20) — Foreign key → MEMBER_MASTER.MEMBER_NO — NOT NULL
- ONLINE_CODE_BUY_TYPE_CD (온라인코드구매유형코드) — varchar(20)
- PSY_ITEM_ID (검사상품아이디) — varchar(20)
- AT_TESTING_TYPE_CD (검사실시유형코드) — varchar(20)
- AT_STATUS_CD (검사상태코드) — varchar(20)
- AT_PROGRESS_RATE (검사진행률) — decimal(5,2)
- EXAMINEE_MEMBER_NO (결과조회본인매핑회원번호) — varchar(20)
- EXAMINEE_NM (피검자성명) — varchar(200)
- EXAMINEE_CELLPHONE_NUM (피검자휴대폰) — varchar(200)
- EXAMINEE_EMAIL (피검자이메일) — varchar(200)
- EXAMINEE_GROUP_SEQ (피검자그룹순번) — int(11)
- SEND_DATE (온라인코드발송일시) — datetime
- SEND_MEMBER_NO (온라인코드발송회원번호) — varchar(20)
- COMPLETE_SMS_YN (검사완료통보SMS여부) — char(1)
- EXAMINEE_RESULT_CONFIRM_YN (피검자본인확인가능여부) — char(1)
- REG_DATE (등록일시) — datetime
- MOD_MEMBER_NO (수정회원번호) — varchar(20)
- MOD_DATE (수정일시) — datetime
- RESULT_USE_YN (결과보기사용여부) — char(1)
- DEL_YN (폐기여부) — char(1)
- DEL_REASON (폐기사유) — varchar(1000)
- DEL_DATE (폐기일시) — datetime