Test1

Tables (6)

AccountManagement (correspondent)

  • Distributor (ori) — char(20) — Primary key — NOT NULL
  • NewAccount (new) — char(25) — Primary key — NOT NULL
  • Distributor change (update) — char(25) — Primary key — NOT NULL

ChangeOfDistirbutorInformation (update)

  • Distributor (ori) — char(20) — Foreign key → AccountManagement.Distributor — NOT NULL
  • NewAccount (new) — char(25) — Foreign key → AccountManagement.NewAccount — NOT NULL
  • Distributor change (update) — char(25) — Foreign key → AccountManagement.Distributor change — NOT NULL
  • EditAccount (change) — char(25)
  • DeleteAccount (delete) — char(25)

ExistingDistributor (Original)

  • accountName (g_name) — char(25) — Primary key — NOT NULL
  • Distributor (ori) — char(20) — Foreign key → AccountManagement.Distributor — NOT NULL
  • NewAccount (new) — char(25) — Foreign key → AccountManagement.NewAccount — NOT NULL
  • Distributor change (update) — char(25) — Foreign key → AccountManagement.Distributor change — NOT NULL
  • accountNumber (g_no) — int
  • TransactionAmount (g_money) — int
  • TransactionDate (g_date) — date
  • TransactionStart (g_start) — date
  • TradingGoods (g_name2) — char(25)

NewAccount (New)

  • Distributor (ori) — char(20) — Foreign key → AccountManagement.Distributor — NOT NULL
  • NewAccount (new2) — char(25) — Foreign key → AccountManagement.NewAccount — NOT NULL
  • Distributor change (update) — char(25) — Foreign key → AccountManagement.Distributor change — NOT NULL
  • AccountRegistration (new) — char(25)

ReceipManagement (Processing)

  • ImporterName (P_name) — char(25) — Primary key — NOT NULL
  • InventoryReceiptNum (P_ Reno) — int
  • InventoryNum (P_no) — int
  • accountName (g_name) — char(25) — Foreign key → ExistingDistributor.accountName — NOT NULL
  • Distributor (ori2) — char(20) — Foreign key → NewAccount.Distributor — NOT NULL
  • Distributor change (update2) — char(25) — Foreign key → NewAccount.Distributor change — NOT NULL
  • NewAccount (new3) — char(25) — Foreign key → ChangeOfDistirbutorInformation.NewAccount — NOT NULL

SalesManagement (Sale)

  • CustomerNumber (client_no) — int — Primary key — NOT NULL
  • CheckInventory (check) — char(25)
  • InventoryNum (S_no) — int
  • TransactionListNum (S_num) — i nt
  • IncomeAmount (S_money) — int
  • accountName (g_name) — char(25) — Foreign key → ExistingDistributor.accountName — NOT NULL
  • Distributor (ori) — char(20) — Foreign key → ExistingDistributor.Distributor — NOT NULL
  • NewAccount (new) — char(25) — Foreign key → ExistingDistributor.NewAccount — NOT NULL
  • Distributor change (update) — char(25) — Foreign key → ExistingDistributor.Distributor change — NOT NULL