ddd
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)