| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments | 1 |
|---|
ID | NUMBER | 22 | N | | Primary key2 |
STATUS | NUMBER | 22 | Y | | Status, i.e. 0-pre paid, 1-post paid, 2-pre paid card |
| 3 | ASSIGNED_TO_SERVICE_ID | NUMBER | 22 | Y | | Foreign key referencing SERVICE-table |
| 4 | CREATE_DATE | DATE | 7 | Y | | Date of creation |
| 5 | RESERV_TO_DATE | DATE | 7 | Y | | Date to which SIM card is reserved |
| 6 | IMSI | VARCHAR2 | 100 | Y | | International Mobile Subscriber Indentity |
| 7 | ICC | VARCHAR2 | 100 | Y | | Integrated Circuit Card 8 |
PIN1 | VARCHAR2 | 100 | Y | | PIN code9 |
PIN2 | VARCHAR2 | 100 | Y | | Second PIN code |
| 10 | PUK1 | VARCHAR2 | 100 | Y | | Personal unblocking code 11 |
PUK2 | VARCHAR2 | 100 | Y | | Second personal unblocking code |
| 12 | TYPE | VARCHAR2 | 100 | Y | | Status name |
| 13 | COMMENTS | VARCHAR2 | 1000 | Y | | Comments |
| 14 | USERCLIENT | VARCHAR2 | 100 | Y | | Operator name |
| 15 | LOCATION | VARCHAR2 | 100 | Y | | Location |
| 16 | BLOCKED_FROM_DATE | DATE | 7 | Y | | Date on which SIM card is to be blocked17 |
MARS_SYNC_DATE | DATE | 7 | Y | | |
| 18 | ASSIGNED_ANUMBER_ID | NUMBER | 22 | Y | | Foreign key referencing A_NUMBER.ID |
| 19 | NETWORK_ID | NUMBER | 22 | Y | | Foreign key referencing NETWORK_OPERATOR.ID 20 |
KI | VARCHAR2 | 32 | Y | | 21 |
CHANGE_PENDING | VARCHAR2 | 1 | Y | | |
| 22 | SIM_TYPE_ID | NUMBER | 22 | Y | | SIM card type |
| 23 | NETWORK_STATUS | NUMBER | 22 | Y | | |
| 24 | BRAND_ID | NUMBER | 22 | Y | | Foreign key referencing BRAND.ID |
| 25 | 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 |