Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE rieltor_system_db
- USE rieltor_system_db
- CREATE TABLE apartments_tbl (
- id int PRIMARY KEY NOT NULL IDENTITY(1,1),
- owner_id int NOT NULL,
- status bit NOT NULL,
- city varchar(30) NOT NULL,
- address varchar(255) NOT NULL,
- floor int NOT NULL,
- rooms int NOT NULL,
- price int NOT NULL,
- addition text
- )
- CREATE TABLE clients_tbl (
- id int PRIMARY KEY NOT NULL IDENTITY(1,1),
- lastname varchar(30) NOT NULL,
- firstname varchar(30) DEFAULT NULL,
- role bit NOT NULL,
- telephone int UNIQUE NOT NULL,
- passport varchar(30) UNIQUE NOT NULL
- )
- CREATE TABLE deals_tbl (
- id int PRIMARY KEY NOT NULL IDENTITY(1,1),
- buyer_id int NOT NULL,
- seller_id int NOT NULL,
- apart_id int NOT NULL,
- d_date date NOT NULL,
- price int NOT NULL
- )
- CREATE TABLE employees_tbl (
- id int PRIMARY KEY NOT NULL IDENTITY(1,1),
- login varchar(30) UNIQUE NOT NULL,
- password varchar(30) NOT NULL,
- lastname varchar(30) NOT NULL,
- firstname varchar(30) NOT NULL,
- passport varchar(30) NOT NULL,
- role varchar(30) NOT NULL,
- salary int NOT NULL
- )
- CREATE TABLE requests_tbl (
- id int PRIMARY KEY NOT NULL IDENTITY(1,1),
- client_id int NOT NULL,
- apart_id int NULL,
- realisation bit NOT NULL,
- empl_id int NOT NULL,
- status bit NOT NULL,
- d_date date NOT NULL,
- city varchar(30) NULL,
- floor int NULL,
- rooms int NULL,
- price int NULL,
- addition text
- )
- ALTER TABLE requests_tbl
- ADD CONSTRAINT client_ref
- FOREIGN KEY (client_id) REFERENCES clients_tbl(id)
- ALTER TABLE requests_tbl
- ADD CONSTRAINT req_apart_ref
- FOREIGN KEY (apart_id) REFERENCES apartments_tbl(id)
- ALTER TABLE requests_tbl
- ADD CONSTRAINT req_empl_ref
- FOREIGN KEY (empl_id) REFERENCES employees_tbl(id)
- ALTER TABLE deals_tbl
- ADD CONSTRAINT buyer_ref
- FOREIGN KEY (buyer_id) REFERENCES requests_tbl(id)
- ALTER TABLE deals_tbl
- ADD CONSTRAINT seller_ref
- FOREIGN KEY (seller_id) REFERENCES requests_tbl(id)
- ALTER TABLE deals_tbl
- ADD CONSTRAINT deal_apart_ref
- FOREIGN KEY (apart_id) REFERENCES apartments_tbl(id)
- ALTER TABLE apartments_tbl
- ADD CONSTRAINT owner_ref
- FOREIGN KEY (owner_id) REFERENCES clients_tbl(id)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement