11111

Tables (13)

business_location

  • business_name — varchar(30) — Primary key — NOT NULL
  • street — varchar(30)
  • city — varchar(20)
  • state — varchar(20)
  • business_contact — varchar(20)
  • owner — varchar(20)
  • start_date_of_contract — datetime
  • end_date_of_contract — datetime

invoice

  • invoice_no — varchar(20) — Primary key — NOT NULL
  • invoice_date — datetime
  • ship_date — datetime
  • vendor_id — varchar(20) — Foreign key → vendor.vendor_id

invoice_item

  • invoice_no — varchar(20) — Primary key — NOT NULL
  • serial_no — varchar(20) — Foreign key → machine.serial_no — NOT NULL
  • product_no — varchar(20) — Foreign key → product.product_no — NOT NULL
  • purchase_order_no — varchar(20) — Foreign key → purchase_order.purchase_order_no

machine

  • serial_no — varchar(20) — Primary key — NOT NULL
  • unit_price — float
  • name — varchar(30)
  • business_location — varchar(30) — Foreign key → business_location.business_name
  • Status — varchar(10)

move_option

  • move_order_id — varchar(20) — Primary key — NOT NULL
  • serial_no — varchar(20) — Foreign key → machine.serial_no — NOT NULL
  • move_option — varchar(20)

move_order

  • move_order_id — varchar(20) — Primary key — NOT NULL
  • date — datetime
  • technician_name — varchar(30) — Foreign key → technician.technician_name
  • business_name — varchar(30) — Foreign key → business_location.business_name

product

  • product_no — varchar(20) — Primary key — NOT NULL
  • product_Name — varchar(30)
  • manufacturer — varchar(20)

purchase_order

  • purchase_order_no — varchar(20) — Primary key — NOT NULL
  • vendor_id — varchar(20)
  • date — datetime
  • date2us — datetime

purchase_product

  • purchase_order_no — varchar(20) — Primary key — NOT NULL
  • product_no — varchar(20) — Primary key — NOT NULL
  • quantity — int(11)
  • unit_price — double
  • total_price — double

purchase_request

  • purchase_req_no — varchar(20) — Primary key — NOT NULL
  • street — varchar(30)
  • city — varchar(20)
  • state — varchar(20)
  • contact — varchar(20)
  • date — datetime
  • business_name — varchar(40) — Foreign key → business_location.business_name

request_product

  • product_no — varchar(20) — Foreign key → product.product_no — NOT NULL
  • purchase_req_no — varchar(20) — Foreign key → purchase_request.purchase_req_no — NOT NULL
  • quantity — int(20)

technician

  • technician_name — varchar(30) — Primary key — NOT NULL
  • contact_number — varchar(30)

vendor

  • vendor_id — varchar(20) — Primary key — NOT NULL
  • fax_num — varchar(20)
  • vendor_name — varchar(50)
  • post_no — varchar(20)
  • street — varchar(20)
  • city — varchar(20)
  • state — varchar(20)