employee_purchase

Tables (6)

department

  • dept_id — number(19) — Primary key — NOT NULL
  • dept_name — varchar2(100) — NOT NULL

employee

  • employee_id — number(19) — Primary key — NOT NULL
  • employee_name — varchar2(100) — NOT NULL

product

  • product_id — number(19) — Primary key — NOT NULL
  • product_code — varchar2(20) — NOT NULL
  • product_name — varchar2(255) — NOT NULL
  • price — number(19) — NOT NULL
  • point — number(10) — NOT NULL
  • is_active — number(1) — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date

purchase_request

  • request_id — number(19) — Primary key — NOT NULL
  • doc_no — varchar2(30) — NOT NULL
  • employee_id — number(19) — Foreign key → employee.employee_id — NOT NULL
  • dept_id — number(19) — Foreign key → department.dept_id — NOT NULL
  • draft_date — date — NOT NULL
  • phone_number — varchar2(20)
  • delivery_location — varchar2(255)
  • credit_card_number — varchar2(30)
  • credit_card_company — varchar2(50)
  • installment — number(10) — NOT NULL
  • expiry_date — date
  • account_code — varchar2(20) — NOT NULL
  • total_point — number(19) — NOT NULL
  • total_amount — number(19) — NOT NULL
  • status — varchar2(20) — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date

purchase_request_file

  • file_id — number(19) — Primary key — NOT NULL
  • request_id — number(19) — Foreign key → purchase_request.request_id — NOT NULL
  • original_name — varchar2(255) — NOT NULL
  • stored_name — varchar2(255) — NOT NULL
  • file_path — varchar2(500) — NOT NULL
  • file_size — number(19) — NOT NULL
  • file_ext — varchar2(20)
  • created_at — date — NOT NULL

purchase_request_item

  • item_id — number(19) — Primary key — NOT NULL
  • request_id — number(19) — Foreign key → purchase_request.request_id — NOT NULL
  • product_id — number(19) — Foreign key → product.product_id — NOT NULL
  • sort_order — number(10) — NOT NULL
  • quantity — number(10) — NOT NULL
  • unit_price — number(19) — NOT NULL
  • point — number(19) — NOT NULL
  • amount — number(19) — NOT NULL
  • created_at — date — NOT NULL