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