dbo.dt_interface_module

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 (~)	3
Created	10/8/2016 12:25:27
Last Modified	11/18/2016 23:32:30

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Default	Computed	Persisted
interface_module_bc_id	bigint	8	19	True	1 - 1		False	False
computer_name	varbinary		0	False			False	False
computer_address	varbinary		0	False			False	False
local_path	varbinary		0	False			False	False
nomor_reg_bc	varbinary		0	False			False	False
is_palapa	varbinary		0	False			False	False
kantor_bc	varbinary		0	False			False	False
bc_type_id	int	4	10	False			False	False
interface_module_bc_h_status_id	bigint	8	19	False			False	False
aktivasi	varbinary		0	False			False	False
edinum	varbinary		0	False			False	False
show	bit	1	1	False		(1)	False	False
mode_interface_id	int	4	10	False		(1)	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_dt_interface_module_bc	interface_module_bc_id	True

SQL Script

CREATE TABLE dbo.dt_interface_module_bc (
  interface_module_bc_id bigint IDENTITY,
  computer_name varbinary(max) NULL,
  computer_address varbinary(max) NULL,
  local_path varbinary(max) NULL,
  nomor_reg_bc varbinary(max) NULL,
  is_palapa varbinary(max) NULL,
  kantor_bc varbinary(max) NULL,
  bc_type_id int NULL,
  interface_module_bc_h_status_id bigint NULL,
  aktivasi varbinary(max) NULL,
  edinum varbinary(max) NULL,
  show bit NULL CONSTRAINT DF_dt_interface_module_bc_show DEFAULT (1),
  mode_interface_id int NULL CONSTRAINT DF_dt_interface_module_bc_mode_interface_id DEFAULT (1),
  CONSTRAINT PK_dt_interface_module_bc PRIMARY KEY CLUSTERED (interface_module_bc_id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

No items found

dbo.dt_interface_module_bc