Palipay ERD
Tables (17)
account_histories
- history_id — bigint — Primary key — NOT NULL
- wallet_id — bigint — Foreign key → wallet_pali.wallet_id — NOT NULL
- user_id — bigint — NOT NULL
- workplace_id — bigint — Foreign key → workplace.workplace_id
- category — ENUM('INPUT', 'OUTPUT')
- amount — decimal(16, 4)
- exchange_after_amount — bigint
- exchange_rate — decimal(10, 4)
- other_account_number — varchar(30)
- other_account_name — varchar(30)
- other_bank_code — varchar(30)
- description — text
- created_at — timestamp
account_histories_ch
- history_id — bigint — Primary key — NOT NULL
- bank_id — bigint — Foreign key → bank_ch.bank_id
- user_id — bigint — Foreign key → user_bank_ch.user_id
- category — ENUM('INPUT', 'OUTPUT')
- amount — decimal(19,2)
- other_account_number — varchar(50)
- other_account_name — varchar(100)
- other_bank_code — varchar(20)
- created_at — datetime
account_histories_jp
- history_id — bigint — Primary key — NOT NULL
- bank_id — bigint — Foreign key → bank_jp.bank_id
- user_id — bigint — Foreign key → user_bank_jp.user_id
- category — ENUM('INPUT', 'OUTPUT')
- amount — decimal(19,2)
- other_account_number — varchar(50)
- other_account_name — varchar(50)
- other_bank_code — varchar(20)
- created_at — datetime
account_histories_kr
- history_id — bigint — Primary key — NOT NULL
- bank_id — bigint — Foreign key → bank_kr.bank_id
- user_id — bigint — Foreign key → user_bank_kr.user_id
- category — ENUM('INPUT', 'OUTPUT')
- amount — decimal(19,2)
- other_account_number — varchar(50)
- other_account_name — varchar(50)
- other_bank_code — varchar(20)
- created_at — datetime
account_histories_us
- history_id — bigint — Primary key — NOT NULL
- bank_id — bigint — Foreign key → bank_us.bank_id
- user_id — bigint — Foreign key → user_bank_us.user_id
- category — ENUM('INPUT', 'OUTPUT')
- amount — decimal(19,2)
- other_account_number — varchar(50)
- other_account_name — varchar(100)
- other_bank_code — varchar(20)
- created_at — datetime
bank_ch
- bank_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user_bank_ch.user_id
- user_name — varchar(100)
- account_number — varchar(50)
- amount — decimal(19,2)
- bank_code — varchar(20)
- account_password — varchar(255)
- bank_name — varchar(255)
- created_at — datetime
- updated_at — datetime
bank_jp
- bank_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user_bank_jp.user_id
- user_name — varchar(255)
- account_number — varchar(255)
- amount — decimal(19,2)
- bank_code — varchar(50)
- account_password — varchar(255)
- bank_name — varchar(255)
- created_at — datetime
- updated_at — datetime
bank_kr
- bank_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user_bank_kr.user_id
- user_name — varchar(255)
- account_number — varchar(255)
- amount — decimal(19,2)
- bank_code — varchar(50)
- account_password — varchar(255)
- bank_name — varchar(255)
- created_at — datetime
- updated_at — datetime
bank_us
- bank_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user_bank_us.user_id
- user_name — varchar(100)
- account_number — varchar(50)
- amount — decimal(19,2)
- bank_code — varchar(20)
- account_password — varchar(255)
- bank_name — varchar(255)
- created_at — datetime
- updated_at — datetime
business
- business_id — bigint — Primary key — NOT NULL
- account_number — varchar(255) — Foreign key → bank_kr.account_number — NOT NULL
- business_person — varchar(255) — NOT NULL
- business_number — varchar(255) — NOT NULL
- company_name — varchar(255)
- business_address — varchar(255)
- created_at — datetime(6)
- updated_at — datetime(6)
user_bank_ch
- user_id — bigint — Primary key — NOT NULL
- email — varchar(255)
- password — varchar(255)
- currency — varchar(100)
- status — ENUM('ACTIVE', 'INACTIVE')
- created_at — timestamp
- updated_at — timestamp
user_bank_jp
- user_id — bigint — Primary key — NOT NULL
- email — varchar(255)
- password — varchar(255)
- currency — varchar(100)
- status — ENUM('ACTIVE', 'INACTIVE')
- created_at — timestamp
- updated_at — timestamp
user_bank_kr
- user_id — bigint — Primary key — NOT NULL
- email — varchar(255)
- password — varchar(255)
- currency — varchar(100)
- status — ENUM('ACTIVE', 'INACTIVE')
- created_at — timestamp
- updated_at — timestamp
user_bank_us
- user_id — bigint — Primary key — NOT NULL
- email — varchar(255)
- password — varchar(255)
- currency — varchar(100)
- status — ENUM('ACTIVE', 'INACTIVE')
- created_at — timestamp
- updated_at — timestamp
user_pali
- user_id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255)
- password — varchar(255)
- phone_number — varchar(255)
- status — ENUM('ACTIVE', 'INACTIVE')
- created_at — timestamp
- updated_at — timestamp
- country_code — VARCHAR(10)
wallet_pali
- wallet_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user_pali.user_id — NOT NULL
- account_number — varchar(30)
- money_code — varchar(20)
- account_username — varchar(30)
- bank_code — varchar(20)
- amount — decimal(16, 4)
- pin_number — varchar(6)
- created_at — timestamp
- updated_at — timestamp
workplace
- workplace_id — bigint — Primary key — NOT NULL
- location — varchar(50)
- company_name — varchar(30)
- business_number — varchar(30)
- created_at — timestamp
- updated_at — timestamp