Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
usage record for a part in nodelist
11-11-2015, 10:28 AM
Post: #1
usage record for a part in nodelist
We may create a table to track usage record of a part.

A basic design like below:

-- 1. create a table A to record usage record of a part. have such attributes.
----- 1.1 S/N (foreign key from part)
----- 1.2 recorder
----- 1.3 action
----- 1.4 status
----- 1.5 status
----- 1.6 date
-- 2. add a link to a part and point to page B.
-- 3. page B: query databases and show the usage record in a page. The SQL sentence may like this 'select * from A where S/N='SFP20151111' order by time', like 'allParts.php'
--4 . page C: use this page to add each operation of a part like 'edit/addPart.php'

so we can track a part like an express smoothly.
Quote this message in a reply
Post Reply 


Messages In This Thread
usage record for a part in nodelist - amoners - 11-11-2015 10:28 AM
RE: usage record for a part in nodelist - amoners - 11-11-2015, 10:48 AM

Forum Jump: