Displaying 1 result from an estimated 1 matches for "mfg_model_id".
2006 Jun 18
2
Table Relationship for Select option list
...to manage WLAN
hardware. I''ve created a table to hold information on each device with
the following (model refers to the manufacturer''s model number):
create table devices (
id int not null auto_increment,
hostname varchar(64) null,
mfg_model_id int not null,
serial_number varchar(20) null,
location varchar(20) not null,
shipped_on date null,
purchase_price decimal(10,2) not null,
purchased_on date null,
quote_name varchar(20) null,...