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