1. dbo.contacts
1.1. id
1.2. public_device_record_key
1.3. phone
1.4. email
1.4.1. if not provided, xx@xx.xx
1.5. extension
2. dbo.identifiers
2.1. id
2.2. public_device_record_key
2.3. device_id
2.4. pkg_quantity
2.5. pkg_discontinue_date
2.5.1. YYYY-MM-DD
2.6. pkg_status
2.6.1. In Commercial Distribution
2.6.2. Not in Commercial Distribution
2.7. pkg_type
2.8. device_id_type
2.8.1. Primary
2.8.2. Secondary
2.8.3. Direct Marking
2.8.4. Unit of Use
2.8.5. Package
2.8.6. Previous
2.9. device_id_issuing_agency
2.9.1. NDC/NHRIC
2.9.2. HIBCC
2.9.3. ICCBBA
2.9.4. GS1
2.10. contains_di_number
3. dbo.gmdn_terms
3.1. id
3.2. public_device_record_key
3.3. gmdn_pt_name
3.4. gmdn_pt_definition
4. dbo.product_codes
4.1. product_code
4.2. product_code_name
4.3. id
4.4. public_device_record_key
5. dbo.sterilization
5.1. dbo.method_types
5.1.1. id
5.1.2. sterilization_id
5.1.3. sterilization_method
5.2. id
5.3. public_device_record_key
5.4. device_sterile
5.5. sterilization_prior_to_use
6. dbo.environmental_conditions
6.1. id
6.2. public_device_record_key
6.3. storage_handling_type
6.3.1. Storage Environment Humidity
6.3.2. Storage Environment Atmospheric Pressure
6.3.3. Storage Environment Temperature
6.3.4. Special Storage Conditions
6.3.5. Handling Environment Temperature
6.3.6. Handling Environment Humidity
6.3.7. Handling Environment Atmospheric Pressure
6.4. storage_handling_special_condition_text
6.5. dbo.storage_handling_extrema
6.5.1. id
6.5.2. environmental_conditions_id
6.5.3. extrema
6.5.3.1. high
6.5.3.2. low
6.5.4. value
6.5.5. unit
6.5.5.1. Percent (%) Relative Humidity, Millibar
6.5.5.2. Kilo Pascal
6.5.5.3. Degrees Kelvin
6.5.5.4. Degrees Fahrenheit
6.5.5.5. Degrees Celsius
7. dbo.pre_market_submissions
7.1. id
7.2. public_device_record_key
7.3. supplement_number
7.4. submission_number
8. dbo.attributes
8.1. id
8.2. public_device_record_key
8.3. public_version_status
8.3.1. New
8.3.2. Update
8.3.3. Delete
8.4. device_record_status
8.4.1. Published
8.4.2. Unpublished
8.4.3. Deactivated
8.5. public_version_number
8.6. public_version_date
8.6.1. YYYY-MM-DD
8.7. device_publish_date
8.7.1. YYYY-MM-DD
8.8. device_comm_distribution_end_date
8.8.1. YYYY-MM-DD
8.9. device_comm_distribution_status
8.9.1. In Commercial Distribution
8.9.2. Not in Commercial Distribution
8.10. brand_name
8.11. version_model_number
8.12. catalog_number
8.13. duns_number
8.14. company_name
8.15. device_count
8.16. device_description
8.17. dm_exempt
8.18. premarket_exempt
8.19. device_hctp
8.20. device_combination_product
8.21. single_use
8.22. lot_batch
8.23. serial_number
8.24. manufacturing_date
8.25. expiration_date
8.26. donation_id_number
8.27. labeled_contains_nrl
8.28. labeled_no_nrl
8.29. rx
8.30. otc
8.31. mri_safety_status
8.31.1. MR Safe
8.31.2. MR Unsafe
8.31.3. MR Conditional
8.31.4. Labeling does not contain MRI Safety Information
9. dbo.device_sizes
9.1. public_device_record_key
9.2. id
9.3. type
9.3.1. Outer Diameter
9.3.2. Angle
9.3.3. Area/Surface Area
9.3.4. Pore Size
9.3.5. Pressure
9.3.6. Weight
9.3.7. Width
9.3.8. Total Volume
9.3.9. Height
9.3.10. Needle Gauge
9.3.11. Lumen/Inner Diameter
9.3.12. Length
9.3.13. Catheter Gauge
9.3.14. Device Size Text, specify
9.3.15. Circumference
9.3.16. Depth