create table PAYMENT_TRANSACTION (
    MNG_NO varchar(255) not null, 
    CARD_INFO varchar(255), 
    INSTALL_MONTHS bigint, 
    PRICE bigint, 
    STATUS varchar(255), 
    VAT bigint, 
    SUB_MNG_NO varchar(255), 
    primary key (MNG_NO),
    foreign key (SUB_MNG_NO) references PAYMENT_TRANSACTION.MNG_NO
);
comment on table PAYMENT_TRANSACTION is '결제 트랜잭션';
comment on column PAYMENT_TRANSACTION.MNG_NO is '관리번호';
comment on column PAYMENT_TRANSACTION.CARD_INFO is '카드정보(암호화)';
comment on column PAYMENT_TRANSACTION.INSTALL_MONTHS is '할부개월수';
comment on column PAYMENT_TRANSACTION.PRICE is '결제금액';
comment on column PAYMENT_TRANSACTION.STATUS is '결제상태';
comment on column PAYMENT_TRANSACTION.VAT is '부가가치세';
comment on column PAYMENT_TRANSACTION.SUB_MNG_NO is '결제트랜잭션 관리번호';