| 컬럼명 |
자료형 |
널가능 |
설명
|
| ProductID |
int |
|
(주키) 제품ID
|
| Name |
Name (user-defined type) / nvarchar(50) |
|
제품명
|
| ProductNumber |
nvarchar(25) |
|
제품번호
|
| MakeFlag |
Flag (user-defined type) / bit |
|
0 = Product is purchased. / 1 = Product is manufactured in-house.
|
| FinishedGoodsFlag |
Flag (user-defined type) / bit |
|
0 = Product is not a salable item. / 1 = Product is salable.
|
| Color |
nvarchar(15) |
O |
제품색상
|
| SafetyStockLevel |
smallint |
|
최소 재고량
|
| ReorderPoint |
smallint |
|
Inventory level that triggers a purchase order or work order.
|
| StandardCost |
money |
|
표준비용
|
| ListPrice |
money |
|
판매가격
|
| Size |
nvarchar(5) |
O |
제품크기
|
| SizeUnitMeasureCode |
nchar(3) |
O |
제품크기의 단위
|
| WeightUnitMeasureCode |
nchar(3) |
O |
제품무게의 단위
|
| Weight |
decimal (8,2) |
O |
제품무게
|
| DaysToManufacture |
int |
|
Number of days required to manufacture the product.
|
| ProductLine |
nchar(2) |
O |
R = Road / M = Mountain / T = Touring / S = Standard
|
| Class |
nchar(2) |
O |
H = High / M = Medium / L = Low
|
| Style |
nchar(2) |
O |
W = Women's / M = Men's / U = Universal
|
| ProductSubcategoryID |
smallint |
O |
Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID.
|
| ProductModelID |
int |
O |
제품모델ID
|
| SellStartDate |
datetime |
|
판매시작일자
|
| SellEndDate |
datetime |
O |
판매종료일자
|
| DiscontinuedDate |
datetime |
O |
단종일자
|
| rowguid |
uniqueidentifier ROWGUIDCOL |
|
GUID
|
| ModifiedDate |
datetime |
|
최근 업데이트 일시
|
