LinkPay

Tables (14)

category

  • id — INT — Primary key — NOT NULL
  • parent_id — INT — Foreign key → category.id
  • category_type — VARCHAR — MAIN, SUB, PRODUCT
  • code — VARCHAR
  • name — VARCHAR
  • risk — VARCHAR — HIGH, MEDIUM,LOW

category_translation

  • id — INT — Primary key — NOT NULL
  • category_id — INT — Foreign key → category.id — NOT NULL
  • country_code — VARCHAR — KR, JP, CN
  • name (text) — VARCHAR

linkpay_company

  • id — INT — Primary key — NOT NULL
  • type — VARCHAR — 법인 유형
  • name — VARCHAR
  • country — VARCHAR
  • address — VARCHAR
  • zip_code — VARCHAR
  • phone_country_code — VARCHAR
  • phone_num — VARCHAR
  • shop_url — VARCHAR
  • fund_source — VARCHAR
  • representative_name — VARCHAR

linkpay_login_user

  • id — INT — Primary key — NOT NULL
  • linkpay_user_id — INT — Foreign key → linkpay_user.id — NOT NULL
  • name — VARCHAR
  • gender — VARCHAR
  • date_of_birth — VARCHAR
  • country — VARCHAR
  • phone_country_code — VARCHAR
  • phone_num — VARCHAR
  • address — VARCHAR
  • zip_code — VARCHAR
  • email — VARCHAR
  • password — VARCHAR
  • verification_status — VARCHAR
  • refresh_token — VARCHAR
  • language_code — VARCHAR

linkpay_user

  • id — INT — Primary key — NOT NULL
  • linkpay_company_id — INT — Foreign key → linkpay_company.id — NOT NULL

linkpay_user_activity_history (Untitled)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

linkpay_user_category

  • id — INT — Primary key — NOT NULL
  • linkpay_user_id — INT — Foreign key → linkpay_user.id — NOT NULL
  • category_id — INT — Foreign key → category.id — NOT NULL

linkpay_user_file

  • id — INT — Primary key — NOT NULL
  • linkpay_user_id — INT — Foreign key → linkpay_user.id — NOT NULL
  • path — VARCHAR — NOT NULL
  • orginal_name — VARCHAR — NOT NULL
  • extention — VARCHAR — NOT NULL
  • file_type — VARCHAR — NOT NULL

linkpay_user_history

  • Key (id) — INT — Primary key — NOT NULL
  • linkpay_login_user_id — INT — Foreign key → linkpay_login_user.id — NOT NULL
  • before — JSON
  • after — JSON
  • description — VARCHAR — NOT NULL
  • source — VARCHAR
  • ip_addresss — VARCHAR
  • updated_by — VARCHAR

order

  • id — INT — Primary key — NOT NULL
  • recipient_id — INT — Foreign key → recipient.id — NOT NULL — LINKPAY 유저가 등록한 recipient id
  • transfer_id — INT — Foreign key → transfer.id
  • order_id — VARCHAR — NOT NULL — 주문번호(사용자 직접 입력)
  • order_status — VARCHAR — NOT NULL — CREATED, SUBMITTED,, CANCELLED, EXPIRED
  • total_amount (total_price) — DECIMAL(18,2)
  • token — VARCHAR
  • valid_from — DATETIME
  • valid_to — DATETIME
  • customer_name — VARCHAR
  • currency — VARCHAR
  • recipient_customer_id — INT — MBP 유저가 등록한 recipient id

order_history

  • Key (id) — INT — Primary key — NOT NULL
  • id (order_id) — INT — Foreign key → order.id — NOT NULL
  • before — JSON
  • after — JSON
  • description — VARCHAR — NOT NULL
  • source — VARCHAR
  • ip_addresss — VARCHAR
  • updated_by — VARCHAR

order_item

  • id — INT — Primary key — NOT NULL
  • order_id — INT — Foreign key → order.id — NOT NULL
  • id (category_id) — INT — Foreign key → category.id — NOT NULL
  • quantity — INT — NOT NULL
  • unit_price — DECIMAL(18,2) — NOT NULL
  • total_amount — DECIMAL(18,2) — NOT NULL
  • name — VARCHAR

recipient

  • id — INT — Primary key — NOT NULL
  • linkpay_user_id — INT — Foreign key → linkpay_user.id
  • wallet_id — INT — nullable하게 수정
  • source — VARCHAR — enum 추가 (affiliate, self, authenticated)

transfer

  • id — LONG — Primary key — NOT NULL