drop table zd_charge_class
create table zd_charge_class
(
code varchar(6) not null
constraint zd_charge_class_pk
primary key,
name varchar(40),
del_flag char,
med_chrgitm_type varchar(2),
yz_class_code varchar
)
go
INSERT INTO zd_charge_class (code, name, del_flag, med_chrgitm_type, yz_class_code) VALUES (N'A', N'挂号费', N'0', N'13', null);
INSERT INTO zd_charge_class (code, name, del_flag, med_chrgitm_type, yz_class_code) VALUES (N'B', N'床位费', N'0', N'01', null);
INSERT INTO zd_charge_class (code, name, del_flag, med_chrgitm_type, yz_class_code) VALUES (N'C', N'诊查费', N'0', N'02', N'E');
INSERT INTO zd_charge_class (code, name, del_flag, med_chrgitm_type, yz_class_code) VALUES (N'D', N'检查费', N'0', N'03', null);
INSERT INTO zd_charge_class (code, name, del_flag, med_chrgitm_type, yz_class_code) VALUES (N'E', N'治疗费', N'0', N'05', N'E');
INSERT INTO zd_charge_class (code, name, del_flag, med_chrgitm_type, yz_class_code) VALUES (N'F', N'护理费', N'0', N'07', N'N');
INSERT INTO zd_charge_class (code, name, del_flag, med_chrgitm_type, yz_class_code) VALUES (N'G', N'手术费', N'0', N'06', N'O');
INSERT INTO zd_charge_class (code, name, del_flag, med_chrgitm_type, yz_class_code) VALUES (N'H', N'检验费', N'0', N'04', null);
INSERT INTO zd_charge_class (code, name, del_flag, med_chrgitm_type, yz_class_code) VALUES (N'I', N'其他费', N'0', N'14', N'G');
INSERT INTO zd_charge_class (code, name, del_flag, med_chrgitm_type, yz_class_code) VALUES (N'J', N'材料费', N'0', N'08', N'F');
INSERT INTO zd_charge_class (code, name, del_flag, med_chrgitm_type, yz_class_code) VALUES (N'K', N'药品费', N'0', N'09', null);
INSERT INTO zd_charge_class (code, name, del_flag, med_chrgitm_type, yz_class_code) VALUES (N'L', N'血费', N'0', null, null);
INSERT INTO zd_charge_class (code, name, del_flag, med_chrgitm_type, yz_class_code) VALUES (N'M', N'鉴定费', N'0', null, N'G');
alter table yz_order_item alter column order_name nvarchar(120)
alter table yz_order_item alter column py_code varchar(120)
alter table jc_zd_item add limit_times int,surcharge varchar(8)
exec sp_addextendedproperty 'MS_Description', N'限制收费次数', 'SCHEMA', 'dbo', 'TABLE', 'jc_zd_item', 'COLUMN',
'limit_times'
go
exec sp_addextendedproperty 'MS_Description', N'加收项目', 'SCHEMA', 'dbo', 'TABLE', 'jc_zd_item', 'COLUMN', 'surcharge'
go
alter table ysh_zd_part_code add parent_code varchar(6)
exec sp_addextendedproperty 'MS_Description', N'检查类别（jc_zd_class.code）限定部位', 'SCHEMA', 'dbo', 'TABLE',
'ysh_zd_part_code', 'COLUMN', 'parent_code'
go
