I'm making a sample database to test myself in MySQL workbench and was wondering the following:
I have five tables, Customer, Product, Stock(Quantity), Warehouse and Purchase Order.
For primary keys I have customerId, productId, warehouseId, and invoiceNo...but what would the stocks primary key be? Apologies if the answer is obvious, but as I understand it the foreign key would be the productNo.
Very new to this!
Any input would be greatly appreciated!
SHOW CREATE TABLE {tablename}
also recommended for readability. Welcome to DBA.