设计两张表,一个【m_id、m_processNo、m_processName、m_type、m_remarks】,另一个是他的外键【m_tareWeight、m_netWeight、m_realDuration、m_currentRotate】
时间: 2024-05-19 20:17:18 浏览: 16
第一个表:
| Column Name | Data Type | Description |
| --- | --- | --- |
| m_id | int | 主键,自增长 |
| m_processNo | varchar(20) | 工序编号 |
| m_processName | varchar(50) | 工序名称 |
| m_type | varchar(50) | 工序类型 |
| m_remarks | varchar(200) | 备注 |
第二个表:
| Column Name | Data Type | Description |
| --- | --- | --- |
| m_id | int | 主键,自增长,关联第一个表的m_id |
| m_tareWeight | float | 皮重 |
| m_netWeight | float | 净重 |
| m_realDuration | int | 实际耗时 |
| m_currentRotate | int | 当前转速 |
相关问题
bs.report_no 是 varchar
如果bs.report_no是varchar类型的,并且其中只包含数字,你可以使用以下SQL语句进行排序:
```sql
SELECT
bs.report_no,
bs.sample_id,
bs.test_id,
bs.service_type,
bs.sample_name,
bs.total_fee,
bs.receivable_fee,
bs.sample_no,
bs.ranges,
bs.grade,
bs.sample_remark AS remark,
bs.factory,
bs.item_name,
bs.apply_dept,
bs.specification,
bs.factory_number,
bs.calibrat_point,
bs.mandatory_flag,
bs.inspection_type,
bs.report_org_name,
bs.plan_complete_date,
bs.standard_instrument_name,
bs.bleeding_site_name,
bs.arrive_date,
DATEDIFF(bs.plan_complete_date, NOW()) AS surplus_days,
bs.order_no,
bs.order_type,
bs.customer_name,
bs.order_id,
bs.business_type,
bs.group_id,
bs.group_name,
bs.item_id,
bs.is_merge,
bs.pass_time,
bs.audit_time,
bs.report_id,
bs.compile_time,
bs.generate_time,
bs.pass_user_name,
bs.audit_user_name,
bs.compile_user_name,
bs.report_state,
bs.is_just_certificate,
bs.label_price,
bs.labor_cost,
bs.product_type,
bs.batch_number,
bs.original_number,
bs.type_no,
bs.template_id,
bs.template_version,
bs.standard_instrument_id,
bs.standard_instrument_name,
bs.report_query_code,
bs.test_user_id,
bs.test_user_name,
bs.test_time,
bs.review_user_id,
bs.review_user_name,
bs.review_time,
bs.or_number,
bs.test_result,
bs.test_result_text,
bs.test_date,
bs.test_address,
bs.result_value,
bs.unit,
bs.test_dept_id,
bs.test_dept_name,
bs.sample_mass,
bs.form,
bs.color,
bs.clarity,
bs.amplification_detection,
bs.precious_metal,
bs.remarks,
bs.photo,
bs.identifying_code,
bs.diamond_quality,
bs.hand_ring,
bs.craft,
bs.instrument_photo,
bs.customer_item_basis,
bs.quality_photo,
bs.check_point,
bs.check_code,
bs.mass_unit,
bs.manufacturer_name,
bs.manufacturer_addr,
bs.result_sample_describe AS sampleDescribe,
bs.test_rule AS metalRuleIdsStr,
bsa.attach_id
FROM
view_sample_info bs
JOIN bus_sample_report bsr ON bs.report_id = bsr.id
JOIN bus_sample sa ON bsr.sample_id = sa.id
JOIN bus_sample_attr bsa ON sa.id = bsa.id
ORDER BY CAST(bs.report_no AS UNSIGNED) ASC;
```
这将按照bs.report_no的数字值从小到大对结果进行排序。如果bs.report_no中包含非数字字符,可能会导致排序不正确。在这种情况下,你可能需要先清洗数据,使得bs.report_no只包含数字。
index1 index2 index3 index4 index5 indicators_alias_name cal_logic_name statistical_type_name statistical_cycle_name dimension_name unit_name data_period source_dept_name response_dept_name share_type value remarks leader_view_flag stand_idc_name industry indicators_threshold add_time cd_operation cd_time cd_batch id这些字段设置建表语句
好的,以下是建表语句的示例:
```
CREATE TABLE indicators (
id INT PRIMARY KEY AUTO_INCREMENT,
index1 VARCHAR(50),
index2 VARCHAR(50),
index3 VARCHAR(50),
index4 VARCHAR(50),
index5 VARCHAR(50),
indicators_alias_name VARCHAR(50),
cal_logic_name VARCHAR(50),
statistical_type_name VARCHAR(50),
statistical_cycle_name VARCHAR(50),
dimension_name VARCHAR(50),
unit_name VARCHAR(50),
data_period VARCHAR(50),
source_dept_name VARCHAR(50),
response_dept_name VARCHAR(50),
share_type VARCHAR(50),
value DECIMAL(18,2),
remarks VARCHAR(255),
leader_view_flag VARCHAR(10),
stand_idc_name VARCHAR(50),
industry VARCHAR(50),
indicators_threshold DECIMAL(18,2),
add_time DATETIME,
cd_operation VARCHAR(10),
cd_time DATETIME,
cd_batch INT
);
```
这是一个示例建表语句,具体的表结构还需要根据实际情况进行调整。
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)