dbo.tbl_bc_in

Description

Properties

Name	Value
Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	False
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	150259
Created	1/10/2013 21:22:17
Last Modified	1/28/2020 15:14:18

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
	id_bc_in_dok	bigint	8	19	0	True	1 - 1	False	False
3	id_bc_in_hdr	bigint	8	19	0	False		False	False
	CAR	varchar	26	0	0	True		False	False
5	DokKd	varchar	3	0	0	True		False	False
	DokNo	varchar	25	0	0	True		False	False
	DokTg	datetime	8	23	3	False		False	False

Indexes

Name	Columns	Unique
ix_auto_tbl_bc_in_dok_20161008_0001	id_bc_in_hdr	False
ix_auto_tbl_bc_in_dok_20161008_0002	CAR, DokKd, DokNo	False
ix_auto_tbl_bc_in_dok_20161008_0003	id_bc_in_hdr, DokKd	False
ix_auto_tbl_bc_in_dok_20161008_0004	id_bc_in_hdr, DokKd	False
ix_auto_tbl_bc_in_dok_20161008_0005	DokKd	False
ix_auto_tbl_bc_in_dok_20161008_0006	DokKd	False
PK_tbl_bc_in_dok	id_bc_in_dok	True

Foreign Keys

Name	Columns	Description
FK_tbl_bc_in_dok_tbl_bc_in_hdr	id_bc_in_hdr

SQL Script

CREATE TABLE dbo.tbl_bc_in_dok (
  id_bc_in_dok bigint IDENTITY,
  id_bc_in_hdr bigint NULL,
  CAR varchar(26) NOT NULL,
  DokKd varchar(3) NOT NULL,
  DokNo varchar(25) NOT NULL,
  DokTg datetime NULL,
  CONSTRAINT PK_tbl_bc_in_dok PRIMARY KEY CLUSTERED (id_bc_in_dok) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_dok_20161008_0001
  ON dbo.tbl_bc_in_dok (id_bc_in_hdr)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_dok_20161008_0002
  ON dbo.tbl_bc_in_dok (CAR, DokKd, DokNo)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_dok_20161008_0003
  ON dbo.tbl_bc_in_dok (id_bc_in_hdr, DokKd)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_dok_20161008_0004
  ON dbo.tbl_bc_in_dok (id_bc_in_hdr, DokKd)
  INCLUDE (DokNo, DokTg)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_dok_20161008_0005
  ON dbo.tbl_bc_in_dok (DokKd)
  INCLUDE (id_bc_in_hdr)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_dok_20161008_0006
  ON dbo.tbl_bc_in_dok (DokKd)
  INCLUDE (id_bc_in_hdr, DokNo, DokTg)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

ALTER TABLE dbo.tbl_bc_in_dok WITH NOCHECK
  ADD CONSTRAINT FK_tbl_bc_in_dok_tbl_bc_in_hdr FOREIGN KEY (id_bc_in_hdr) REFERENCES dbo.tbl_bc_in_hdr (id_bc_in_hdr) NOT FOR REPLICATION
GO

ALTER TABLE dbo.tbl_bc_in_dok
  NOCHECK CONSTRAINT FK_tbl_bc_in_dok_tbl_bc_in_hdr
GO

Depends On

dbo.tbl_bc_in_hdr

dbo.tbl_bc_in_dok