====== 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| - | - |

{{tag>Cable_System}}