Новичок
Профиль
Группа: Участник
Сообщений: 6
Регистрация: 21.5.2007
Репутация: 1
Всего: 1
|
Помогите пожалуйста найти ошибку, после 4 -ой таблицы. Пишет это: | Код |
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'k_contract'.
|
| Код |
/* "ПРЕДПРИЯТИЯ" */
CREATE TABLE k_firm
(
firm_num NUMERIC(6) IDENTITY PRIMARY KEY,
firm_name VARCHAR(100) NOT NULL,
firm_addr VARCHAR(100),
)
INSERT INTO k_firm (firm_name, firm_addr)
VALUES ('Ваз','Москва');
INSERT INTO k_firm (firm_name, firm_addr)
VALUES ('Газ','Казань');
INSERT INTO k_firm (firm_name, firm_addr)
VALUES ('Урал','Париж');
INSERT INTO k_firm (firm_name, firm_addr)
VALUES ('Хонда','Лондон');
INSERT INTO k_firm (firm_name, firm_addr)
VALUES ('Хёндай','Токио');
------------------------------------------
SELECT *FROM k_firm
-------------------
/* "ОТДЕЛЫ" */
CREATE TABLE k_dept
(
dept_num NUMERIC(6) IDENTITY PRIMARY KEY,
dept_short_name VARCHAR(10) NOT NULL,
dept_full_name VARCHAR(100),
staff_num NUMERIC(6)
)
INSERT INTO k_dept (dept_short_name, dept_full_name)
VALUES ('Sales','Отдел продаж');
INSERT INTO k_dept (dept_short_name, dept_full_name)
VALUES ('Mart','Отдел маркетинга');
INSERT INTO k_dept (dept_short_name, dept_full_name)
VALUES ('Cust','Отдел гарантийного обслуживания');
----------------------------------------------
SELECT *FROM k_dept
-------------------
/* "СОТРУДНИКИ" */
CREATE TABLE k_staff
(
staff_num NUMERIC(10) IDENTITY,
staff_name VARCHAR(30) NOT NULL,
staff_post VARCHAR(30),
dept_num NUMERIC(6) NOT NULL,
staff_hiredate DATETIME NOT NULL,
staff_termdate DATETIME,
CONSTRAINT pk_staff_num PRIMARY KEY (staff_num),
CONSTRAINT fk_staff_dept_num FOREIGN KEY (dept_num)
REFERENCES k_dept (dept_num)
)
INSERT INTO k_staff (staff_name, dept_num, staff_hiredate, staff_post)
VALUES ('Иванов', 1, GETDATE(),'Менеджер');
INSERT INTO k_staff (staff_name, dept_num, staff_hiredate, staff_post)
VALUES ('Петров', 2, GETDATE(),'Продавец консультант');
INSERT INTO k_staff (staff_name, dept_num, staff_hiredate, staff_post)
VALUES ('Сидоров', 3, GETDATE(),'Бухгалтер');
---------------------------------------------------
SELECT *FROM k_staff
--------------------
/* "ДОГОВОРЫ" */
CREATE TABLE k_contract
(
contract_num NUMERIC(6) IDENTITY PRIMARY KEY,
contract_date DATETIME DEFAULT GETDATE(),
contract_type CHAR(1)
CHECK (contract_type IN ('A','B','C')),
firm_num NUMERIC(6) NOT NULL,
staff_num NUMERIC(6),
CONSTRAINT fk_contract_firm_num FOREIGN KEY (firm_num)
REFERENCES k_firm (firm_num),
CONSTRAINT fk_contract_staff_num FOREIGN KEY (staff_num)
REFERENCES k_staff (staff_num)
)
INSERT INTO k_contract (contract_type, firm_num, staff_num)
VALUES ('A', 1, 1);
INSERT INTO k_contract (contract_type, firm_num, staff_num)
VALUES ('B', 2, 2);
INSERT INTO k_contract (contract_type, firm_num, staff_num)
VALUES ('C', 3, 2);
INSERT INTO k_contract (contract_type, firm_num, staff_num)
VALUES ('A', 1, 1);
INSERT INTO k_contract (contract_type, firm_num, staff_num)
VALUES ('B', 2, 2);
INSERT INTO k_contract (contract_type, firm_num, staff_num)
VALUES ('C', 3, 3);
INSERT INTO k_contract (contract_type, firm_num, staff_num)
VALUES ('A', 1, 1);
---------------------------------------------------------
SELECT *FROM k_contract
------------------------
/* "СЧЕТА" */
CREATE TABLE k_bill
(
bill_num NUMERIC(6) IDENTITY PRIMARY KEY,
bill_date DATETIME DEFAULT GETDATE(),
bill_term DATETIME DEFAULT GETDATE()+30,
bill_peni NUMERIC(6) DEFAULT 0,
contract_num NUMERIC(6),
CONSTRAINT fk_bill_contract_num FOREIGN KEY (contract_num)
REFERENCES k_contract (contract_num),
CONSTRAINT ch_bill_date CHECK (bill_term-bill_date<91)
)
INSERT INTO k_bill (contract_num, bill_date, bill_sum)
VALUES ( 1, GETDATE()-60, 1000);
INSERT INTO k_bill ( contract_num, bill_date, bill_sum)
VALUES ( 2, GETDATE()-30, 1000);
INSERT INTO k_bill ( contract_num, bill_date, bill_sum)
VALUES ( 3, GETDATE(), 2000);
INSERT INTO k_bill ( contract_num, bill_date, bill_sum)
VALUES ( 1, GETDATE()-30, 6000);
INSERT INTO k_bill ( contract_num, bill_date, bill_sum)
VALUES ( 2, GETDATE(), 1000);
INSERT INTO k_bill ( contract_num, bill_date, bill_sum)
VALUES ( 3, GETDATE()-30, 2500);
INSERT INTO k_bill ( contract_num, bill_date, bill_sum)
VALUES ( 1, GETDATE()-30, 1000);
INSERT INTO k_bill ( contract_num, bill_date, bill_sum)
VALUES ( 1, GETDATE()-60, 1200);
INSERT INTO k_bill ( contract_num, bill_date, bill_sum)
VALUES ( 2, GETDATE(), 1000);
-----------------------------------------------------
SELECT * FROM k_bill
--------------------
/* "ПЛАТЕЖИ" */
CREATE TABLE k_payment
(
payment_num NUMERIC(2) DEFAULT 0,
bill_num NUMERIC(6),
payment_date DATETIME DEFAULT GETDATE(),
payment_sum NUMERIC(9,2),
CONSTRAINT pk_payment_num PRIMARY KEY (payment_num, bill_num),
CONSTRAINT fk_payment_bill_num FOREIGN KEY (bill_num)
REFERENCES k_bill (bill_num)
)
INSERT INTO k_payment (payment_num, bill_num, payment_sum)
VALUES ( 2, 1, 1000);
INSERT INTO k_payment (payment_num, bill_num, payment_sum)
VALUES ( 3, 2, 2000);
INSERT INTO k_payment (payment_num, bill_num, payment_sum)
VALUES ( 1, 3, 6000);
INSERT INTO k_payment (payment_num, bill_num, payment_sum)
VALUES ( 2, 2, 500);
INSERT INTO k_payment (payment_num, bill_num, payment_sum)
VALUES ( 3, 2, 1500);
INSERT INTO k_payment (payment_num, bill_num, payment_sum)
VALUES ( 1, 4, 1000);
INSERT INTO k_payment (payment_num, bill_num, payment_sum)
VALUES ( 1, 3, 1200);
INSERT INTO k_payment (payment_num, bill_num, payment_sum)
VALUES ( 2, 7, 1000);
---------------------------------------------------------
SELECT *FROM k_payment
-----------------------
/* "ПРАЙС-ЛИСТ" */
CREATE TABLE k_price
(
price_num NUMERIC(6) IDENTITY PRIMARY KEY,
price_name VARCHAR(100) NOT NULL,
price_sum NUMERIC(9,2),
type_num NUMERIC(6)
)
INSERT INTO k_price (price_name, price_sum)
VALUES ( 'Материализация духов', 500);
INSERT INTO k_price (price_name, price_sum)
VALUES ( 'Раздача слонов', 1500);
INSERT INTO k_price (price_name, price_sum)
VALUES ( 'Слоновий бивень', 1000);
INSERT INTO k_price (price_name, price_sum)
VALUES ( 'Моржовый клык', 1200);
INSERT INTO k_price (price_name, price_sum)
VALUES ( 'Копыто Пегаса', 1000);
------------------------------------------
SELECT *FROM k_price
--------------------
/* "ПРОТОКОЛЫ СЧЕТОВ" */
CREATE TABLE k_protocol
(
price_num NUMERIC(6) NOT NULL,
bill_num NUMERIC(6) NOT NULL,
kolvo NUMERIC(6) NOT NULL,
price_sum NUMERIC(9,2),
CONSTRAINT pk_protocol_num PRIMARY KEY (price_num,bill_num),
CONSTRAINT fk_protocol_price_num FOREIGN KEY (price_num)
REFERENCES k_price (price_num),
CONSTRAINT fk_protocol_bill_num FOREIGN KEY (bill_num)
REFERENCES k_bill (bill_num)
)
INSERT INTO k_protocol (price_num, bill_num, kolvo, price_sum)
VALUES ( 1,1,1, 500);
INSERT INTO k_protocol (price_num, bill_num, kolvo, price_sum)
VALUES ( 2,2,3, 1500);
INSERT INTO k_protocol (price_num, bill_num, kolvo, price_sum)
VALUES ( 2,4,4, 1000);
INSERT INTO k_protocol (price_num, bill_num, kolvo, price_sum)
VALUES ( 1,2,2, 1200);
INSERT INTO k_protocol (price_num, bill_num, kolvo, price_sum)
VALUES ( 2,1,4, 1000);
INSERT INTO k_protocol (price_num, bill_num, kolvo, price_sum)
VALUES ( 2,3,2, 500);
INSERT INTO k_protocol (price_num, bill_num, kolvo, price_sum)
VALUES ( 2,3,1, 1500);
INSERT INTO k_protocol (price_num, bill_num, kolvo, price_sum)
VALUES ( 1,6,2, 1000);
INSERT INTO k_protocol (price_num, bill_num, kolvo, price_sum)
VALUES ( 3,5,1, 1200);
INSERT INTO k_protocol (price_num, bill_num, kolvo, price_sum)
VALUES ( 2,6,5, 1000);
INSERT INTO k_protocol (price_num, bill_num, kolvo, price_sum)
VALUES ( 4,7,1, 1200);
INSERT INTO k_protocol (price_num, bill_num, kolvo, price_sum)
VALUES ( 2,3,20, 1000);
-------------------------------------------------------------
SELECT *FROM k_protocol
------------------------
|
Базу пишу через SQL Query Analyzer. Заранее спасибо. |
Ошибка создания базы данных 
Загрузка ...
