ticket

Tables (10)

PRIVIA_GIFT

  • PUBLISH_NO — NUMBER(20,0) — Primary key — NOT NULL — 상품권
  • SALE_NO — VARCHAR2(20) — Foreign key → PRIVIA_GIFT_SALE.SALE_NO — 판매
  • PRIVIA_GIFT_NO — VARCHAR2(32) — NOT NULL — 프리비아
  • ISSU_NO — VARCHAR2(20) — NOT NULL — 발행
  • STS_CD — CHAR(1) — NOT NULL — 상태
  • ISSU_AMT — NUMBER(20,0) — NOT NULL — 발행
  • USE_AMT — NUMBER(20,0) — NOT NULL — 사용
  • RRMDR_AMT — NUMBER(20,0) — NOT NULL — 잔여
  • USE_CNT — NUMBER(10,0) — NOT NULL — 사용
  • PRIVIA_GIFT_PRT_NM — VARCHAR2(200) — 프리비아
  • BIRTH_DAY — VARCHAR2(8) — 생년월일
  • EMAIL — VARCHAR2(500) — 이메일
  • TRAN_YN — CHAR(1) — 양도가능
  • PRIVIA_MEMBER_ID — VARCHAR2(30) — 프리비아
  • REG_MEMBER_NO — VARCHAR2(20) — 등록
  • OWN_MEMBER_NO — NUMBER(20,0) — 소유자
  • TRNS_MEMBER_NO — NUMBER(20,0) — 양도
  • USE_START_DATE — DATE — 사용
  • USE_END_DATE — DATE — 사용
  • REG_PSBT_START_DATE — DATE — 등록
  • REG_PSBT_END_DATE — DATE — 등록
  • USE_YN — CHAR(1) — NOT NULL — 사용

PRIVIA_GIFT_HISTORY

  • SEQ — NUMBER(20,0) — Primary key — NOT NULL — 순번
  • PUBLISH_NO — NUMBER(20,0) — NOT NULL — 발권
  • HISTORY_CD — VARCHAR2(2) — NOT NULL — 이력
  • OWN_MEMBER_NO — VARCHAR2(20) — NOT NULL — 소유자
  • TRNS_MEMBER_NO — VARCHAR2(20) — 양도자
  • USPL_CD — VARCHAR2(20) — 사용처
  • USPL_ORD_NO — VARCHAR2(20) — 사용처
  • USPL_ORD_SERIAL_NO — VARCHAR2(30) — 사용처
  • USE_REPY_AMT — NUMBER(20,0) — NOT NULL — 사용/환불
  • HISTORY_CONTENT — VARCHAR2(500) — 이력
  • REG_DATE — DATE — NOT NULL — 등록
  • ADMIN_USER_ID — VARCHAR2(20)

PRIVIA_GIFT_INFO

  • ISSU_NO — VARCHAR2(20) — Primary key — NOT NULL — 발행
  • ISSU_AMT — NUMBER(20,0) — NOT NULL — 발행
  • ISSU_CNT — NUMBER(10,0) — NOT NULL — 발행
  • ISSU_DATE — DATE — NOT NULL — 발행
  • ISSU_ID — VARCHAR2(20) — NOT NULL — 발행
  • PRT_REQ_YN — CHAR(1) — NOT NULL — 인쇄
  • PRT_REQ_DATE — DATE — 인쇄
  • PRT_REQ_ID — VARCHAR2(20) — NOT NULL — 인쇄

PRIVIA_GIFT_ISSU

  • ISSU_NO — VARCHAR2(20) — Primary key — NOT NULL — 발행
  • ISSU_AMT — NUMBER(20,0) — NOT NULL — 발행
  • ISSU_CNT — NUMBER(10,0) — NOT NULL — 발행
  • ISSU_DATE — DATE — NOT NULL — 발행
  • ISSU_ID — VARCHAR2(20) — NOT NULL — 발행
  • PRT_REQ_YN — CHAR(1) — NOT NULL — 인쇄
  • PRT_REQ_DATE — DATE — 인쇄
  • PRT_REQ_ID — VARCHAR2(20) — 인쇄
  • ISSU_STS — CHAR(1) — NOT NULL — 발행
  • PRT_AMT — NUMBER(20,0) — NOT NULL
  • PRT_END_DATE — DATE

PRIVIA_GIFT_ISSU_INFO

  • PRIVIA_GIFT_NO — VARCHAR2(32) — Primary key — NOT NULL — 이용권
  • ISSU_SEQ — NUMBER(10,0) — NOT NULL — 발행
  • ISSU_NO — VARCHAR2(20) — Foreign key → PRIVIA_GIFT_INFO.ISSU_NO — NOT NULL — 발행
  • DELI_REQ_YN — CHAR(1) — NOT NULL — 배송
  • DELI_REQ_DATE — DATE — 배송
  • DELI_FNSH_YN — CHAR(1) — NOT NULL — 배송
  • DELI_FNSH_DATE — DATE — 배송
  • RECP_ID — VARCHAR2(20) — 수령
  • PUBLISH_YN — CHAR(1) — NOT NULL — 발권
  • PUBLISH_DATE — DATE — 발권
  • PUBLISH_ID — VARCHAR2(20) — 발권

PRIVIA_GIFT_PUBLISH_HISTORY

  • SEQ — NUMBER(20,0) — Primary key — NOT NULL — 순번
  • PUBLISH_NO — NUMBER(20,0) — Foreign key → PRIVIA_GIFT_PUBLISH_INFO.PUBLISH_NO — NOT NULL — 발권
  • HISTORY_CD — CHAR(1) — NOT NULL — 이력
  • OWN_MEMBER_NO — VARCHAR2(20) — NOT NULL — 소유자
  • TRNS_MEMBER_NO — VARCHAR2(20) — 양도자
  • USPL_CD — VARCHAR2(20) — 사용처
  • USPL_ORD_NO — VARCHAR2(20) — 사용처
  • USPL_ORD_SERIAL_NO — VARCHAR2(5) — 사용처
  • USE_REPY_AMT — NUMBER(20,0) — NOT NULL — 사용/환불
  • HISTORY_CONTENT — VARCHAR2(500) — 이력
  • REG_DATE — DATE — 등록

PRIVIA_GIFT_PUBLISH_INFO

  • PUBLISH_NO — NUMBER(20,0) — Primary key — NOT NULL — 발권
  • PRIVIA_GIFT_NO — VARCHAR2(32) — Foreign key → PRIVIA_GIFT_ISSU_INFO.PRIVIA_GIFT_NO — NOT NULL — 프리비아
  • ISSU_NO — VARCHAR2(20) — Foreign key → PRIVIA_GIFT_INFO.ISSU_NO — NOT NULL — 발행
  • STS_CD — CHAR(1) — NOT NULL — 상태
  • REG_YN — CHAR(1) — NOT NULL — 등록
  • ISSU_AMT — NUMBER(20,0) — NOT NULL — 발행
  • USE_AMT — NUMBER(20,0) — NOT NULL — 사용
  • RRMDR_AMT — NUMBER(20,0) — NOT NULL — 잔여
  • USE_CNT — NUMBER(10,0) — NOT NULL — 사용
  • REG_MEMBER_NO — VARCHAR2(20) — 등록
  • OWN_MEMBER_NO — NUMBER(20,0) — 소유자
  • TRNS_MEMBER_NO — NUMBER(20,0) — 양도
  • USE_START_DATE — DATE — 사용
  • USE_END_DATE — DATE — 사용
  • REG_PSBT_START_DATE — DATE — NOT NULL — 등록
  • REG_PSBT_END_DATE — DATE — NOT NULL — 등록

PRIVIA_GIFT_SALE

  • SALE_NO — VARCHAR2(20) — Primary key — NOT NULL — 판매
  • SALE_STS — CHAR(1) — NOT NULL — 판매
  • ENTP_CD — VARCHAR2(20) — NOT NULL — 매입처
  • SALE_AMT — NUMBER(20,0) — NOT NULL — 판매
  • DC_AMT — NUMBER(20,0) — NOT NULL — 할인
  • DELI_AMT — NUMBER(20,0) — NOT NULL — 배송
  • SETL_AMT — NUMBER(20,0) — NOT NULL — 결제
  • SETL_TYPE — CHAR(1) — NOT NULL — 결제
  • SALE_ID — VARCHAR2(20) — NOT NULL — 판매
  • SALE_REG_DATE — DATE — NOT NULL — 판매
  • SALE_END_DATE — DATE — 판매
  • DELI_REQ_YN — CHAR(1) — NOT NULL — 배송
  • DELI_REQ_DATE — DATE — 배송
  • DC_TYPE — VARCHAR2(20) — NOT NULL — 할인
  • DELI_AMT_ENTP — VARCHAR2(20) — 배송
  • SALE_ETC — CLOB — 판매
  • ENTP_PART — VARCHAR2(100) — 매입처
  • ENTP_PERSON_NM — VARCHAR2(100) — 매입처
  • ENTP_PERSON_PHONE — VARCHAR2(100) — 매입처
  • ENTP_PERSON_HP — VARCHAR2(100) — 매입처
  • ENTP_PERSON_FAX — VARCHAR2(100) — 매입처
  • ENTP_NM — VARCHAR2(200) — 매입처
  • ENTP_PERSON_EMAIL — VARCHAR2(500) — 매입처

PRIVIA_GIFT_SALE_HISTORY

  • SALE_HISTORY_NO — VARCHAR2(5) — Primary key — NOT NULL
  • SALE_NO — VARCHAR2(20) — Primary key — NOT NULL
  • SETL_TYPE — CHAR(1) — NOT NULL
  • SETL_AMT — NUMBER(20,0) — NOT NULL
  • SETL_DATE — DATE — NOT NULL
  • SETL_METHOD — VARCHAR2(20) — NOT NULL
  • SETL_TID — VARCHAR2(100)
  • CANCEL_DATE — DATE
  • CANCEL_HISTORY_NO — NVARCHAR2(5)
  • PG_COMP_CD — VARCHAR2(20) — PG사코드(UP_CD:PGCOMP)
  • INTR_MID_CD — VARCHAR2(20) — 통합MID
  • MID — VARCHAR2(100) — MID

PRIVIA_GIFT_USPL_CD

  • PRIVIA_GIFT_NO — VARCHAR2(32) — Primary key — NOT NULL
  • USPL_CD — VARCHAR2(20) — Primary key — NOT NULL — 사용처
  • REG_DATE — DATE — NOT NULL — 등록
  • SELL_ID — VARCHAR2(20) — NOT NULL — 판매