rslight:tables
RSlight: Таблицы
REGIONS
Регионы
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 | |
WORKSTATIONS
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 | - | - |
OWNERS
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 | - |
ABON_INFO
Справочник абонентов - импортируется
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 | - | - |
rslight/tables.txt · Последние изменения: 2017-02-21 12:41 (внешнее изменение)