Displaying 1 result from an estimated 1 matches for "fk_devices_mfg_model".
2006 Jun 18
2
Table Relationship for Select option list
...null,
purchase_price decimal(10,2) not null,
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:
ins...