[sql] Real Estate
Viewer
- CREATE DATABASE `Real Estate`;
- USE real_estate_database;
- CREATE TABLE Clients (
- ID INT PRIMARY KEY,
- FirstName VARCHAR(50),
- LastName VARCHAR(50),
- Address VARCHAR(100),
- Phone VARCHAR(20),
- Email VARCHAR(100)
- );
- CREATE TABLE Properties (
- PID INT PRIMARY KEY,
- PType VARCHAR(50),
- Price DECIMAL(10,2),
- PDescription VARCHAR(200)
- );
- CREATE TABLE Agents (
- ID INT PRIMARY KEY,
- FirstName VARCHAR(50),
- LastName VARCHAR(50),
- Phone VARCHAR(20),
- Email VARCHAR(100)
- );
- -- Δημιουργία πίνακα Συναλλαγές
- CREATE TABLE Transactions (
- ID INT PRIMARY KEY,
- TransactionDate DATE,
- Amount DECIMAL(10,2)
- );
- CREATE TABLE Locations (
- ID INT PRIMARY KEY,
- Address VARCHAR(100),
- City VARCHAR(50),
- );
- CREATE TABLE Transactions_Clients (
- TransactionID INT,
- ClientID INT,
- PRIMARY KEY (TransactionID, ClientID),
- FOREIGN KEY (TransactionID) REFERENCES Transactions(ID),
- FOREIGN KEY (ClientID) REFERENCES Clients(ID)
- );
Editor
You can edit this paste and save as new:
File Description
- Real Estate
- Paste Code
- 05 Jun-2023
- 1.05 Kb
You can Share it: