tripal_feature.schema.api.inc 1.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  1. <?php
  2. /**
  3. * @file
  4. * Further describe some of the feature tables to the tripal schema
  5. */
  6. /**
  7. * Implements hook_chado_schema_v1_2_tripal_gff_temp()
  8. * Purpose: To describe the structure of 'tripal_gff_temp' to tripal
  9. * @see chado_insert_record()
  10. * @see chado_update_record()
  11. * @see chado_select_record()
  12. *
  13. * @return
  14. * An array describing the 'tripal_gff_temp' table
  15. *
  16. * @ingroup tripal_chado_v1.2_schema_api
  17. *
  18. */
  19. function tripal_feature_chado_schema_v1_2_tripal_gff_temp() {
  20. $schema = array(
  21. 'table' => 'tripal_gff_temp',
  22. 'fields' => array(
  23. 'feature_id' => array(
  24. 'type' => 'int',
  25. 'not null' => TRUE,
  26. ),
  27. 'organism_id' => array(
  28. 'type' => 'int',
  29. 'not null' => TRUE,
  30. ),
  31. 'uniquename' => array(
  32. 'type' => 'text',
  33. 'not null' => TRUE,
  34. ),
  35. 'type_name' => array(
  36. 'type' => 'varchar',
  37. 'length' => '1024',
  38. 'not null' => TRUE,
  39. ),
  40. ),
  41. 'indexes' => array(
  42. 'tripal_gff_temp_idx0' => array('feature_id'),
  43. 'tripal_gff_temp_idx0' => array('organism_id'),
  44. 'tripal_gff_temp_idx1' => array('uniquename'),
  45. ),
  46. 'unique keys' => array(
  47. 'tripal_gff_temp_uq0' => array('feature_id'),
  48. 'tripal_gff_temp_uq1' => array('uniquename', 'organism_id', 'type_name'),
  49. ),
  50. );
  51. return $schema;
  52. }