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