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 |