MyProject

Tables (4)

Bills

  • billid — varchar(20) — Primary key — NOT NULL
  • bill_type (billtype) — varchar(40)
  • bill_amount (billamount) — decimal
  • bill_date — date
  • userid — varchar(20) — Foreign key → users.userid — NOT NULL
  • companyID — varchar(20) — Foreign key → Company.companyID — NOT NULL
  • payment_due — date

Company (Compnay)

  • companyID — varchar(20) — Primary key — NOT NULL
  • company_name (companyName) — varchar(40)
  • company_phone (companyPhone) — varchar(20)
  • company_email — varchar(40)
  • company_type (compnanyType) — varchar(30)

Images (images)

  • ImageID (imageID) — varchar(20) — Primary key — NOT NULL
  • Image_Type (ImageType) — varchar(30)
  • image_date (imageDate) — date
  • userid — varchar(20) — Foreign key → users.userid — NOT NULL

users

  • userid — varchar(20) — Primary key — NOT NULL
  • first_name — varchar(40)
  • last_name — varchar(40)
  • email — varchar(40)
  • user_password (userpassword) — varchar(16)
  • phone_number (phoneNumber) — varchar(20)
  • companyID — varchar(20) — Foreign key → Company.companyID — NOT NULL
  • address — varchar(100)