Groups
A_NUMBER
| Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|
ID | NUMBER | 22 | N | 'Primary' key | |
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 | |
ASSIGNED_TO_SERVICE_ID | NUMBER | 22 | Y | Service to which the number belongs | |
CREATE_DATE | DATE | 7 | Y | Date of creating number | |
RESERV_TO_DATE | DATE | 7 | Y | Date to which to reserve number | |
A_NUMBER | VARCHAR2 | 100 | Y | Mobile number | |
COMMENTS | VARCHAR2 | 1000 | Y | Add. comments | |
GROUP_ID | NUMBER | 22 | Y | References ANUMBER_GROUP-table | |
USERCLIENT | VARCHAR2 | 100 | Y | ? | |
OPERATOR_ID | NUMBER | 22 | Y | Network operator creating the number | |
RS_EXCHANGE_ID | NUMBER | 22 | Y | ? | |
BRAND_ID | NUMBER | 22 | Y | References BRAND-table |
Contains all MSISDNs