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 (~) | 0 |
| Created | 12/13/2012 07:37:05 |
| Last Modified | 11/18/2016 23:21:56 |
Columns
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
id_log | bigint | 8 | 19 | 0 | True |
1 - 1 | False |
False |
|||
| inv_hdr_id | bigint | 8 | 19 | 0 | False |
False |
False |
|||||
| r1 | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| r2 | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| r3 | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| r4 | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| r5 | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| r6 | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| r7 | varchar | 255 | 0 | 0 | False |
False |
False |
Indexes
| Key | Name | Columns | Unique | Type | Description |
|---|---|---|---|---|---|
|
|
tbl_inv_hdr_log_pk | id_log | True |
SQL Script
CREATE TABLE dbo.tbl_inv_hdr_log (
id_log bigint IDENTITY,
inv_hdr_id bigint NULL,
r1 varchar(255) NULL,
r2 varchar(255) NULL,
r3 varchar(255) NULL,
r4 varchar(255) NULL,
r5 varchar(255) NULL,
r6 varchar(255) NULL,
r7 varchar(255) NULL,
CONSTRAINT tbl_inv_hdr_log_pk PRIMARY KEY CLUSTERED (id_log) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
id_log bigint IDENTITY,
inv_hdr_id bigint NULL,
r1 varchar(255) NULL,
r2 varchar(255) NULL,
r3 varchar(255) NULL,
r4 varchar(255) NULL,
r5 varchar(255) NULL,
r6 varchar(255) NULL,
r7 varchar(255) NULL,
CONSTRAINT tbl_inv_hdr_log_pk PRIMARY KEY CLUSTERED (id_log) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
Depends On
No items found
Used By
No items found