Groups
SIMCARD
| 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, 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 code | |
| 9 | 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 blocked | |
| 17 | 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 | CA_RICA_SERIAL_NUMBER | NUMBER | 22 | Y | RICA serial number regarding the SIM card | |
| 26 | CA_DEBIT_CARD_NUMBER | VARCHAR2 | 400 | Y | Debit card number regarding the SIM card |