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 | 2/19/2013 14:18:10 |
| Last Modified | 11/18/2016 23:31:45 |
Columns
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CAR | varchar | 200 | 0 | 0 | True |
False |
False |
||||
|
|
SeriEks | int | 4 | 10 | 0 | True |
False |
False |
||||
| JnPEBG | varchar | 1 | 0 | 0 | False |
False |
False |
|||||
| JnEksG | varchar | 1 | 0 | 0 | False |
False |
False |
|||||
| IdeksG | varchar | 1 | 0 | 0 | False |
False |
False |
|||||
| NpwpEksG | varchar | 15 | 0 | 0 | False |
False |
False |
|||||
| NamaEksG | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| AlmtEksG | varchar | 70 | 0 | 0 | False |
False |
False |
|||||
| NiperG | varchar | 4 | 0 | 0 | False |
False |
False |
|||||
| KdValG | varchar | 3 | 0 | 0 | False |
False |
False |
|||||
| FOBG | float | 8 | 53 | 0 | False |
False |
False |
|||||
| JmBrgG | bigint | 8 | 19 | 0 | False |
False |
False |
|||||
| NoLpseG | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| TgLpseG | date | 3 | 10 | 0 | False |
False |
False |
|||||
| InstFasG | varchar | 1 | 0 | 0 | False |
False |
False |
|||||
| KdktrFasG | varchar | 6 | 0 | 0 | False |
False |
False |
|||||
| FasBCG | varchar | 1 | 0 | 0 | False |
False |
False |
|||||
| KpkerG | varchar | 2 | 0 | 0 | False |
False |
False |
|||||
| FasilitasG | varchar | 1 | 0 | 0 | False |
False |
False |
|||||
| KwbcG | varchar | 6 | 0 | 0 | False |
False |
False |
|||||
| GabOK | char | 1 | 0 | 0 | False |
False |
False |
Indexes
| Key | Name | Columns | Unique | Type | Description |
|---|---|---|---|---|---|
|
|
PK__tblPebGa__D7532E8F196BA376 | CAR, SeriEks | True |
SQL Script
CREATE TABLE dbo.tblPebGab (
CAR varchar(200) NOT NULL,
SeriEks int NOT NULL,
JnPEBG varchar(1) NULL,
JnEksG varchar(1) NULL,
IdeksG varchar(1) NULL,
NpwpEksG varchar(15) NULL,
NamaEksG varchar(50) NULL,
AlmtEksG varchar(70) NULL,
NiperG varchar(4) NULL,
KdValG varchar(3) NULL,
FOBG float NULL,
JmBrgG bigint NULL,
NoLpseG varchar(50) NULL,
TgLpseG date NULL,
InstFasG varchar(1) NULL,
KdktrFasG varchar(6) NULL,
FasBCG varchar(1) NULL,
KpkerG varchar(2) NULL,
FasilitasG varchar(1) NULL,
KwbcG varchar(6) NULL,
GabOK char(1) NULL,
CONSTRAINT PK__tblPebGa__D7532E8F196BA376 PRIMARY KEY CLUSTERED (CAR, SeriEks) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
CAR varchar(200) NOT NULL,
SeriEks int NOT NULL,
JnPEBG varchar(1) NULL,
JnEksG varchar(1) NULL,
IdeksG varchar(1) NULL,
NpwpEksG varchar(15) NULL,
NamaEksG varchar(50) NULL,
AlmtEksG varchar(70) NULL,
NiperG varchar(4) NULL,
KdValG varchar(3) NULL,
FOBG float NULL,
JmBrgG bigint NULL,
NoLpseG varchar(50) NULL,
TgLpseG date NULL,
InstFasG varchar(1) NULL,
KdktrFasG varchar(6) NULL,
FasBCG varchar(1) NULL,
KpkerG varchar(2) NULL,
FasilitasG varchar(1) NULL,
KwbcG varchar(6) NULL,
GabOK char(1) NULL,
CONSTRAINT PK__tblPebGa__D7532E8F196BA376 PRIMARY KEY CLUSTERED (CAR, SeriEks) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
Depends On
No items found
Used By
No items found