Регионы
Name | Type | Length | Precision | Scale | Null | Default | Column ID | Comments |
---|---|---|---|---|---|---|---|---|
REGION_ID | NUMBER | 22 | 10 | 0 | N | 1 | ||
REGION_CODE | VARCHAR2 | 30 | N | 2 | ||||
REGION_NAME | VARCHAR2 | 30 | N | 3 | ||||
PARENTREGION_ID | NUMBER | 22 | 10 | 0 | N | 4 | ||
REGION_BLOB | BLOB | 4000 | Y | 5 | ||||
DOMAIN_PREFIX | VARCHAR2 | 10 | Y | 6 |
Name | Data Type | Nullable | Default | Primary Key |
---|---|---|---|---|
SID | NUMBER(10,0) | No | - | 1 |
NETNAME | VARCHAR2(15) | No | - | - |
COMMENT | VARCHAR2(40) | Yes | - | - |
FADMCODE | VARCHAR2(18) | No | - | - |
FADMKEY | VARCHAR2(24) | No | - | - |
UNLOPA | VARCHAR2(72) | Yes | - | - |
Name | Data Type | Nullable | Default | Primary Key |
---|---|---|---|---|
OWNER_ID | NUMBER(10,0) | No | - | 1 |
OWNER_NAME | VARCHAR2(60) | No | - | - |
OWNER_EXT CHAR(1) | Yes | 'T' | - | |
OWNER_SRV CHAR(1) | Yes | 'T' | - | |
OWNER_MEMO | CLOB | Yes | - | - |
CORR_DATE | DATE | No | SYSDATE | - |
REGION_ID | NUMBER(10,0) | No | 1 | - |
Справочник абонентов - импортируется
Name | Data Type | Nullable | Default | Primary Key |
---|---|---|---|---|
PHONE | VARCHAR2(30) | No | - | - |
REGION_ID | NUMBER(10,0) | No | 1 | - |
OWNER | VARCHAR2(50) | Yes | - | - |
DIVISION | VARCHAR2(50) | Yes | - | - |
NOTES | VARCHAR2(100) | Yes | - | - |
TYPE | VARCHAR2(1) | Yes | - | - |
WHO | VARCHAR2(200) | Yes | - | - |
ADDRESS | VARCHAR2(200) | Yes | - | - |
PRIV | VARCHAR2(1) | Yes | - | - |
FIRM | VARCHAR2(1) | Yes | - | - |