UserPersonalPages
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| Name | nvarchar(50) | |||
| IsPublished | bit | Default = 1 | ||
| IsHome | bit | Default = 0 |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ParentID | int | FundRaiserSolicitors.ID | ||
| FundRaiserPageID | int | yes | FundRaiserPages.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| ix_UPP_ParentID_Home | ParentID, IsHome | |||
| PK_UserPersonalPages | ID | yes | yes | yes |
Triggers
| Trigger Name | Description |
|---|---|
| TR_UserPersonalPages_CASCDE_DEL_1 |