CONSTITUENCYDATERANGE
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| DATEFROM | date | yes | ||
| DATETO | date | yes | ||
| CONSTITUENCYRECORDIDENTIFIER | uniqueidentifier | yes | ||
| REFRESHDATE | datetime | yes | ||
| DATEADDED | datetime | yes | ||
| DATECHANGED | datetime | yes | ||
| CONSTITUENCYTS | varbinary | yes | ||
| ADDEDBYAPPLICATIONNAME | nvarchar(200) | Default = '' | ||
| ADDEDBYUSERNAME | nvarchar(128) | Default = '' | ||
| CHANGEDBYAPPLICATIONNAME | nvarchar(200) | Default = '' | ||
| CHANGEDBYUSERNAME | nvarchar(128) | Default = '' |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| CONSTITUENTID | uniqueidentifier | CONSTITUENT.LOCALID | ||
| CONSTITUENCYDEFINITIONID | uniqueidentifier | CONSTITUENCYDEFINITION.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_CONSTITUENCYDATERANGE_CONSTITUENCYRECORDIDENTIFIER | CONSTITUENCYRECORDIDENTIFIER | |||
| IX_CONSTITUENCYDATERANGE_CONSTITUENTID_CONSTITUENCYDEFINITIONID | CONSTITUENTID, CONSTITUENCYDEFINITIONID | |||
| PK_CONSTITUENCYDATERANGE | ID | yes | yes | yes |