Nexspace
Tables (11)
approval_history
- history_id — BIGINT
- request_id — BIGINT — NOT NULL
- approver_id — VARCHAR(50) — NOT NULL
- status — ENUM('APPROVED', 'REJECTED') — NOT NULL
- comments — TEXT
- created_at — DATETIME
approval_line
- approval_line_id — BIGINT
- department_id — BIGINT — NOT NULL
- approver_id — VARCHAR(50) — NOT NULL
- level — INT — NOT NULL
- created_at — DATETIME
approval_request
- request_id — BIGINT
- requester_id — VARCHAR(50) — NOT NULL
- related_id — BIGINT — NOT NULL
- request_type — ENUM('CONTRACT', 'INVOICE', 'PAYMENT') — NOT NULL
- status — ENUM('PENDING', 'APPROVED', 'REJECTED')
- created_at — DATETIME
bidding_analysis
- analysis_id — BIGINT
- bidding_id — BIGINT — NOT NULL
- partner_id — VARCHAR(50) — NOT NULL
- bid_price — DECIMAL(15,2) — NOT NULL
- price_score — INT — NOT NULL
- quality_score — INT — NOT NULL
- delivery_score — INT — NOT NULL
- reliability_score — INT — NOT NULL
- total_score — INT — NOT NULL
- comments — TEXT
- created_at — TIMESTAMP
bidding_participation
- participation_id — BIGINT
- bidding_id — BIGINT — NOT NULL
- partner_id — VARCHAR(50) — NOT NULL
- bid_price — DECIMAL(15,2) — NOT NULL
- delivery_date — DATE — NOT NULL
- proposal — TEXT
- status — ENUM('PENDING', 'EVALUATING', 'SELECTED', 'REJECTED')
- created_at — TIMESTAMP
bidding_selected
- selected_id — BIGINT
- bidding_id — BIGINT — NOT NULL
- partner_id — VARCHAR(50) — NOT NULL
- final_price — DECIMAL(15,2) — NOT NULL
- selected_at — TIMESTAMP
department
- department_id — BIGINT
- name — VARCHAR(50) — NOT NULL
- parent_dept_id — BIGINT
- manager_id — VARCHAR(50)
- is_active — CHAR(1)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
item
- item_id — BIGINT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- price — DECIMAL(10,2) — NOT NULL
- stock_quantity — INT
- created_at — DATETIME
- updated_at — DATETIME
item_img
- item_img_id — BIGINT
- item_id — BIGINT — NOT NULL
- img_url — VARCHAR(500) — NOT NULL
- created_at — DATETIME
position
- position_code — VARCHAR(20)
- position_name — VARCHAR(50) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
project
- project_id — BIGINT
- project_name — VARCHAR(100) — NOT NULL
- purchase_request_id — BIGINT — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- status — ENUM('IN_PROGRESS', 'COMPLETED')
- total_cost — DECIMAL(15,2) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP