帮我写个pgsql的建表语句表名为weekly_excitation字段有idint4 monthdata weekint2 typeint2levelint2 bonusint4 range_start int4range_endint4 rankingint2 rationumeric105productvarchar60 created_attimestamp0 updated_attime
CREATE TABLE weekly_excitation ( id SERIAL PRIMARY KEY DEFAULT nextval('sq_weekly_excitation'), month DATE, week SMALLINT, type SMALLINT, level SMALLINT, bonus INTEGER, range_start INTEGER, range_end INTEGER, ranking SMALLINT, ratio NUMERIC(10,5), product VARCHAR(60), created_at TIMESTAMP(0) DEFAULT NOW(), updated_at TIMESTAMP(0) );
原文地址: https://www.cveoy.top/t/topic/ePGQ 著作权归作者所有。请勿转载和采集!