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)