스페이스플래닝

테이블 (8)

estimate_items

  • item_id — INT
  • estimate_id — INT — NOT NULL
  • version_number — INT — NOT NULL
  • material_name — VARCHAR(100) — NOT NULL
  • specification — VARCHAR(100)
  • unit — VARCHAR(20)
  • quantity — DECIMAL(12, 2) — NOT NULL
  • unit_price — DECIMAL(18, 2) — NOT NULL
  • total_price — DECIMAL(18, 2)
  • crawling_url — TEXT
  • is_variable_price — BOOLEAN
  • brand — VARCHAR(50)
  • manufacturer — VARCHAR(50)
  • certification_marks — TEXT
  • order_date — DATE
  • delivery_date — DATE
  • is_vat_included — BOOLEAN
  • shipping_fee_type — ENUM('Included', 'Excluded')
  • manager_comment — TEXT — EX
  • change_reason — TEXT
  • created_at — TIMESTAMP

estimates

  • estimate_id — INT
  • project_id — INT — NOT NULL
  • current_version — INT
  • last_updated — TIMESTAMP

milestones

  • milestone_id — INT
  • project_id — INT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • is_completed — BOOLEAN
  • sort_order — INT

notifications

  • noti_id — INT
  • project_id — INT — NOT NULL
  • type — ENUM('Warning_5%', 'Critical_10%', 'Order_D14', 'System') — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN
  • risk_tag — VARCHAR(50)
  • created_at — TIMESTAMP

price_history

  • history_id — INT
  • material_name — VARCHAR(100) — NOT NULL
  • market_price — DECIMAL(18, 2) — NOT NULL
  • source_url — TEXT
  • recorded_at — DATE — NOT NULL
  • INDEX — idx_material_date

projects

  • project_id — INT
  • manager_id — INT — NOT NULL
  • project_name — VARCHAR(200) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • project_img_url — TEXT
  • total_budget — DECIMAL(18, 2)
  • status — ENUM('Planning', 'In_Progress', 'Completed')
  • created_at — TIMESTAMP

risk_news

  • news_id — INT
  • category — ENUM('전쟁', '기후', '수요급증', '기타') — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT
  • source_name — VARCHAR(50)
  • published_at — TIMESTAMP
  • created_at — TIMESTAMP

users

  • user_id — INT
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • user_name — VARCHAR(50) — NOT NULL
  • profile_img_url — TEXT
  • created_at — TIMESTAMP