search

RomanovskiyIlya / kursovaya

1 stars 0 forks source link

Физическая схема #8

Open RomanovskiyIlya opened 1 year ago

RomanovskiyIlya commented 1 year ago

image

Create Table Brands( Brand_name varchar(30) PRIMARY KEY, Brand_country varchar(30) )

CREATE TABLE Сountry_of_purchase( Сountry varchar(30) PRIMARY KEY )

CREATE TABLE Models( Model_name varchar(30) PRIMARY KEY, Release_year INT, Brand_name varchar(30), Сountry varchar(30), FOREIGN KEY (Brand_name) REFERENCES Brands (Brand_name), FOREIGN KEY (Сountry) REFERENCES Сountry_of_purchase (Сountry) )

CREATE TABLE Users( Phone_number varchar(11) PRIMARY KEY, Firstname varchar(30), Lastname varchar(30), Patronymic varchar(30), User_pasword varchar(64) )

CREATE TABLE Admins( Login varchar(30) PRIMARY KEY, Firstname varchar(30), Lastname varchar(30), Patronymic varchar(30), Admin_pasword varchar(64) )

CREATE TABLE Сonfigurations( Сonfiguration_ID INT PRIMARY KEY, Model_name varchar(30), Сonfiguration_name varchar(30), Engine_volume DECIMAL(2, 1), Engine_type varchar(30), Engien_Power INT, Transmission varchar(30), Drive_type varchar(30), Suspension_type varchar(60), Clearance INT, Car_length INT, Car_width INT, Car_height INT, Weight INT, Luke BOOLEAN, Panoramic_view BOOLEAN, Wheel_heating BOOLEAN, Seat_heating BOOLEAN, Cruise_control BOOLEAN, Climate_control BOOLEAN, Headlight_type varchar(30), Interior_lighting BOOLEAN, Parktronics BOOLEAN, Camera_type varchar(30), Price INT,

FOREIGN KEY (Model_name) REFERENCES models (Model_name)

)

CREATE TABLE Applications( Application_ID INT PRIMARY KEY, Brand_name varchar(30), Model_name varchar(30), Сonfiguration_ID INT, Phone_number varchar(11), Сountry varchar(30), Applications_Status varchar(30), FOREIGN KEY (Сonfiguration_ID) REFERENCES Сonfigurations (Сonfiguration_ID), FOREIGN KEY (Phone_number) REFERENCES Users (Phone_number), FOREIGN KEY (Сountry) REFERENCES Сountry_of_purchase (Сountry), FOREIGN KEY (Brand_name) REFERENCES Brands (Brand_name), FOREIGN KEY (Model_name) REFERENCES Models (Model_name) )

CREATE TABLE Сhanges( Сhange_ID INT PRIMARY KEY, Сonfiguration_ID INT, Login varchar(30), FOREIGN KEY (Сonfiguration_ID) REFERENCES Сonfigurations (Сonfiguration_ID), FOREIGN KEY (Login) REFERENCES Admins (Login) )

CREATE TABLE Photos( Photo_ID INT PRIMARY KEY, Model_name varchar(30), Path varchar(255), FOREIGN KEY (Model_name) REFERENCES Models (Model_name) )

wldmr-key commented 1 year ago

норм, но физическая схема естественно повторяет ошибки логической