search for: fk_devices_mfg_model

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...