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