Инструменты пользователя

Инструменты сайта


rslight:tables

RSlight: Таблицы

REGIONS

Регионы

Name Type LengthPrecisionScaleNull 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_IDNUMBER 22 10 0 N 4
REGION_BLOB BLOB 4000 Y 5
DOMAIN_PREFIX VARCHAR2 10 Y 6

WORKSTATIONS

Name Data Type NullableDefaultPrimary 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 NullableDefaultPrimary 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 NullableDefaultPrimary Key
PHONE VARCHAR2(30) No - -
REGION_IDNUMBER(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 (внешнее изменение)