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 | 1/14/2016 01:39:03 |
| Last Modified | 11/18/2016 22:44:25 |
Columns
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
id_scrap_fg | bigint | 8 | 19 | 0 | True |
1 - 1 | False |
False |
|||
| CAR | varchar | 26 | 0 | 0 | False |
False |
False |
|||||
| TGAJU | date | 3 | 10 | 0 | False |
False |
False |
|||||
| NAMABELI | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| ALMTBELI | varchar | 70 | 0 | 0 | False |
False |
False |
|||||
| NEGBELI | varchar | 10 | 0 | 0 | False |
False |
False |
|||||
| typedok | varchar | 5 | 0 | 0 | False |
False |
False |
|||||
| NODAFT | varchar | 20 | 0 | 0 | False |
False |
False |
|||||
| TGDAFT | date | 3 | 10 | 0 | False |
False |
False |
|||||
| KDVAL | varchar | 3 | 0 | 0 | False |
False |
False |
|||||
| NilInv | float | 8 | 53 | 0 | False |
False |
False |
|||||
| assy_code | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| part_number | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| part_name_customs | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| qty | float | 8 | 53 | 0 | True |
(0) | False |
False |
||||
| unit | varchar | 5 | 0 | 0 | False |
False |
False |
|||||
| type_items | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| doc_out_no | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| doc_out_date | date | 3 | 10 | 0 | False |
False |
False |
|||||
| status_data | varchar | 50 | 0 | 0 | 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
| Key | Name | Columns | Unique | Type | Description |
|---|---|---|---|---|---|
|
|
PK_tbl_scrap_fg | id_scrap_fg | True |
SQL Script
CREATE TABLE dbo.tbl_bc25_scrap_fg (
id_scrap_fg bigint IDENTITY,
CAR varchar(26) NULL,
TGAJU date NULL,
NAMABELI varchar(50) NULL,
ALMTBELI varchar(70) NULL,
NEGBELI varchar(10) NULL,
typedok varchar(5) NULL,
NODAFT varchar(20) NULL,
TGDAFT date NULL,
KDVAL varchar(3) NULL,
NilInv float NULL,
assy_code varchar(50) NULL,
part_number varchar(50) NULL,
part_name_customs varchar(50) NULL,
qty float NOT NULL CONSTRAINT DF_tbl_scrap_fg_qty DEFAULT (0),
unit varchar(5) NULL,
type_items varchar(50) NULL,
doc_out_no varchar(50) NULL,
doc_out_date date NULL,
status_data varchar(50) NULL,
create_date datetime NULL,
create_by varchar(50) NULL,
update_date datetime NULL,
update_by varchar(50) NULL,
CONSTRAINT PK_tbl_scrap_fg PRIMARY KEY CLUSTERED (id_scrap_fg) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
id_scrap_fg bigint IDENTITY,
CAR varchar(26) NULL,
TGAJU date NULL,
NAMABELI varchar(50) NULL,
ALMTBELI varchar(70) NULL,
NEGBELI varchar(10) NULL,
typedok varchar(5) NULL,
NODAFT varchar(20) NULL,
TGDAFT date NULL,
KDVAL varchar(3) NULL,
NilInv float NULL,
assy_code varchar(50) NULL,
part_number varchar(50) NULL,
part_name_customs varchar(50) NULL,
qty float NOT NULL CONSTRAINT DF_tbl_scrap_fg_qty DEFAULT (0),
unit varchar(5) NULL,
type_items varchar(50) NULL,
doc_out_no varchar(50) NULL,
doc_out_date date NULL,
status_data varchar(50) NULL,
create_date datetime NULL,
create_by varchar(50) NULL,
update_date datetime NULL,
update_by varchar(50) NULL,
CONSTRAINT PK_tbl_scrap_fg PRIMARY KEY CLUSTERED (id_scrap_fg) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
Depends On
No items found