Groups
SMS_MESSAGES_RECEIVED
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | STATUS_ID | NUMBER | 22 | Y | ||
| 3 | MOBILE_NUMBER | VARCHAR2 | 80 | Y | ||
| 4 | SHORT_CODE | VARCHAR2 | 80 | Y | ||
| 5 | MESSAGE | VARCHAR2 | 2000 | Y | ||
| 6 | RECEIVE_DATE | DATE | 7 | Y | ||
| 7 | SERVICE_ID | NUMBER | 22 | Y | ||
| 8 | RECIPIENT | VARCHAR2 | 80 | Y | ||
| 9 | TRANSACTION_ID | VARCHAR2 | 200 | Y | ||
| 10 | REFERENCE | VARCHAR2 | 200 | Y |