![]() SELECT i.item_id, 'Initial Order', 10000, '' INSERT INTO inventory_flow(item_id, project, num_ordered, action_date) INSERT INTO inventory(item_name) VALUES('Pippette Tip 10ul') INSERT INTO inventory(item_name) VALUES('Phenol (ul)') INSERT INTO inventory(item_name) VALUES('DNA Ligase (ul)') INSERT INTO inventory(item_name) VALUES('CSCL (g)') CREATE TABLE inventoryĬONSTRAINT pk_inventory PRIMARY KEY (item_id),ĬONSTRAINT inventory_item_name_idx UNIQUE (item_name)ĬONSTRAINT pk_inventory_flow PRIMARY KEY (inventory_flow_id),ĬONSTRAINT fk_item_id FOREIGN KEY (item_id)ĬREATE INDEX inventory_flow_action_date_idx Code to generate structure and test data is shown below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |