| COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS |
|---|---|---|---|---|---|
| NAME | VARCHAR2(256 BYTE) | Yes | null | 1 | null |
| ARTIST | VARCHAR2(256 BYTE) | Yes | null | 2 | null |
| COMPOSER | VARCHAR2(256 BYTE) | Yes | null | 3 | null |
| ALBUM | VARCHAR2(256 BYTE) | Yes | null | 4 | null |
| GROUPING | VARCHAR2(256 BYTE) | Yes | null | 5 | null |
| GENRE | VARCHAR2(256 BYTE) | Yes | null | 6 | null |
| SIZE_ON_DISC | NUMBER(38,0) | Yes | null | 7 | null |
| TIME | NUMBER(38,0) | Yes | null | 8 | null |
| DISC_NUMBER | NUMBER(38,0) | Yes | null | 9 | null |
| DISC_COUNT | NUMBER(38,0) | Yes | null | 10 | null |
| TRACK_NUMBER | NUMBER(38,0) | Yes | null | 11 | null |
| TRACK_COUNT | NUMBER(38,0) | Yes | null | 12 | null |
| YEAR | NUMBER(38,0) | Yes | null | 13 | null |
| DATE_MODIFIED | VARCHAR2(256 BYTE) | Yes | null | 14 | null |
| DATE_ADDED | VARCHAR2(256 BYTE) | Yes | null | 15 | null |
| BIT_RATE | NUMBER(38,0) | Yes | null | 16 | null |
| SAMPLE_RATE | NUMBER(38,0) | Yes | null | 17 | null |
| VOLUME_ADJUSTMENT | NUMBER(38,0) | Yes | null | 18 | null |
| KIND | VARCHAR2(256 BYTE) | Yes | null | 19 | null |
| EQUALIZER | VARCHAR2(1 BYTE) | Yes | null | 20 | null |
| COMMENTS | VARCHAR2(256 BYTE) | Yes | null | 21 | null |
| PLAYS | VARCHAR2(4 BYTE) | Yes | null | 22 | null |
| LAST_PLAYED | VARCHAR2(17 BYTE) | Yes | null | 23 | null |
| SKIPS | VARCHAR2(3 BYTE) | Yes | null | 24 | null |
| LAST_SKIPPED | VARCHAR2(16 BYTE) | Yes | null | 25 | null |
| MY_RATING | VARCHAR2(1 BYTE) | Yes | null | 26 | null |
| LOCATION | VARCHAR2(256 BYTE) | Yes | null | 27 | null |
| TASTES_GOOD_WITH | NUMBER(38,0) | Yes | null | 28 | null |
| ID | NUMBER(38,0) | No | null | 29 | null |