Swichone

Tables (8)

account_balance

  • idx — int(11) — Primary key — NOT NULL — pk
  • user_idx — int(11) — Foreign key → user.idx — NOT NULL — user_idx
  • currency_code — varchar(3) — Foreign key → currency_code.currency_code — NOT NULL
  • balance — desimal(15,2) — 잔액

balance_recharge

  • idx (Key) — int(11) — Primary key — NOT NULL — pk
  • user_idx (idx) — int(11) — Foreign key → user.idx — NOT NULL — user_idx
  • currency_code — varchar(3) — Foreign key → currency_code.currency_code — NOT NULL
  • amount (Field) — desimal(15,2) — NOT NULL — 금액
  • type (Field2) — varchar(3) — NOT NULL — 충전타입
  • recharge_date (Field7) — datetime — NOT NULL — 충전일

card_recharge_details

  • idx (Key2) — Primary key — NOT NULL
  • recharge_idx (Key) — int(11) — Foreign key → balance_recharge.idx — NOT NULL — pk
  • card_name (Field4)
  • card_number (Field)
  • expiry_date (Field2)
  • cvs (Field3)

cash_recharge_detail

  • idx (Key) — Primary key — NOT NULL
  • recharge_idx (Key2) — int(11) — Foreign key → balance_recharge.idx — NOT NULL — pk
  • bank (Field2)
  • account_number (Field)

currency_code

  • currency_code — varchar(3) — Primary key — NOT NULL
  • allow_decimals — tinyint(1) — NOT NULL — 소수점 두자리 이하 여부

merchant

  • idx — int(11) — Primary key — NOT NULL — pk
  • name — varchar(20) — NOT NULL — 상점이름
  • fee — desimal(5,2) — NOT NULL — 수수료율

payments

  • idx — int(11) — Primary key — NOT NULL
  • user_idx — int(11) — Foreign key → user.idx — NOT NULL — user_idx
  • merchant_idx — int(11) — NOT NULL — 상점 idx
  • currency_code — varchar(3) — NOT NULL — 통화
  • total_amount — desimal(15,2) — NOT NULL — 총 결제금액
  • amount (Field) — desimal(15,2) — NOT NULL
  • fee (Field2) — desimal(5,2) — NOT NULL
  • status — varchar(10) — NOT NULL — 결제상태
  • payment_date — datetime — NOT NULL — 결제일

user

  • idx — int(11) — Primary key — NOT NULL — pk
  • user_id — varchar(20) — NOT NULL — 아이디
  • name — varchar(20) — NOT NULL — 이름
  • reg_date — datetime — NOT NULL — 가입일
  • mod_date — datetime — 수정일