if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Ligne_ticket_reception]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Ligne_ticket_reception]
GO

CREATE TABLE [dbo].[Ligne_ticket_reception] (
	[Num_ligne_ticket_reception] [int] IDENTITY (1, 1) NOT NULL ,
	[Num_ticket_reception] [int] NOT NULL ,
	[Num_intervenant_structure] [int] NOT NULL ,
	[Qte] [int] NOT NULL ,
	[Prix_unit] [int] NOT NULL ,
	[Ticket_moderateur] [int] NOT NULL ,
	[Prix_patient] AS ([prix_unit] * [qte] * [ticket_moderateur] / 100) ,
	[Prix_prise_en_charge] AS ([prix_unit] * [qte] - [prix_unit] * [qte] * [ticket_moderateur] / 100) ,
	[Prix_total] AS ([prix_unit] * [qte]) ,
	[Prix_patient_avoir] [int] NOT NULL ,
	[Prix_prise_en_charge_avoir] [int] NOT NULL ,
	[Prix_total_avoir] [int] NOT NULL 
) ON [PRIMARY]
GO