Displaying 1 result from an estimated 1 matches for "mfg_models".
Did you mean:
mfg_model
2006 Jun 18
2
Table Relationship for Select option list
...purchased_on date null,
quote_name varchar(20) null,
purchase_order_name varchar(20) null,
ip_address char(64) null,
deployed_on date null,
constraint fk_devices_mfg_model foreign key (mfg_model_id)
references mfg_models(id)
,
primary key (id)
);
create table models (
id int not null unique,
description char(20) not null,
category char(20) not null,
primary key (id)
);
The models table will be statically populated like:
insert into mfg_model (id,description,category) value...