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)