gp
Tables (13)
employee
- emp_no — INT(5)
- emp_name — VARCHAR(50)
invoice
- invoice_no — INT(5)
- vendor_no — INT(5) — Foreign key → vendor.vendor_no
- invoice_date — DATE
- ship_date — DATE
- charge — DOUBLE
invoice_sub
- invoice_sub_no — INT(5)
- invoice_no — INT(5) — Foreign key → invoice.invoice_no
- vendor_no — INT(5) — Foreign key → invoice.vendor_no
- product_no — INT(5) — Foreign key → product.product_no
- product_type_no — INT(5) — Foreign key → product.product_type_no
- price — DOUBLE
move
- move_no — INT(5)
- emp_no — INT(5) — Foreign key → employee.emp_no
- date — DATE
move_sub
- move_sub_no — INT(5)
- move_no — INT(5) — Foreign key → move.move_no
- emp_no — INT(5) — Foreign key → move.emp_no
- product_no — INT(5) — Foreign key → product.product_no
- product_type_no — INT(5) — Foreign key → product.product_type_no
- install/remove — VARCHAR(50)
- location — VARCHAR(50)
- datetime — DATETIME
product
- product_no — INT(5)
- product_type_no — INT(5) — Foreign key → product_type.product_type_no
product_history
- product_history_no — INT(5)
- product_no — INT(5) — Foreign key → product.product_no
- product_type_no — INT(5) — Foreign key → product.product_type_no
- status — VARCHAR(50)
- location — VARCHAR(50)
- location_phone — VARCHAR(50)
- recorded_date — DATE
- contract_start — DATE
- contract_end — DATE
- comment — VARCHAR(50)
product_type
- product_type_no — INT(5)
- manuf_name — VARCHAR(50)
- product_type_name — VARCHAR(50)
purchase
- purchase_no — INT(5)
- emp_no — INT(5) — Foreign key → employee.emp_no
- vendor_no — INT(5) — Foreign key → vendor.vendor_no
- date — DATE
purchase_sub
- purchase_sub_no — INT(5)
- purchase_no — INT(5) — Foreign key → purchase.purchase_no
- emp_no — INT(5) — Foreign key → purchase.emp_no
- product_type_no — INT(5) — Foreign key → product_type.product_type_no
- vendor_no — INT(5) — Foreign key → purchase.vendor_no
- qty — INT(5)
- unit_price — DOUBLE
request
- request_no — INT(5)
- emp_no — INT(5) — Foreign key → employee.emp_no
- location — VARCHAR(50)
- comment — VARCHAR(50)
- date — DATETIME
request_sub
- request_sub_no — INT(5)
- request_no — INT(5) — Foreign key → request.request_no
- emp_no — INT(5) — Foreign key → request.emp_no
- product_type_no — INT(5) — Foreign key → product_type.product_type_no
- qty — INT(5)
vendor
- vendor_no — INT(5)
- address — VARCHAR(50)
- name — VARCHAR(50)
- phone — VARCHAR(50)
- fax — VARCHAR(50)