Etusivu Tutki Apua
Kirjaudu sisään
style24
/
style24.doc
2
0
Fork 0
Tiedostot Ongelmat 0 Pull-pyynnöt 0 Wiki
Puu: f083507d3a
Branchit Tagit
style24.doc
/
스타일24산출물(요청)_2021216
/
01.개발산출물
/
03.테이블정의서
/
data
/
t3917.json.js

t3917.json.js 18 KB
Historia Raaka

1 
  1. window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3917","name":"tb_coupon","subtype":"TABLE","is_user_defined":false,"description":"<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n                <html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n                    <head>\r\n                        <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" /><title>\r\n                        </title>\r\n                        <style type=\"text/css\">\r\n                            .cs2654AE3A{text-align:left;text-indent:0pt;margin:0pt 0pt 0pt 0pt}\r\n                            .cs82292024{color:#000000;background-color:transparent;font-family:Segoe UI;font-size:10pt;font-weight:normal;font-style:normal;}\r\n                        </style>\r\n                    </head>\r\n                    <body>\r\n                        <p class=\"cs2654AE3A\"><span class=\"cs82292024\">쿠폰. 신규 쿠폰 등록에 의한 발생</span></p></body>\r\n                </html>","summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"tb_coupon"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-37137","object_id":"column-37137","name":"CPN_ID","name_without_path":"CPN_ID","description":"쿠폰ID(CPN+SEQ_CPN_NO SEQUENCE)","is_pk":true,"is_identity":true,"data_type":"unsigned int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37138","object_id":"column-37138","name":"CPN_NM","name_without_path":"CPN_NM","description":"쿠폰명","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"100","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37136","object_id":"column-37136","name":"CPN_DESC","name_without_path":"CPN_DESC","description":"쿠폰설명","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37163","object_id":"column-37163","name":"SITE_CD","name_without_path":"SITE_CD","description":"사이트코드(공통코드G000)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37128","object_id":"column-37128","name":"AF_LINK_CD","name_without_path":"AF_LINK_CD","description":"제휴링크코드(사용안함)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37140","object_id":"column-37140","name":"CPN_TYPE","name_without_path":"CPN_TYPE","description":"쿠폰유형(공통코드G230)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37129","object_id":"column-37129","name":"APPLY_SCOPE","name_without_path":"APPLY_SCOPE","description":"적용범위(A:전체, I:개별). \"I:개별\"이고 쿠폰유형이면 TB_COUPON_REFVAL 참조","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"A","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37148","object_id":"column-37148","name":"DC_WAY","name_without_path":"DC_WAY","description":"할인방식(공통코드G240)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37147","object_id":"column-37147","name":"DC_PVAL","name_without_path":"DC_PVAL","description":"할인값(PC). 할인방식이 금액이면 할인금액, 율이면 할인율","is_pk":false,"is_identity":false,"data_type":"unsigned float","data_length":"12","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37146","object_id":"column-37146","name":"DC_MVAL","name_without_path":"DC_MVAL","description":"할인값(모바일). 할인방식이 금액이면 할인금액, 율이면 할인율","is_pk":false,"is_identity":false,"data_type":"unsigned float","data_length":"12","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37144","object_id":"column-37144","name":"DC_AVAL","name_without_path":"DC_AVAL","description":"할인값(모바일앱)","is_pk":false,"is_identity":false,"data_type":"unsigned float","data_length":"12","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37155","object_id":"column-37155","name":"MAX_DC_AMT","name_without_path":"MAX_DC_AMT","description":"최고할인금액","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37158","object_id":"column-37158","name":"PD_GB","name_without_path":"PD_GB","description":"기간/일수구분(P:기간, D:일수)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"P","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37132","object_id":"column-37132","name":"AVAIL_STDT","name_without_path":"AVAIL_STDT","description":"유효시작일시(기간/일수구분 \"P:기간\"일 때 사용됨)","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37131","object_id":"column-37131","name":"AVAIL_EDDT","name_without_path":"AVAIL_EDDT","description":"유효종료일시(기간/일수구분 \"P:기간\"일 때 사용됨)","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37130","object_id":"column-37130","name":"AVAIL_DAYS","name_without_path":"AVAIL_DAYS","description":"유효일수(기간/일수구분 \"D:일수\"일 때 사용됨)","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37143","object_id":"column-37143","name":"CUST_PUB_LIMIT_QTY","name_without_path":"CUST_PUB_LIMIT_QTY","description":"고객당발행제한수량(0은 무제한)","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37164","object_id":"column-37164","name":"TOT_PUB_LIMIT_QTY","name_without_path":"TOT_PUB_LIMIT_QTY","description":"총발행제한수량(0은 무제한)","is_pk":false,"is_identity":false,"data_type":"unsigned int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37157","object_id":"column-37157","name":"ONE_PUB_QTY","name_without_path":"ONE_PUB_QTY","description":"1회발행수량(기본은 1)","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"1","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37149","object_id":"column-37149","name":"DN_GB","name_without_path":"DN_GB","description":"다운로드구분(공통코드G058) 사용안함","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37152","object_id":"column-37152","name":"DOWN_STDT","name_without_path":"DOWN_STDT","description":"다운로드시작일시","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37151","object_id":"column-37151","name":"DOWN_EDDT","name_without_path":"DOWN_EDDT","description":"다운로드종료일시","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37134","object_id":"column-37134","name":"BUY_LIMIT_AMT","name_without_path":"BUY_LIMIT_AMT","description":"구매제한금액(0은 제한없음. 그 외는 00 이상 구매 시 사용)","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37159","object_id":"column-37159","name":"PLAN_SQ","name_without_path":"PLAN_SQ","description":"기획전번호(쿠폰유형이 플러스쿠폰 일 때 사용 기획전번호)","is_pk":false,"is_identity":false,"data_type":"unsigned int","data_length":"10, 0","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37162","object_id":"column-37162","name":"REISSUANCE","name_without_path":"REISSUANCE","description":"쿠폰재발급여부(공통코드G231)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37139","object_id":"column-37139","name":"CPN_STAT","name_without_path":"CPN_STAT","description":"쿠폰상태(공통코드G232)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":"G232_10","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37153","object_id":"column-37153","name":"END_ALIM_YN","name_without_path":"END_ALIM_YN","description":"만료알림여부","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37154","object_id":"column-37154","name":"FIRST_ORD_YN","name_without_path":"FIRST_ORD_YN","description":"첫구매여부 (Y:구매이력이없음 | N:구매이력있음)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37150","object_id":"column-37150","name":"DOWN_ABL_YN","name_without_path":"DOWN_ABL_YN","description":"다운로드가능여부(마이페이지, 상품상세) --> EP쿠폰, 난수쿠폰","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37145","object_id":"column-37145","name":"DC_CD_GB","name_without_path":"DC_CD_GB","description":"할인코드구분(공통코드G233)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":"G233_00","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37142","object_id":"column-37142","name":"CUST_JOIN_STDT","name_without_path":"CUST_JOIN_STDT","description":"회원가입시작일시(신규회원여부의 판단을 가입일자로 설정함)","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37141","object_id":"column-37141","name":"CUST_JOIN_EDDT","name_without_path":"CUST_JOIN_EDDT","description":"회원가입종료일시(신규회원여부의 판단을 가입일자로 설정함)","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37135","object_id":"column-37135","name":"BUY_STDT","name_without_path":"BUY_STDT","description":"구매기간시작일시(구매기간일자 해당기간에 구매이력이 없으면 다운로드 가능)","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37133","object_id":"column-37133","name":"BUY_EDDT","name_without_path":"BUY_EDDT","description":"구매기간종료일시(구매기간일자 해당기간에 구매이력이 없으면 다운로드 가능)","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37156","object_id":"column-37156","name":"NEW_CUST_YN","name_without_path":"NEW_CUST_YN","description":"신규회원여부","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37161","object_id":"column-37161","name":"REG_NO","name_without_path":"REG_NO","description":"등록자번호","is_pk":false,"is_identity":false,"data_type":"unsigned int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37160","object_id":"column-37160","name":"REG_DT","name_without_path":"REG_DT","description":"등록일시","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":false,"computed_formula":"","default_value":"CURRENT_TIMESTAMP","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37166","object_id":"column-37166","name":"UPD_NO","name_without_path":"UPD_NO","description":"수정자번호","is_pk":false,"is_identity":false,"data_type":"unsigned int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37165","object_id":"column-37165","name":"UPD_DT","name_without_path":"UPD_DT","description":"수정일시","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":false,"computed_formula":"","default_value":"CURRENT_TIMESTAMP","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]}],"relations":[],"unique_keys":[{"name":"PRIMARY","description":"쿠폰ID(CPN+SEQ_CPN_NO SEQUENCE)","is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"CPN_ID","name":"CPN_ID"}],"custom_fields":{}}],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};
    2.