Groups
A_NUMBER
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | 'Primary' key | |
| 2 | STATUS | NUMBER | 22 | Y | Status of the number, 0-active, 1-in use, 2-reserved, 3-rest period, 4-barred, 5-exported, 100-reserved for anumber sequence | |
| 3 | ASSIGNED_TO_SERVICE_ID | NUMBER | 22 | Y | Service to which the number belongs | |
| 4 | CREATE_DATE | DATE | 7 | Y | Date of creating number | |
| 5 | RESERV_TO_DATE | DATE | 7 | Y | Date to which to reserve number | |
| 6 | A_NUMBER | VARCHAR2 | 100 | Y | Mobile number | |
| 7 | COMMENTS | VARCHAR2 | 1000 | Y | Add. comments | |
| 8 | GROUP_ID | NUMBER | 22 | Y | References ANUMBER_GROUP-table | |
| 9 | USERCLIENT | VARCHAR2 | 100 | Y | ? | |
| 10 | OPERATOR_ID | NUMBER | 22 | Y | Network operator creating the number | |
| 11 | RS_EXCHANGE_ID | NUMBER | 22 | Y | ? | |
| 12 | BRAND_ID | NUMBER | 22 | Y | References BRAND-table |
Contains all MSISDNs