dbo.tbl_data_out

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 (~)	64555
Created	1/10/2013 10:47:54
Last Modified	11/6/2018 11:33:28

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
	id_data_out_hdr	bigint	8	19	0	True	1 - 1	False	False
	doc_out_no	varchar	50	0	0	False		False	False
3	doc_out_date	datetime	8	23	3	False		False	False
6	doc_out_to_id	int	4	10	0	False		False	False
	id_data_out_hdr_h_status	bigint	8	19	0	False		False	False
2	id_terkait	bigint	8	19	0	False		False	False
	approve_date	datetime	8	23	3	False		False	False
	create_date	datetime	8	23	3	False		False	False
	create_by	varchar	50	0	0	False		False	False
	update_date	datetime	8	23	3	False		False	False
	update_by	varchar	50	0	0	False		False	False

Indexes

Name	Columns	Unique
ix_auto_tbl_data_out_hdr_20161008_0001	id_terkait	False
ix_auto_tbl_data_out_hdr_20161008_0002	doc_out_to_id, id_terkait	False
ix_auto_tbl_data_out_hdr_20161019_0001	doc_out_date, doc_out_to_id	False
ix_auto_tbl_data_out_hdr_20161019_0002	doc_out_date, doc_out_to_id	False
ix_auto_tbl_data_out_hdr_20161019_0003	doc_out_to_id	False
ix_auto_tbl_data_out_hdr_20161019_0004	doc_out_to_id	False
ix_auto_tbl_data_out_hdr_20161019_0005	doc_out_date	False
IX_doc_out_to_id	doc_out_to_id	False
PK_tbl_data_out_hdr	id_data_out_hdr	True

Foreign Keys

Name	Columns	Description
FK_tbl_data_out_hdr_enum_data_out_from	doc_out_to_id
FK_tbl_data_out_hdr_tbl_data_out_hdr_h_status1	id_data_out_hdr_h_status
FK_tbl_data_out_hdr_tbl_vgi_hdr	id_vgi_hdr

SQL Script

CREATE TABLE dbo.tbl_data_out_hdr (
  id_data_out_hdr bigint IDENTITY,
  doc_out_no varchar(50) NULL,
  doc_out_date datetime NULL,
  doc_out_to_id int NULL,
  id_data_out_hdr_h_status bigint NULL,
  id_terkait bigint NULL,
  approve_date datetime NULL,
  create_date datetime NULL,
  create_by varchar(50) NULL,
  update_date datetime NULL,
  update_by varchar(50) NULL,
  CONSTRAINT PK_tbl_data_out_hdr PRIMARY KEY CLUSTERED (id_data_out_hdr) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_data_out_hdr_20161008_0001
  ON dbo.tbl_data_out_hdr (id_terkait)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_data_out_hdr_20161008_0002
  ON dbo.tbl_data_out_hdr (doc_out_to_id, id_terkait)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_data_out_hdr_20161019_0001
  ON dbo.tbl_data_out_hdr (doc_out_date, doc_out_to_id)
  INCLUDE (id_terkait)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_data_out_hdr_20161019_0002
  ON dbo.tbl_data_out_hdr (doc_out_date, doc_out_to_id)
  INCLUDE (doc_out_no, id_terkait)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_data_out_hdr_20161019_0003
  ON dbo.tbl_data_out_hdr (doc_out_to_id)
  INCLUDE (id_data_out_hdr, id_data_out_hdr_h_status)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_data_out_hdr_20161019_0004
  ON dbo.tbl_data_out_hdr (doc_out_to_id)
  INCLUDE (id_data_out_hdr, id_data_out_hdr_h_status)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_data_out_hdr_20161019_0005
  ON dbo.tbl_data_out_hdr (doc_out_date)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX IX_doc_out_to_id
  ON dbo.tbl_data_out_hdr (doc_out_to_id)
  INCLUDE (id_data_out_hdr, doc_out_no, doc_out_date, id_terkait, approve_date)
  ON [PRIMARY]
GO

ALTER TABLE dbo.tbl_data_out_hdr WITH NOCHECK
  ADD CONSTRAINT FK_tbl_data_out_hdr_enum_data_out_from FOREIGN KEY (doc_out_to_id) REFERENCES dbo.enum_data_out_to (doc_out_to_id) NOT FOR REPLICATION
GO

ALTER TABLE dbo.tbl_data_out_hdr
  NOCHECK CONSTRAINT FK_tbl_data_out_hdr_enum_data_out_from
GO

ALTER TABLE dbo.tbl_data_out_hdr WITH NOCHECK
  ADD CONSTRAINT FK_tbl_data_out_hdr_tbl_data_out_hdr_h_status1 FOREIGN KEY (id_data_out_hdr_h_status) REFERENCES dbo.tbl_data_out_hdr_h_status (id_data_out_hdr_h_status) NOT FOR REPLICATION
GO

ALTER TABLE dbo.tbl_data_out_hdr
  NOCHECK CONSTRAINT FK_tbl_data_out_hdr_tbl_data_out_hdr_h_status1
GO

ALTER TABLE dbo.tbl_data_out_hdr WITH NOCHECK
  ADD CONSTRAINT FK_tbl_data_out_hdr_tbl_vgi_hdr FOREIGN KEY (id_terkait) REFERENCES dbo.tbl_vgi_hdr (id_vgi_hdr) NOT FOR REPLICATION
GO

ALTER TABLE dbo.tbl_data_out_hdr
  NOCHECK CONSTRAINT FK_tbl_data_out_hdr_tbl_vgi_hdr
GO

dbo.tbl_data_out_hdr