> ÷ÏÐÒÏÓ ÞÉÓÔÏ ÆÉÌÏÓÏÆÓËÉÊ: × ÞÅÍ ÓÍÙÓÌ ÕÎÉËÁÌØÎÙÈ ÉÎÄÅËÓÏ×?
îÕ ×ÏÔ ×ÙÄÅÒÎÕÌ ÉÚ ÒÅÁÌØÎÏÊ âä,
óÐÉÓÏË ×ÁÌÀÔ.
CREATE TABLE CURRENCY (
CY_CODE D$CURRENCY NOT NULL /* D$CURRENCY = VARCHAR(3) */,
CY_CODE_1C D$CODE_3 NOT NULL /* D$CODE_3 = VARCHAR(3) */,
CY_NAME D$STRING_50 NOT NULL /* D$STRING_50 = VARCHAR(50) */,
CY_STR D$STRING_100 /* D$STRING_100 = VARCHAR(100) */,
CBR_CODE D$CODE_6 /* D$CODE_6 = VARCHAR(6) */,
LAST_MODIFIED D$LAST_MODIFIED /* D$LAST_MODIFIED = TIMESTAMP DEFAULT
current_timestamp */
);
CREATE UNIQUE INDEX CURRENCY_IDX1 ON CURRENCY (CY_CODE_1C);
CREATE UNIQUE INDEX CURRENCY_IDX2 ON CURRENCY (CBR_CODE);
exmple:
INSERT INTO CURRENCY (CY_CODE, CY_CODE_1C, CY_NAME, CY_STR, CBR_CODE,
LAST_MODIFIED) VALUES ('EUR', '978', 'å×ÒÏ', 'Å×ÒÏ, Å×ÒÏ, Å×ÒÏ, Ó, ÃÅÎÔ,
ÃÅÎÔÁ, ÃÅÎÔÏ×, Í, 2', 'R01239', NULL);
INSERT INTO CURRENCY (CY_CODE, CY_CODE_1C, CY_NAME, CY_STR, CBR_CODE,
LAST_MODIFIED) VALUES ('USD', '840', 'äÏÌÌÁÒ óûá', 'ÄÏÌÌÁÒ óûá, ÄÏÌÌÁÒÁ óûá,
ÄÏÌÌÁÒÏ× óûá, Í, ÃÅÎÔ, ÃÅÎÔÁ, ÃÅÎÔÏ×, Í, 2', 'R01235', NULL);
INSERT INTO CURRENCY (CY_CODE, CY_CODE_1C, CY_NAME, CY_STR, CBR_CODE,
LAST_MODIFIED) VALUES ('òõâ', '810', 'òÏÓÓÉÊÓËÉÊ ÒÕÂÌØ', 'ÒÕÂÌØ, ÒÕÂÌÑ,
ÒÕÂÌÅÊ, Í, ËÏÐÅÊËÁ, ËÏÐÅÊËÉ, ËÏÐÅÅË, Ö, 2', NULL, NULL);
CY_CODE - PK
CY_CODE_1C - PK × 1Ó, ÉÓÐÏÌØÚ. ÄÌÑ ÜËÓÐÏÒÔÁ ÄÏ-ÔÏ× × 1Ó
CBR_CODE ëÏÄ ×ÁÌÀÔÙ × ÓÉÓÔÅÍÅ ãâò, ÄÌÑ ÚÁÇÒÕÚËÉ ËÕÒÓÏ× Ó ÉÈ ÓÁÊÔÁ
÷ÓÅ 3 ËÌÀÞÁ ÄÏÌÖÎÙ ÂÙÔØ ÕÎÉËÁÌØÎÙÍÉ.
ëÓÔÁÔÉ, ÎÅ ÐÏÎÑÌ, ÐÏÞÅÍÕ IBExpert ÎÅ ×ÙËÉÎÕÌ × ÓËÒÉÐÔ PK, ÎÕ É ÎÅÏÈÏÔÁ
ÒÁÚÂÉÒÁÔØÓÑ...
ôÁË ÐÒÉÐÉÛÕ, ÞÔÏ CY_CODE - ÜÔÏ ðë.
