18 lines
466 B
MySQL
18 lines
466 B
MySQL
|
-- Version: 2025.7.31 14:52:27
|
||
|
|
Drop Table T_SAMPLE_STAT@
|
||
|
|
|
||
|
|
Create Table T_SAMPLE_STAT(
|
||
|
|
SampleId VARCHAR(50) NOT NULL,
|
||
|
|
X DECIMAL(8,2) NOT NULL,
|
||
|
|
Count DECIMAL(8) NOT NULL,
|
||
|
|
CONSTRAINT pk_T_SAMPLE_STAT PRIMARY KEY (SampleId, X)
|
||
|
|
)
|
||
|
|
IN TB8KUSREMS INDEX IN TB8KIDXEMS@
|
||
|
|
|
||
|
|
COMMENT ON Table T_SAMPLE_STAT IS '统计样本表'@
|
||
|
|
|
||
|
|
COMMENT ON T_SAMPLE_STAT (SampleId IS '样本ID')@
|
||
|
|
COMMENT ON T_SAMPLE_STAT (X IS '统计量')@
|
||
|
|
COMMENT ON T_SAMPLE_STAT (Count IS '频次')@
|
||
|
|
|