Attributes |
|
Physical Name: |
id |
Primary Key |
|
NOT NULL |
|
Unique |
|
Logical Type: |
INTEGER |
Physical Type: |
INTEGER |
Size: |
10 |
Physical Declaration: |
id:INTEGER NOT NULL |
|
|
|
Physical Name: |
valid_Starting |
Logical Type: |
TIMESTAMP |
Physical Type: |
DATETIME |
Size: |
9 |
Physical Declaration: |
valid_Starting:DATETIME |
|
|
|
Physical Name: |
not_Valid_After |
Logical Type: |
TIMESTAMP |
Physical Type: |
DATETIME |
Size: |
9 |
Physical Declaration: |
not_Valid_After:DATETIME |
|
|
|
Physical Name: |
price |
Logical Type: |
NUMERIC |
Physical Type: |
CURRENCY |
Size: |
9 |
Physical Declaration: |
price:CURRENCY |
|
|
|
Physical Name: |
price_Qty |
Logical Type: |
INTEGER |
Physical Type: |
INTEGER |
Size: |
10 |
Physical Declaration: |
price_Qty:INTEGER |
|
|
|
Physical Name: |
price_UOM |
Logical Type: |
INTEGER |
Physical Type: |
INTEGER |
Size: |
10 |
Physical Declaration: |
price_UOM:INTEGER |
|
|
|
Physical Name: |
status |
Logical Type: |
INTEGER |
Physical Type: |
INTEGER |
Size: |
10 |
Physical Declaration: |
status:INTEGER |
|
|
|
Physical Name: |
item_Number |
NOT NULL |
|
Logical Type: |
VARCHAR |
Physical Type: |
VARCHAR |
Size: |
50 |
Physical Declaration: |
item_Number:VARCHAR(50) NOT NULL |
Is foreign key |
|
Referenced Attribute: |
|
Referenced Entity: |
|
|