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 — 수정일