Rambler's Top100





Приложение Л
Пример физической модели данных в нотации IDEF1X
Delivery
Account
Tovar
ID_Tovar
ID_Group (FK)
Name
Mesure
Price
Sclad
Description
Client
ID_Client
Name
Date
INN
Adress
Telephone
R/S
BIK
K/S
e-mail
Account_tovar
Account_Number (FK)
ID_Tovar (FK)
amount
Delivery_tovar
ID_Deliver (FK)
ID_Tovar (FK)
amount
Account_Inf
Account_Number
ID_Client (FK)
Date
Type_of_payment
Pay_mark
Return_mark
Note
Delivery_Inf
ID_Deliver
ID_Supplier (FK)
Date_of_order
Date_of_arrival
Arrival_mark
Note
Supplier
ID_Supplier
Name
Adress
Telephone
Bank_inf
e-mail
Note
Tovar_group
ID_Group
Group_name
Note
Return
ID_return
Account_Number (FK)
Date
Note
ID_Tovar (FK)
amount