피기맘 리뉴얼
테이블 (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)