tripal_feature.schema.api.inc 1.2 KB

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