usage record for a part in nodelist

[lingu]

(11-11-2015 10:28 AM)amoners Wrote:  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'

so we can track a part like an express smoothly.

What is the use case for this function?

I thought we just needed to add a MSN (Manufacturer S/N) for searching a particular item with the MSN.

The usage info is currently handled by associating a component (e.g, a RAM module) to another (e.g., a server).

If we want to track the usage of the handling of the item, we can add notes to the 'note' attribute, or write records on TaB and add the link to the TaB thread to the 'note' attribute.

So I am not sure why we need to create a new table. What is the use case that motivated this, and why can't it be handled with the scheme I outlined above?