Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table Majitel(
- MajitelID int identity(1,1) not null primary key,
- Jmeno varchar(20),
- Prijmeni varchar(30),
- Adresa varchar(40),
- Telefonni_Cislo int,
- Mesto varchar(30),
- PSC int
- )
- create table Typ(
- TypID int identity(1,1) not null primary key,
- Typ_nemovitosti varchar(20)
- )
- create table Nemovitost(
- NemovitostID int identity(1,1) not null primary key,
- TypID int references Typ(TypID),
- MajitelID int references Majitel(MajitelID),
- Adresa varchar(30),
- PSC int,
- Pocet_pater int,
- Cena_mesicne int,
- Rozloha int
- )
- create table Byt(
- BytID int identity(1,1) not null primary key,
- Patro int,
- Rozloha int,
- Cena_mesicne int,
- NemovitostID int references Nemovitost(NemovitostID)
- )
- create table Najemnik
- (NajemnikID int identity(1,1) not null primary key,
- Jmeno varchar(20),
- Prijmeni varchar(30),
- Rodne_cislo int,
- Telefonni_Cislo int,
- BytID int references Byt(BytID),
- NemovitostID int references Nemovitost(NemovitostID)
- )
- create table Opravy(
- OpravyID int identity(1,1) not null primary key,
- BytID int references Byt(BytID),
- Druh_opravy varchar(50),
- Cena_opravy int
- )
- create table Naklady(
- NajemnikID int references Najemnik(NajemnikID),
- Elektrina int,
- Plyn int,
- Internet int,
- Splatnost date,
- Datum_uhrazeni date
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement