van
Tables (10)
ClientInfoTbl (사업자정보)
- 사업자번호 (ClientNumber) — NUMBER(10) — Primary key — NOT NULL
- 가맹점명 (StoreName) — VARCHAR2(20)
- 대표자 (ClientName) — VARCHAR2(10)
- 휴대전화 (ClientPhone) — NUMBER(11)
MsgCodeTbl (응답코드)
- 응답코드 (MsgCode) — VACHAR2(4) — Primary key — NOT NULL
- 응답메세지 (MsgCont) — VARCHAR2(64)
OnlineTranTbl (온라인 거래 원장)
- 거래일련번호 (TranNumber) — NUMBER(8) — Primary key — NOT NULL
- 거래종류코드 (TranCode) — VARCHAR2(2) — Foreign key → TranTypeCodeTbl.거래종류코드 — NOT NULL
- 응답코드 (MsgCode) — VARCHAR2(4) — Foreign key → MsgCodeTbl.응답코드 — NOT NULL
- 단말기번호 (TerminalNumber) — NUMBER(10) — Foreign key → TerminalTbl.단말기번호 — NOT NULL
- 거래일자 (TranDate) — VACHAR2(8)
- 카드정보 (CardInfo) — VARCHAR2(37)
- 승인요청금액 (TranAmount) — NUMBER10)
- 승인번호 (ApproveNumber) — NUMBER(15)
- 할부개월수 (InatallMonth) — VARCHAR2(2)
- 원승인날짜 (TranCreateAt) — VARCHAR2(20)
TerminalStatTbl (단말기상태)
- 단말기상태코드 (TerminalStateCode) — NUMBER(1) — Primary key — NOT NULL
- 상태여부 (TerminalState) — VACHAR2(10)
TerminalTbl (단말기원장)
- 단말기번호 (TerminalNumber) — NUMBER(10) — Primary key — NOT NULL
- 사업자번호 (ClientNumber) — NUMBER(10) — Foreign key → ClientInfoTbl.사업자번호 — NOT NULL
- 단말기상태코드 (TerminalStatCode) — NUMBER(1) — Foreign key → TerminalStatTbl.단말기상태코드 — NOT NULL
TranTbl (거래원장)
- 거래일련번호 (TranNumber) — NUMBER(8) — Primary key — NOT NULL
- 거래종류코드 (TranCode) — VARCHAR2(2) — Foreign key → TranTypeCodeTbl.거래종류코드 — NOT NULL
- 응답코드 (MsgCode) — VARCHAR2(4) — Foreign key → MsgCodeTbl.응답코드 — NOT NULL
- 단말기번호 (TerminalNumber) — NUMBER(10) — Foreign key → TerminalTbl.단말기번호 — NOT NULL
- 거래일자 (TranDate) — VACHAR2(8)
- 카드정보 (CardInfo) — VARCHAR2(37)
- 승인요청금액 (TranAmount) — NUMBER10)
- 승인번호 (ApproveNumber) — NUMBER(15)
- 할부개월수 (InatallMonth) — NUMBER(2)
- 원승인날짜 (TranCreateAt) — VARCHAR2(20)
TranTypeCodeTbl (거래종류코드)
- 거래종류코드 (TranCode) — VACHAR2(2) — Primary key — NOT NULL
- 거래종류코드명 (TranCodeName) — VARCHAR2(15)
VanUserTbl (Van 사용자)
- 아이디 (UserId) — VARCHAR2(20) — Primary key — NOT NULL
- 비밀번호 (PassWord) — VARCHAR2(20)
hub
- id — BIGINT — Primary key — NOT NULL
- central_hub_id — BIGINT — Foreign key → hub.id — NOT NULL
- hub_name — VARCHAR(50)
- addressa (adress) — VARCHAR(150)
- latitude — DOUBLE
- longitude — DOUBLE
- status — VARCHAR(20)
- created_at — DATETIME
- created_by — VARCHAR(100)
- updated_at — DATETIME
- updated_by — VARCHAR(100)
- deleted_at — DATETIME
- deleted_by — VARCHAR(100)
- is_deleted — TINYINT(1)
hub-route
- id — BIGINT — Primary key — NOT NULL
- distance_km — FLOAT
- from_hub_id — BIGINT — Foreign key → hub.id — NOT NULL
- to_hub_id — BIGINT — Foreign key → hub.id — NOT NULL