create a custom field schema
No, it won't be recognized by Field API. By default Drupal uses Field Api and Field Storage API to store field data. It creates two tables for every new field which you create from Field UI (field_data_* and field_revision_*). If you are able to create your own Storage for Field Api then you can use it... Here are some resources:


Field Storage API
Useful discussion