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