DPM_CONTENTS

The DPM_CONTENTS table manages the contents of each well in each plate. It is organized into five content types: cell, drug, indicator, medium and target. The value for these contents is stored in the DPM_CONTYPES table and accessed with a primary key. Finally, the conentration of each of these values is also stored.

Columns

No Name Domain Dty Len Scale Nulls Foreign Key Description
1 CON_PLT_ID _DPM_PLATE_ID I 4   N DPM_PLATE.PLT_ID 'ID' is the unique identifier for a Plate. 'ID' is stored in the DPM_PLATE table. [Format: Int Range: 0 - 99999]
2 CON_WLL_ID _DPM_SEQ I 2   N   WELL_ID is the position of a well in a microtiter tray. Well IDs are numbered from top to bottom starting in the left column and moving to the right column. [Format: 999 Range: 1-999]
3 CON_TYPE _DPM_CODE I 2   N   'Content types': Cell is the name of the host cell used in cell dependent assays; Drug is the name of the compound being tested; Indicator is the name of the radioisotope or color reagent that measures compound activity; Medium is the name of the culture medium and nutritional supplements; Target is the name given to a pathogen or protein target. 'Content types' are stored in the DPM_CONTYPES table.

Values:
0 CELL
1 DRUG
2 INDICATOR
3 MEDIUM
4 TARGET

4 CON_CTY_PK _DPM_PK I 4   N DPM_CONTYPES.DPM_PK References a Primary Key in another table (Foreign Key) [Format 9999 Range 0 - 9999]
5 CON_CONC _DPM_CONC N 10 3 N   CONC is the concentration of an item in a particular well in a microtiter tray. The unit for concentration is defined in the UNIT field. [Format: 9999.999 Range: 0.001 - 9999.999]
6 CON_ATY_PK _DPM_PK I 4   N DPM_AUXTYPES.DPM_PK References a Primary Key in another table (Foreign Key) [Format 9999 Range 0 - 9999]

Dependents

Updated 08 Mar 2000.