جدول المدير(Admin Table):
restriction Data Type Column Name
Primary key int AdminID
Nvachar(20) Admin-name
Nvachar(20) password
Nvachar(50) Email
Nvachar(500) Phone-No
Nvachar(500) address
جدول الاستفسارات والشكاوي (Inquiries and complaints Table):
restriction Data Type Column Name
Primary key int queryid
Forging key int userid
Nvachar (800) massage
date and time date
جدول ردود الاستفسارات والشكاوي (of Inquiries and complaints Table Replies) :
restriction Data Type Column Name
Primary key int Replyid
Forging key int queryid
Forging key int userid
Nvachar(800) massage
date and time date
جدول المنتجات (Product Table):
restriction Data Type Column Name
Primary key int Product number
Nvachar(20) product name
Forging key int userid
Nvachar(50) Email
Nvachar(500) Phone-No
Nvachar(50) Rate Name
Nvachar(20) Area name
Nvachar(20) statuS
Nvachar(20) Rental price
Nvachar(20) Insurance price
date and time date
جدول المستخدم ( Table user):
restriction Data Type Column Name
Primary key int userid
Nvachar(20) user name
Nvachar(20) password
Nvachar(50) Email
Nvachar(500) Phone-No
Nvachar(20) Area name
Nvachar(500) address
جدول الطلبات (Order Table) :
restriction Data Type Column Name
Primary key int Order number
Forging key int Product number
Forging key int userid
Forging key Nvachar(20) product name
date and time Date-start
date and time Date-end
جدول الإعلان (Advertising Table):
restriction Data Type Column Name
Primary key int AdminID
Nvachar(500) Ad Title
Nachar(800) massage
Nvachar(50) Email
Nvachar(500) Phone-No
Nvachar(10) adprice
Nvachar(20) Duration Advertising
date and time date