Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
id |
char |
36 |
|
|
|
|
|
deleted |
bit |
1 |
√ |
|
0 |
|
|
date_entered |
datetime |
19 |
√ |
|
null |
|
|
date_modified |
datetime |
19 |
√ |
|
null |
|
|
modified_user_id |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
created_by |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
type_id |
char |
36 |
√ |
|
null |
|
|
manufacturer_id |
char |
36 |
√ |
|
null |
|
|
category_id |
char |
36 |
√ |
|
null |
|
|
name |
varchar |
50 |
√ |
|
null |
|
|
mft_part_num |
varchar |
50 |
√ |
|
null |
|
|
vendor_part_num |
varchar |
50 |
√ |
|
null |
|
|
date_cost_price |
date |
10 |
√ |
|
null |
|
|
cost_price |
decimal |
26,6 |
√ |
|
null |
|
|
discount_price |
decimal |
26,6 |
√ |
|
null |
|
|
list_price |
decimal |
26,6 |
√ |
|
null |
|
|
cost_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
discount_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
list_usdollar |
decimal |
26,6 |
√ |
|
null |
|
|
currency_id |
char |
36 |
√ |
|
null |
|
|
currency |
varchar |
255 |
√ |
|
null |
|
|
status |
varchar |
100 |
√ |
|
null |
|
|
tax_class |
varchar |
100 |
√ |
|
null |
|
|
date_available |
date |
10 |
√ |
|
null |
|
|
website |
varchar |
255 |
√ |
|
null |
|
|
weight |
decimal |
12,2 |
√ |
|
null |
|
|
qty_in_stock |
int |
5 |
√ |
|
null |
|
|
description |
text |
65535 |
√ |
|
null |
|
|
support_name |
varchar |
50 |
√ |
|
null |
|
|
support_description |
varchar |
255 |
√ |
|
null |
|
|
support_contact |
varchar |
50 |
√ |
|
null |
|
|
support_term |
varchar |
100 |
√ |
|
null |
|
|
pricing_formula |
varchar |
100 |
√ |
|
null |
|
|
pricing_factor |
decimal |
8,2 |
√ |
|
null |
|
|
Analyzed at Wed May 08 16:48 PDT 2013
|