Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| MembershipRuleSeq | int identity | 4 | √ | null |
|
|
||||
| MembershipTypeSeq | int | 4 | null |
|
|
|||||
| Name | varchar | 128 | ('') |
|
|
|||||
| ConstitCode | varchar | 15 | ('') |
|
|
|||||
| CampusCode | varchar | 3 | ('') |
|
|
|||||
| YearLevelCode | int | 4 | √ | null |
|
|
||||
| TutorCode | varchar | 15 | ('') |
|
|
|||||
| FormCode | varchar | 15 | ('') |
|
|
|||||
| HouseCode | varchar | 5 | ('') |
|
|
|||||
| BoardingHouseCode | varchar | 15 | ('') |
|
|
|||||
| FileTypeCode | varchar | 5 | ('') |
|
|
|||||
| ClassCode | varchar | 15 | ('') |
|
|
|||||
| DepartmentCode | varchar | 15 | ('') |
|
|
|||||
| StaffCategoryCode | varchar | 15 | ('') |
|
|
|||||
| JobPositionCode | varchar | 15 | ('') |
|
|
|||||
| SubSchoolCode | varchar | 15 | ('') |
|
|
|||||
| FileYear | smallint | 2 | √ | null |
|
|
||||
| FileSemester | smallint | 2 | √ | null |
|
|
||||
| ID | int | 4 | √ | null |
|
|
||||
| ConfigGroupSecurityCode | varchar | 15 | ('') |
|
|
|||||
| PTICycleCode | varchar | 15 | √ | null |
|
|
||||
| SecurityViewFlag | bit | 1 | ((0)) |
|
|
|||||
| SecurityUpdateFlag | bit | 1 | ((0)) |
|
|
|||||
| SecurityInsertFlag | bit | 1 | ((0)) |
|
|
|||||
| SecurityDeleteFlag | bit | 1 | ((0)) |
|
|
|||||
| SystemCreatedFlag | bit | 1 | ((0)) |
|
|
|||||
| ActiveFlag | bit | 1 | ((1)) |
|
|
|||||
| CreatedByID | int | 4 | √ | null |
|
|
||||
| CreatedDateTime | datetime | 16,3 | (getdate()) |
|
|
|||||
| ModifiedByID | int | 4 | √ | null |
|
|
||||
| ModifiedDateTime | datetime | 16,3 | (getdate()) |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_MembershipRule | Primary key | Asc | MembershipRuleSeq |
| AK_MembershipRule_CampusCode | Performance | Asc | CampusCode |
| AK_MembershipRule_ClassCode | Performance | Asc | ClassCode |
| AK_MembershipRule_FileSemester | Performance | Asc | FileSemester |
| AK_MembershipRule_FileTypeCode | Performance | Asc | FileTypeCode |
| AK_MembershipRule_FileYear | Performance | Asc | FileYear |
| AK_MembershipRule_MembershipTypeSeq | Performance | Asc | MembershipTypeSeq |
Relationships
Close relationships within degrees of separation
