피기맘 리뉴얼

테이블 (10)

PA_PAYORDER (주문)

  • PAYORDER_SEQ — VARCHAR(20) — 기본 키 — NOT NULL — 주문번호
  • PRODUCT_SEQ (PRODUCT_SEQ2) — VARCHAR(20) — 외래 키 → PA_PRODUCT_INFO.PRODUCT_SEQ — NOT NULL
  • MEMBER_NO — VARCHAR(20) — NOT NULL — 결제회원번호
  • AMT — VARCHAR(15) — 결제금액
  • PAYMENT_TYPE — VARCHAR(10)
  • P_GOODS — VARCHAR(100)
  • GOODS_TYPE — VARCHAR(100)
  • REG_DATE — DATE — NOT NULL
  • REG_IP — VARCHAR(17)
  • REG_MEMBER — VARCHAR(20)
  • UPD_DATE — SYSDATE
  • UPD_IP — VARCHAR(17)
  • UPD_MEMBER — VARCHAR(20)
  • REVISION_PICE — VARCHAR(15)
  • ORDER_STATUS — VARCHAR(3)
  • CERT_YN — CHAR(1)
  • CERT_BIRTH — CHAR(8)
  • CERT_NAME — VARCHAR(100)
  • CERT_REQNO — VARCHAR(30)
  • CERT_RESNO — VARCHAR(24)

PA_PAYRESULT (결제결과)

  • PAYRESULT_SEQ — VARCHAR(20) — 기본 키 — NOT NULL
  • PAYORDER_SEQ — VARCHAR(20) — 외래 키 → PA_PAYORDER.PAYORDER_SEQ — NOT NULL — 주문번호
  • TID — VARCHAR(40)
  • RESULT_MSG — VARCHAR(100)
  • RESULT_STATUS — VARCHAR(50)
  • GOODNAME — VARCHAR(100)
  • PRICE — VARCHAR(20)
  • BUYERNAME — VARCHAR(100)
  • BUYEREMAIL — VARCHAR(150)
  • BUYERTEL — VARCHAR(30)
  • PAYMETHOD — VARCHAR(40)
  • PAYNAME — VARCHAR(50)
  • APPLNUM — VARCHAR(10)
  • APPL_DTHR — VARCHAR(20)
  • PAYDEVICE — VARCHAR(10)
  • REG_DATE — DATE
  • REG_IP — VARCHAR(17)
  • REG_MEMBER — VARCHAR(20)
  • UPD_DATE — DATE
  • UPD_IP — VARCHAR(17)
  • UPD_MEMBER — VARCHAR(20)

PA_PAY_LOG (결제로그)

  • LOG_SEQ — VARCHAR(20) — 기본 키 — NOT NULL
  • PAYRESULT_SEQ — VARCHAR(20) — 외래 키 → PA_PAYRESULT.PAYRESULT_SEQ — NOT NULL
  • MID — VARCHAR(100)
  • OID — VARCHAR(100)
  • TID — VARCHAR(40)
  • RESULT_MSG — VARCHAR(100)
  • RESULT_STATUS — VARCHAR(50)
  • GOODNAME — VARCHAR(100)
  • PRICE — VARCHAR(20)
  • BUYERNAME — VARCHAR(100)
  • BUYEREMAIL — VARCHAR(150)
  • BUYERTEL — VARCHAR(30)
  • PAYMETHOD — VARCHAR(40)
  • PAYNAME — VARCHAR(50)
  • CARD_CORPFLAG — CHAR(1)
  • CARD_CHECKFLAG — CHAR(1)
  • CARD_NUM — VARCHAR(100)
  • CARD_CODE — VARCHAR(2)
  • APPLNUM — VARCHAR(10)
  • APPL_DTHR — VARCHAR(20)
  • PAYDEVICE — VARCHAR(10)
  • REG_DATE — DATE
  • REG_IP — VARCHAR(17)
  • REG_MEMBER — VARCHAR(20)
  • UPD_DATE — DATE
  • UPD_IP — VARCHAR(17)
  • UPD_MEMBER — VARCHAR(20)

PA_PRODUCT_INFO (상품정보)

  • PRODUCT_SEQ — VARCHAR(20) — 기본 키 — NOT NULL
  • P_NAME — VARCHAR(150)
  • P_AMT — VARCHAR(15)
  • P_TYPE — VARCHAR(50)
  • USE_YN — VARCHAR(20)
  • REG_DATE — DATE
  • REG_IP — VARCHAR(20)
  • REG_MEMBER — VARCHAR(20)
  • UPD_DATE — DATE
  • UPD_IP — VARCHAR(17)
  • UPD_MEMBER — VARCHAR(20)
  • REMARK — VARCHAR(500)
  • SUR_TAX — VARCHAR(15)
  • EXAM_YEAR — CHAR(4)
  • DEL_YN — VARCHAR(20) — NOT NULL

TC_CONSULT (컨설팅)

  • CONSULT_SEQ — VARCHAR(20) — 기본 키 — NOT NULL
  • CONSULT_STATUS — VARCHAR(20)
  • CONSULT_ANSWER — VARCHAR(1700)
  • RECOMMEND_GROUP_SEQ — VARCHAR(20)
  • REG_DATE — DATE
  • REG_IP — VARCHAR(20)
  • REG_MEMBER — VARCHAR(20)
  • UPD_DATE — DATE
  • UPD_IP — VARCHAR(17)
  • UPD_MEMBER — VARCHAR(20)
  • PAYORDER_SEQ (PAYORDER_SEQ2) — VARCHAR(20) — 외래 키 → PA_PAYORDER.PAYORDER_SEQ — NOT NULL — 주문번호

TC_CONSULT_LOG (컨설팅 신청)

  • CONSULT_SEQ (CONSULT_SEQ2) — VARCHAR(20) — 외래 키 → TC_CONSULT.CONSULT_SEQ — NOT NULL
  • TITLE — VARCHAR(100)
  • STD_NO — VARCHAR(20)
  • STD_NM — VARCHAR(100)
  • REG_DATE — DATE
  • REG_IP — VARCHAR(20)
  • REG_MEMBER — VARCHAR(20)
  • MEMBER_MPHONE — VARCHAR(11)
  • CAMPUS_CDS — VARCHAR(200)
  • CONSULT_DT — VARCHAR(100)
  • CONSULT_CONTS — VARCHAR(1700)
  • RECEIVE_EMAIL — VARCHAR(100)

TC_FILE

  • FILE_ID — VARCHAR(20) — 기본 키 — NOT NULL
  • FILE_PATH — VARCHAR(200) — NOT NULL
  • FILE_NAME — VARCHAR(200) — NOT NULL
  • FILE_ORIGINAL_NAME — VARCHAR(200) — NOT NULL
  • FILE_SIZE — NUMBER(11) — NOT NULL
  • REG_DATE — DATE — NOT NULL
  • REG_MEMBER — VARCHAR(20) — NOT NULL
  • DEL_YN — CHAR(1) — NOT NULL
  • DEL_DATE — DATE
  • DEL_MEMBER — VARCHAR(20)
  • FILE_GROUP_ID (FILE_GROUP_ID2) — VARCHAR(20) — 외래 키 → TC_FILE_GROUP.FILE_GROUP_ID — NOT NULL

TC_FILE_GROUP

  • FILE_GROUP_ID — VARCHAR(20) — 기본 키 — NOT NULL
  • REG_DATE — CHAR(14) — NOT NULL
  • REG_MEMBER — VARCHAR(20) — NOT NULL
  • DEL_YN — CHAR(1) — NOT NULL
  • DEL_DATE — DATE
  • DEL_MEMBER — VARCHAR(20)
  • ENTR_YEAR — CHAR(4) — 외래 키 → TC_MEMBER.MEMBER_NO — NOT NULL

TC_MEMBER

  • MEMBER_NO — VARCHAR(20) — 기본 키 — NOT NULL
  • MEMBER_EMAIL — VARCHAR(150) — NOT NULL
  • MEMBER_NM — VARCHAR(100) — NOT NULL
  • MEMBER_TYPE — VARCHAR(20)
  • MEMBER_PWD — VARCHAR(100)
  • MEMBER_MPHONE — VARCHAR(30)
  • MEMBER_HPHONE — VARCHAR(30)
  • MEMBER_IMG_KEY — VARCHAR(200)
  • COUNTRY_CODE — VARCHAR(30)
  • AUTH_CODE — VARCHAR(50)
  • AUTH_YN — CHAR(1)
  • PRIVACY_YN — CHAR(1)
  • MAIL_RCV_YN — CHAR(1)
  • MAIL_CHANGE_CNT — NUMBER(11)
  • OLD_MEMBER_EMAIL — VARCHAR(150)
  • CERT_YN — CHAR(1)
  • CERT_BIRTH — CHAR(8)
  • TCH_CERT_YN — CHAR(1)
  • MEMBER_ENTR_PATH — VARCHAR(100)
  • MEMBER_ENTR_DEVICE — VARCHAR(20)
  • MEMBER_STATUS — VARCHAR(50)
  • MEMBER_LEVEL — NUMBER(11)
  • MEMBER_MEMO — CLOB
  • ZIP_NO — CHAR(6)
  • DEL_YN — CHAR(1)
  • ADDR1 — VARCHAR(400)
  • ADDR2 — VARCHAR(400)
  • ROAD_ADDR — VARCHAR(400)
  • MEMBER_GENDER — CHAR(1)
  • ORGAN_SEQ — VARCHAR(20)
  • REG_DATE — DATE
  • REG_IP — CHAR(17)
  • REG_MEMBER — VARCHAR(20)
  • UPD_DATE — DATE
  • UPD_IP — CHAR(17)
  • UPD_MEMBER — VARCHAR(20)
  • MEMBER_RID — VARCHAR(20)
  • SCH_CD — VARCHAR(20)
  • ENTR_YEAR — CHAR(4)

TC_RECOMMEND_SCHOOL (컨설턴트 추천대학)

  • RECOMMEND_SEQ — VARCHAR(20) — 기본 키 — NOT NULL
  • RECOMMEND_GROUP_SEQ — VARCHAR(20) — 외래 키 → TC_CONSULT.CONSULT_SEQ — NOT NULL
  • SCH_CD — VARCHAR(20)
  • MAJOR_CD — VARCHAR(20) — NOT NULL
  • MODEL_CD — VARCHAR(20)
  • MODEL_TYPE — VARCHAR(20)
  • REG_DATE — DATE
  • REG_IP — CHAR(17)
  • REG_MEMBER — VARCHAR(20)