finevopay
Tables (5)
deposits_calender
- id — int(11) — Primary key — NOT NULL
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- deletedAt — datetime(6)
- businessNumber — varchar(255) — NOT NULL — 사업자번호
- posId — varchar(255) — NOT NULL — 단말기번호
- approvalNumber — varchar(255) — NOT NULL — 승인번호
- cardNumber — varchar(255) — NOT NULL — 카드번호
- note — varchar(255) — NOT NULL — 비고
- expectedDepositDate — varchar(255) — NOT NULL — 입금예정일
- transmissionDate — varchar(255) — NOT NULL — 전송일자
- acquiringCompanyCode — varchar(255) — NOT NULL — 매입사코드
- acquiringCompany — varchar(255) — NOT NULL — 매입사
- merchantNumber — varchar(255) — NOT NULL — 가맹점번호
- originalTransactionAt — datetime — NOT NULL — 원거래일자
- transmissionAmount — int(11) — NOT NULL — 전송금액
- totalAmount — int(11) — NOT NULL — 총금액
- fee — int(11) — NOT NULL — 수수료
deposits_calender_day
- id — int(11) — Primary key — NOT NULL
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- deletedAt — datetime(6)
- businessNumber — varchar(255) — NOT NULL — 사업자번호
- depositMonth — varchar(255) — NOT NULL — 입금월
- expectedDepositDate — varchar(255) — NOT NULL — 입금예정날짜
- cardApprovalAmount — int(11) — NOT NULL — 카드승인
- cashApprovalAmount — int(11) — NOT NULL — 현금승인
- depositAmount — int(11) — NOT NULL — 입금액
sales_with_card
- id — int(11) — Primary key — NOT NULL
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- deletedAt — datetime(6)
- businessNumber — varchar(255) — NOT NULL — 사업자번호
- posId — varchar(255) — NOT NULL — 단말기ID
- merchantNumber — varchar(255) — NOT NULL — 가맹점번호
- merchantName — varchar(255) — NOT NULL — 가맹점명
- transactionAt — datetime — NOT NULL — 거래일시
- originalTransactionAt — datetime — 원거래일시
- expectedDepositAt — varchar(255) — 입금예정일
- approvalNumber — varchar(255) — NOT NULL — 승인번호
- cardNumber — varchar(255) — NOT NULL — 카드번호
- cardType — varchar(255) — NOT NULL — 카드구분
- cardCompany — varchar(255) — NOT NULL — 카드사
- acquiringCompany — varchar(255) — NOT NULL — 매입사
- transactionNumber — varchar(255) — NOT NULL — 거래고유번호
- transactionType — varchar(255) — NOT NULL — 거래구분
- taxationType — varchar(255) — NOT NULL — 과세/면세
- installment — int(11) — NOT NULL — 할부
- commission — int(11) — NOT NULL — 수수료
- approvalAmount — int(11) — NOT NULL — 승인금액/합계/결제금액
- taxFreeAmount — int(11) — NOT NULL — 면세금액
- taxableAmount — int(11) — NOT NULL — 과세금액
- taxableSupplyAmount — int(11) — NOT NULL — 과세공급가
- taxAmount — int(11) — NOT NULL — 과세세금
- isCancelRequest — tinyint(4) — NOT NULL — 취소요청상태여부
- canceledAt — datetime — 취소요청일시
- cancelCompletedAt — datetime — 취소완료일시
- canceledUserId — int(11) — 취소요청유저
- cancelCompletedUserId — int(11) — 취소완료유저
- isAllCancel — tinyint(4) — 전체취소여부
- isPartialCancel — tinyint(4) — 부분취소여부
- canceledAmount — int(11) — 취소요청금액
- canceledTaxFreeAmount — int(11) — 취소할 면세금액
- canceledTaxableAmount — int(11) — 취소할 과세금액
- canceledReason — varchar(255) — 취소사유
sales_with_cash
- id — int(11) — Primary key — NOT NULL
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- deletedAt — datetime(6)
- businessNumber — varchar(255) — NOT NULL — 사업자번호
- posId — varchar(255) — NOT NULL — 단말기ID
- merchantName — varchar(255) — NOT NULL — 가맹점명
- transactionAt — datetime — NOT NULL — 거래일시
- originalTransactionAt — datetime — 원거래일시
- approvalNumber — varchar(255) — NOT NULL — 승인번호
- authenticationNumber — varchar(255) — NOT NULL — 인증확인번호
- approvalAmount — int(11) — NOT NULL — 승인금액/합계/결제금액
- transactionAmount — int(11) — NOT NULL — 거래금액
- serviceAmount — int(11) — NOT NULL — 봉사료
- taxAmount — int(11) — NOT NULL — 과세금액
- orderId — varchar(255) — 주문번호
- useType — varchar(255) — NOT NULL — 사용구분
- transactionType — varchar(255) — NOT NULL — 거래구분
- noteType — varchar(255) — NOT NULL — 비고
- searchType — varchar(255) — 조회구분
- taxationType — varchar(255) — NOT NULL — 과세/면세
users
- id — int(11) — Primary key — NOT NULL
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- deletedAt — datetime(6)
- userLoginId — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- isAdmin — tinyint(4) — NOT NULL
- companyName — varchar(255) — NOT NULL
- businessNumber — varchar(20)