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) |
|