|
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. |
|||
|
« Next Oldest | Next Newest »
|
| 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 - lingu - 11-11-2015, 10:42 AM
RE: usage record for a part in nodelist - amoners - 11-11-2015, 10:48 AM
RE: usage record for a part in nodelist - lingu - 11-11-2015, 11:53 AM
|
- View a Printable Version
- Send this Thread to a Friend
- Subscribe to this thread
- Show the subscribers of this thread:
- Add subscribers to this thread:

Search
Member List
Calendar
Help
