You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

11 lines
512 B
SQL

CREATE TABLE IF NOT EXISTS teaching_class_score_weight (
teaching_class_id varchar(64) NOT NULL,
foundation_weight decimal(8,4) NOT NULL,
market_insight_weight decimal(8,4) NOT NULL,
planning_design_weight decimal(8,4) NOT NULL,
development_validation_weight decimal(8,4) NOT NULL,
launch_operation_weight decimal(8,4) NOT NULL,
comprehensive_training_weight decimal(8,4) NOT NULL,
PRIMARY KEY (teaching_class_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='教学班六模块成绩权重';