Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE juristDB
- GO
- CREATE TABLE [LAWSUIT] /*ДЕЛО*/
- (
- [caseNumber] varchar(30) NOT NULL , /*№ дела*/
- [courtName] varchar(max) NOT NULL , /*Наименование суда*/
- [caseDescription] varchar(max) NULL , /*Краткое описание дела*/
- [courtDecisionNumber] varchar(30) NULL , /*Номер решения суда*/
- [courtDecisionDate] datetime NULL , /*Дата решения суда*/
- [courtDecisionActDate] datetime NULL , /*Дата вступления в силу решения суда*/
- [caseStatus] varchar(18) NULL , /*Статус дела*/
- [courtDecisionSendDate] datetime NULL , /*Дата отправки решения суда*/
- [execIncomeMesNumber] varchar(30) NULL , /*№ входящего сообщения об исполнении решения суда*/
- [execIncomeMesDate] datetime NULL , /*Дата входящего сообщения об исполнении решения суда*/
- [execStatus] varchar(18) NULL , /*Статус исполнения*/
- [debtorNumber] int NULL , /*ИИН/БИН должника*/
- [debtorName] varchar(max) NULL , /*ФИО/Наименование должника*/
- [execDocDestination] varchar(max) NULL , /*Адресат документа об исполнении*/
- [bailiff] int NOT NULL , /*Судебный исполнитель*/
- [forfeit] float NULL , /*Неустойка*/
- [paymentDate] datetime NULL , /*Дата оплаты*/
- [stateFee] float NULL , /*Гос. пошлина*/
- [paid] float NULL , /*Оплачено*/
- [debtAmount] float NULL , /*Общая сумма долга*/
- [executor] varchar(18) NOT NULL , /*Исполнитель*/
- CONSTRAINT [PK_LAWSUIT] PRIMARY KEY CLUSTERED ([caseNumber] ASC)
- )
- GO
- CREATE TABLE [DOC] /*ДОКУМЕНТ*/
- (
- [docPath] varchar(255) NOT NULL , /*Расположение*/
- [caseNumber] varchar(30) NOT NULL , /*Номер дела*/
- CONSTRAINT [PK_DOC] PRIMARY KEY CLUSTERED ([docPath] ASC)
- )
- GO
- CREATE TABLE [EXECUTOR] /*Исполнитель*/
- (
- [execName] varchar(18) NOT NULL , /*ФИО*/
- [position] varchar(18) NULL , /*Должность*/
- [fillingDate] datetime NULL , /*Дата заполнения*/
- CONSTRAINT [PK_EXECUTOR] PRIMARY KEY CLUSTERED ([execName] ASC)
- )
- GO
- CREATE TABLE [CONTACT] /*Контакт*/
- (
- [contactNumber] int NOT NULL , /*ИИН/БИН*/
- [contactName] varchar(max) NULL , /*ФИО/Название*/
- [contactAdress] varchar(max) NULL , /*Адрес*/
- CONSTRAINT [PK_CONTACT] PRIMARY KEY CLUSTERED ([contactNumber] ASC)
- )
- GO
- CREATE TABLE [PROCESS] /*Процесс*/
- (
- [caseNumber] varchar(30) NOT NULL , /*№ дела*/
- [processDate] datetime NOT NULL , /*Дата*/
- CONSTRAINT [PK_PROCESS] PRIMARY KEY CLUSTERED ([caseNumber] ASC,[processDate] ASC)
- )
- GO
- CREATE TABLE [COURT] /*Суд*/
- (
- [courtID] int NOT NULL IDENTITY(1,1) ,
- [courtName] varchar(max) NOT NULL , /*Наименование*/
- [judge] varchar(max) NULL , /*Судья*/
- [secretary] varchar(max) NULL , /*Секретарь*/
- [courtPhone] int NULL , /*Номер городского телефона*/
- [mobilePhone] int NULL , /*Номер мобильного телефона*/
- CONSTRAINT [PK_COURT] PRIMARY KEY CLUSTERED ([courtName] ASC)
- )
- GO
- CREATE TABLE [BAILIFF] /*Судебный исполнитель*/
- (
- [bailiffName] varchar(max) NULL , /*ФИО*/
- [bailiffPhone] int NOT NULL , /*Номер телефона*/
- CONSTRAINT [PK_BAILIFF] PRIMARY KEY CLUSTERED ([bailiffPhone] ASC)
- )
- GO
- CREATE TABLE [LOGS]
- (
- [id] int NOT NULL IDENTITY(1,1),
- [logTime] datetime NOT NULL ,
- [userID] varchar(max) NOT NULL ,
- [logOperation] int NOT NULL ,
- [initialValue] varchar(max) NULL ,
- [finalValue] varchar(max) NULL ,
- CONSTRAINT [PK_LOGS] PRIMARY KEY CLUSTERED ([id] ASC)
- )
- GO
- ALTER TABLE [LAWSUIT]
- ADD CONSTRAINT [FK_LAWSUIT_COURT] FOREIGN KEY ([courtName]) REFERENCES [COURT]([courtName])
- ON DELETE NO ACTION
- ON UPDATE CASCADE
- GO
- ALTER TABLE [LAWSUIT]
- ADD CONSTRAINT [FK_LAWSUIT_BAILIFF] FOREIGN KEY ([bailiff]) REFERENCES [BAILIFF]([bailiffPhone])
- ON DELETE NO ACTION
- ON UPDATE CASCADE
- GO
- ALTER TABLE [LAWSUIT]
- ADD CONSTRAINT [FK_LAWSUIT_EXECUTOR] FOREIGN KEY ([executor]) REFERENCES [EXECUTOR]([execName])
- ON DELETE NO ACTION
- ON UPDATE CASCADE
- GO
- ALTER TABLE [DOC]
- ADD CONSTRAINT [FK_DOC_LAWSUIT] FOREIGN KEY ([caseNumber]) REFERENCES [LAWSUIT]([caseNumber])
- ON DELETE NO ACTION
- ON UPDATE CASCADE
- GO
- ALTER TABLE [PROCESS]
- ADD CONSTRAINT [FK_PROCESS_LAWSUIT] FOREIGN KEY ([caseNumber]) REFERENCES [LAWSUIT]([caseNumber])
- ON DELETE NO ACTION
- ON UPDATE CASCADE
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement