SMS_MESSAGES_RECEIVED
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 | Â | Â |
Â
Â