Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CommunityMembershipSeq | int identity | 4 | √ | null |
|
|
||||
| ID | int | 4 | null |
|
|
|||||
| MembershipTypeSeq | int | 4 | null |
|
|
|||||
| SecurityViewFlag | bit | 1 | ((0)) |
|
|
|||||
| SecurityUpdateFlag | bit | 1 | ((0)) |
|
|
|||||
| SecurityInsertFlag | bit | 1 | ((0)) |
|
|
|||||
| SecurityDeleteFlag | bit | 1 | ((0)) |
|
|
|||||
| DisplayFlag | bit | 1 | ((0)) |
|
|
|||||
| BackgroundColor | int | 4 | √ | null |
|
|
||||
| CreatedDateTime | datetime | 16,3 | (getdate()) |
|
|
|||||
| ModifiedDateTime | datetime | 16,3 | √ | null |
|
|
||||
| CreatedByID | int | 4 | √ | null |
|
|
||||
| ModifiedByID | int | 4 | √ | null |
|
|
||||
| InsertAppointmentFlag | bit | 1 | ((0)) |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CommunityMembership | Primary key | Asc | CommunityMembershipSeq |
| AK_CommunityMembership_ID | Performance | Asc | ID |
| AK_CommunityMembership_MembershipTypeSeq | Performance | Asc | MembershipTypeSeq |
Relationships
Close relationships within degrees of separation
