LFFgmc5G

1
2DROP DATABASE IF EXISTS Dogkennel;
3CREATE DATABASE Dogkennel;
4USE Dogkennel;
5DROP TABLE IF EXISTS Dog;
6CREATE TABLE Dog(
7    DogID INTEGER PRIMARY KEY,
8    Name TEXT NOT NULL,
9    Breed TEXT NOT NULL,
10    Gender TEXT NOT NULL,
11    Shots TEXT NOT NULL,
12    DatOfBrith TEXT NOT NULL,
13    Status TEXT NOT NULL,
14    PurchaseID INTEGER,
15    Mother INTEGER,
16    Father INTEGER
17
18
19
20);
21
22ALTER TABLE Dog
23    ADD CONSTRAINT FK__PurchaceRecord__PurchaceID
24    FOREIGN KEY (PurchaseID)
25    REFERENCES PurchaceRecord (PurchaseID);
26
27ALTER TABLE Dog
28ADD CONSTRAINT FK__Dog__Mother FOREIGN KEY (Mother)
29    REFERENCES Dog (Mother);
30
31ALTER TABLE Dog
32ADD CONSTRAINT FK__Dog__PurchaceID FOREIGN KEY (Father)
33    REFERENCES Dog (Father);
34
35
36
37
38
39
40
41
42
43DROP TABLE IF EXISTS Customer;
44CREATE TABLE Customer(
45    CustomerID INTEGER PRIMARY KEY,
46    ClientName TEXT NOT NULL,
47    address INTEGER NOT NULL,
48    PhoneNumber TEXT NOT NULL
49);
50DROP TABLE IF EXISTS PurchaceRecord;
51CREATE TABLE PurchaceRecord(
52    PurchaseID INTEGER PRIMARY KEY,
53    CustomerID INTEGER NOT NULL
54
55);
56
57ALTER TABLE PurchaceRecord
58ADD CONSTRAINT FK__Customer__CustomerID FOREIGN KEY (CustomerID)
59    REFERENCES Customer (CustomerID);