Notes
Notes - notes.io |
SSN Number PRIMARY KEY,
FirstName Text (30),
LastName Text(30),
Phone Number,
eMail Text(50)
)
CREATE TABLE Owner (
SSN Number,
CONSTRAINT FK_Owner FOREIGN KEY (SSN) REFERENCES PERSON (SSN)
);
CREATE TABLE Property (
Building Number,
Letter Number,
Bedrooms Number,
Bathrooms Number,
Layout Text(50),
Balcony Boolean,
Patio Boolean,
Apartment Boolean,
CONSTRAINT PK_Prop PRIMARY KEY (Building, Letter)
) ;
CREATE TABLE Sale (
SSN Number,
Building Number,
Letter Number,
SalePrice Number,
SaleDate DateTime,
RefNo Number,
CONSTRAINT FK_Sale FOREIGN KEY (Building, Letter) REFERENCES PROPERTY (Building, Letter),
CONSTRAINT FK_Sale2 FOREIGN KEY (SSN) REFERENCES PERSON (SSN)
) ;
CREATE TABLE Apartment (
Building Number,
Letter Number,
Pets LOGICAL,
CONSTRAINT FK_Apart FOREIGN KEY (Building, Letter) REFERENCES PROPERTY (Building, Letter),
);
CREATE TABLE Condo (
Building Number,
Letter Number,
LastInspect DateTime,
Inspector Text(50),
Deed Text(50),
MaintContract Text(50),
GarageID Number,
CONSTRAINT FK_Apart FOREIGN KEY (Building, Letter) REFERENCES PROPERTY (Building, Letter),
);
CREATE TABLE MaintReq(
Building Number,
Letter Number,
ReqDate DateTime,
Description Text(100),
Resolution Text(100),
CompleteTime DateTime,
MatCost Number,
LaborCost Number,
CONSTRAINT PK_Maint PRIMARY KEY (ReqDate),
CONSTRAINT FK_Maint2 FOREIGN KEY (Building, Letter) REFERENCES PROPERTY (Building, Letter)
) ;
CREATE TABLE Lease(
SSN Number,
Building Number,
Letter Number,
LeaseDate DateTime,
Rent Number,
MoveICondition Text(100),
MoveOCondition Text(100),
CreditScore Number,
CONSTRAINT FK_Lease FOREIGN KEY (SSN) REFERENCES PERSON (SSN),
CONSTRAINT FK_Lease2 FOREIGN KEY (Building, Letter) REFERENCES PROPERTY (Building, Letter)
) ;
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
