Construction Database Tables

NB: the last 3 columns are not part of the DB table but simply a spacer and a record of the Draft/Final status of that line and a comment entry.

ItemType

Name
(Required) Name of Item Type
Description
(Required) Futher description of Item Type
Url
(Optional) link to web page describing Item Type
Isunique
(Required) Does each Item of this Item Type have a unique serial no. - Are we tracking these items individually (true) or in batches (false).

Name Description Url Isunique - STATE COMMENT
-TAPES- - - - - - -
Track Layer - - Y - - -
Screen Layer - - Y - - -
Glue Layer - - N - - -
Cover Layer 1 - - N - - -
Cover Layer 2 - - N - - -
Tape Design - - Y - - ?
Production Tape - - N - - ?
Prototype Tape - - N - - ?
Tape - - Y - - -
Track+CoverLayer - - Y - - -
-Cooling- - - - - DRAFT -
Raw Pipe as received - N - - -
Bent pipe - - N - - -
Fitting - - N - - -
Insulating Break - - ? - - possible in future
Fitting Subassy Fitting + Stub - Y - - -
Bent Pipe + Fitting Subassy - - Y - - -
  - -   - - -

  - -   - - -

TestType

Name
(Required) Name of Item Type
Description
(Required) Futher description of Item Type
Url
(Optional) link to web page describing Item Type
Isgeneric
(Required) Does the Test store and special values (False) or does it just upload a file (eg: pdf) (True)

Name Description Url Isgeneric - STATE COMMENT
-TAPES- - - - - - -
Dimensions Reception - -   - - -
Trace Dimentions Reception - -   - - IS THIS SAME AS ABOVE?
Dimensions Lamination - -   - - -
Dimensions Co-Cure - -   - - -
Weight Lamination - -   - - -
Electrical Reception - -   - - -
Electrical Plating - -   - - -
Electrical Lamination - -   - - -
Electrical Co-Cure - -   - - -
Electrical Final - -   - - -
Pull Test - - Y - - -
Optical Inspection - - Y - - store x,y of problems in a txt file
Comment Test - - Y - - Generic test to add a comment to a component
-Cooling- - - - - DRAFT -
Reception Test - -   - - -
Bend Parameters - -   - - -
Dimension Check - -   - - of the loop
Pipe Design - -   - - info about the exact design
Weight - -   - - of final product
Dimensions - -   - - of final product
Pressure test - -   - - -
Leak Test - -   - - -
Temp Shock Test - -   - - -
Welding Parameters - -   - - For subassy, intermidiate and final welds (possible same "Test")
  - -   - - -

Notes

Raw cooling pipe (batch) Cut@lancs => batch Fittings (batch) Test Fittings (batch) - test converters assembled @ sheffield (unique) TESTED @ sheffield - weld TEST ship to Al RAL pressure TEST

-- AlexOwen - 06-Aug-2012

Topic attachments
I Attachment History Action Size Date Who Comment
PDFpdf AUCDB-notesfromfacetoface.pdf r1 manage 798.6 K 2013-06-06 - 15:27 AlexOwen Notes from face to face meeting discussing the properties of the items that need to be in the DB
Edit | Attach | Watch | Print version | History: r10 < r9 < r8 < r7 < r6 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r10 - 2013-06-06 - AlexOwen
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    Sandbox All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback