Table Description
Table: USER |
||
Column Name |
Column Type |
Description |
UserID |
Int |
PK |
FirstName |
Varchar(30) |
|
LastName |
Varchar(30) |
|
|
Varchar(100) |
|
EmpType |
Char(1) |
¡®S¡¯ or ¡®A¡¯ (S:Salesmane, A:Administrator) |
LoginStatus |
Char(1) |
¡®Y¡¯ or ¡®N¡¯(default) |
Table: Inventory |
||
Column Name |
Column Type |
Description |
ItemID |
Int |
PK |
ItemName |
Varchar(50) |
|
ItemPrice |
Int |
|
ItemQty |
Int |
|
Description |
Varchar(100) |
|
Table: PurchaseOrder |
||
Column Name |
Column Type |
Description |
PurchaseOrderID |
Int |
PK |
ItemID |
Int |
FK |
PurchaseQty |
Int |
|
PurchaseAmount |
Int |
|
PurchaseDate |
Datetime |
|
UserID |
Int |
FK |
Description |
Varchar(100) |
|
Table: SalesOrder |
||
Column Name |
Column Type |
Description |
SalesOrderID |
Int |
PK |
ItemID |
Int |
FK |
SalesQty |
Int |
|
SalesAmount |
Int |
|
SalesDate |
Datetime |
|
UserID |
Int |
FK |
Description |
Varchar(100) |
|