SIMCARD
- Daniel Hostrup Eriksen
- Søren Duusgaard (Deactivated)
Groups
SIMCARD
| Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|
ID | NUMBER | 22 | N | Â | Primary key |
STATUS | NUMBER | 22 | Y | Â | Status, i.e. 0-pre paid, 1-post paid, 2-pre paid card |
ASSIGNED_TO_SERVICE_ID | NUMBER | 22 | Y | Â | Foreign key referencing SERVICE-table |
CREATE_DATE | DATE | 7 | Y | Â | Date of creation |
RESERV_TO_DATE | DATE | 7 | Y | Â | Date to which SIM card is reserved |
IMSI | VARCHAR2 | 100 | Y | Â | International Mobile Subscriber Indentity |
ICC | VARCHAR2 | 100 | Y | Â | Integrated Circuit Card |
PIN1 | VARCHAR2 | 100 | Y | Â | PIN code |
PIN2 | VARCHAR2 | 100 | Y | Â | Second PIN code |
PUK1 | VARCHAR2 | 100 | Y | Â | Personal unblocking code |
PUK2 | VARCHAR2 | 100 | Y | Â | Second personal unblocking code |
TYPE | VARCHAR2 | 100 | Y | Â | Status name |
COMMENTS | VARCHAR2 | 1000 | Y | Â | Comments |
USERCLIENT | VARCHAR2 | 100 | Y | Â | Operator name |
LOCATION | VARCHAR2 | 100 | Y | Â | Location |
BLOCKED_FROM_DATE | DATE | 7 | Y | Â | Date on which SIM card is to be blocked |
MARS_SYNC_DATE | DATE | 7 | Y | Â | Â |
ASSIGNED_ANUMBER_ID | NUMBER | 22 | Y | Â | Foreign key referencing A_NUMBER.ID |
NETWORK_ID | NUMBER | 22 | Y | Â | Foreign key referencing NETWORK_OPERATOR.ID |
KI | VARCHAR2 | 32 | Y | Â | Â |
CHANGE_PENDING | VARCHAR2 | 1 | Y | Â | Â |
SIM_TYPE_ID | NUMBER | 22 | Y | Â | SIM card type |
NETWORK_STATUS | NUMBER | 22 | Y | Â | Â |
BRAND_ID | NUMBER | 22 | Y | Â | Foreign key referencing BRAND.ID |
INITIAL_AMOUNT | NUMBER | 22 | Y | Â | For a situation when the SIM card is loaded with some initial amount |
| SIMCARD_GROUP_ID | NUMBER | Â | Â | Â | Added with 10.3.1 |