|
Write Conflict (Access & SQL)
#39446885
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
Участник
Откуда: Tbilisi
Сообщения: 2 885
|
|
studieren,
Здесь дана вся таблица
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
CREATE TABLE [dbo].[patients_history](
[id_patient_history] [int] IDENTITY(1,1) NOT NULL,
[id_patient] [int] NULL,
[salaro] [nvarchar](2) NULL,
[id_gadaricxva] [int] NULL,
[code_virusology] [int] NULL,
[codetxt_virusology] [nvarchar](6) NULL,
[code_virusology_old] [int] NULL,
[code_immunology] [int] NULL,
[code_clinical] [int] NULL,
[id_clinical] [nvarchar](50) NULL,
[old_note] [nvarchar](255) NULL,
[old_momartvis_tarigi] [datetime] NULL,
[momartvis_tarigi] [datetime] NULL,
[visitis_time] [datetime] NULL,
[id_eqimi] [int] NULL,
[id_laboranti_virusology] [int] NULL,
[id_laboranti_immunology] [int] NULL,
[id_laboranti_clinical] [int] NULL,
[old_kvitris_nomeri] [int] NULL,
[kvitris_nomeri] [int] NULL,
[kvitris_txt] [nvarchar](20) NULL,
[kodebi] [ntext] NULL,
[sum_gamokvlevis_tanxa] [money] NULL,
[procent] [int] NULL,
[salaros_tanxa] [money] NULL,
[baratis_tanxa] [money] NULL,
[balance_tanxa] [money] NULL,
[gadaricxvis_tanxa] [money] NULL,
[gadaricxvis_tanxa_2] [money] NULL,
[natilobrivi_tanxa] [money] NULL,
[shidsis_centri] [tinyint] NULL CONSTRAINT [DF_patients_history_shidsis_centri] DEFAULT ((0)),
[gadaricxva] [tinyint] NULL CONSTRAINT [DF_patients_history_gadaricxva] DEFAULT ((0)),
[mark_virusology] [tinyint] NULL CONSTRAINT [DF_patients_history_mark_virusology] DEFAULT ((0)),
[mark_immunology] [tinyint] NULL CONSTRAINT [DF_patients_history_mark_immunology] DEFAULT ((0)),
[mark_clinical] [tinyint] NULL CONSTRAINT [DF_patients_history_mark_clinical] DEFAULT ((0)),
[mark_aids] [tinyint] NULL CONSTRAINT [DF_patients_history_mark_aids] DEFAULT ((0)),
[granti] [tinyint] NULL CONSTRAINT [DF_patients_history_granti] DEFAULT ((0)),
[not_paid_tests] [tinyint] NULL CONSTRAINT [DF_patients_history_not_paid_tests] DEFAULT ((0)),
[id_organization] [int] NULL,
[elimination] [tinyint] NULL CONSTRAINT [DF_patients_history_elimination] DEFAULT ((0)),
[social_patient] [tinyint] NULL CONSTRAINT [DF_patients_history_social_patient] DEFAULT ((0)),
[factura_nomer] [int] NULL,
[factura_date] [datetime] NULL,
[factura_shemkveti] [nvarchar](255) NULL,
[shemotanili_tanxa] [money] NULL,
[dabrunebuli_tanxa] [money] NULL,
[davalianeba] [money] NULL,
[dasabrunebeli_tanxa] [money] NULL,
[status_account] [tinyint] NULL CONSTRAINT [DF_patients_history_status_account] DEFAULT ((0)),
[note] [nvarchar](255) NULL,
[sisxlis_aghebis_tarigi] [datetime] NULL,
[davalianeba_chk] [tinyint] NULL CONSTRAINT [DF_patients_history_davalianeba_chk] DEFAULT ((0)),
[gadmotanili_chk] [tinyint] NULL CONSTRAINT [DF_patients_history_gadmotanili_chk] DEFAULT ((0)),
[gadmotanili_tanxa] [money] NULL,
[fasdaklebis_tanxa] [money] NULL,
[note_account] [nvarchar](255) NULL,
[monitoring] [tinyint] NULL CONSTRAINT [DF_patients_history_monitoring] DEFAULT ((0)),
[pirveladi] [tinyint] NULL CONSTRAINT [DF_patients_history_pirveladi] DEFAULT ((0)),
[forma_100] [tinyint] NULL CONSTRAINT [DF_patients_history_forma_100] DEFAULT ((0)),
[meore_etapi] [tinyint] NULL CONSTRAINT [DF_patients_history_meore_etapi] DEFAULT ((0)),
[baratis_nomeri] [nvarchar](15) NULL,
[consult_room] [int] NULL,
[blood_room] [int] NULL,
[eqo_room] [int] NULL,
[fibro_room] [int] NULL,
[gastro_room] [int] NULL,
[status_deleted] [tinyint] NULL CONSTRAINT [DF_patients_history_status_deleted] DEFAULT ((0)),
[date_deleted] [timestamp] NULL,
CONSTRAINT [PK_patients_history] PRIMARY KEY CLUSTERED
(
[id_patient_history] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
|
|
|
