스페이스플래닝
테이블 (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