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