..

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