CREATE TABLE pdw_sample_receive_item_t (
id varchar(50),
sample_code varchar(30) constraint pk_pdw_sample_receive_item_t
primary key,
id_card varchar(255),
run_time timestamp,
sample_num varchar(255),
sample_type varchar(255),
state varchar(255),
state_name varchar(255),
dy_nums integer,
is_contrast char(1),
CONSTRAINT unique_pdw_sample_receive_item_t_id UNIQUE (id)
);
comment on table pdw_sample_receive_item_t is '数据仓库层_病历基本信息';
comment on column pdw_sample_receive_item_t.id_card is '病例卡号';
CREATE INDEX idx_pdw_sample_receive_item_t_id_card ON pdw_sample_receive_item_t USING BTREE (id_card );
以上是postgresql数据中的建表的简单示例,其中主键:
sample_code varchar(30) constraint pk_pdw_sample_receive_item_t
primary key
唯一键:
CONSTRAINT unique_pdw_sample_receive_item_t_id UNIQUE (id)
索引创建:
CREATE INDEX idx_pdw_sample_receive_item_t_id_card ON pdw_sample_receive_item_t USING BTREE (id_card );
表注释:
comment on table pdw_sample_receive_item_t is '数据仓库层_病历基本信息';
字段注释:
comment on column pdw_sample_receive_item_t.id_card is '病例卡号';
另外注意postgresql数据库中大小写是敏感的;