|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | ST_TERM_A |
| Schema | dbo |
| Row Count | 314 |
| Data Size | 24 KB |
| Index Size | 24 KB |
| Create Date | 8/15/2012 2:10 PM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
FASTER_TITLE |
varchar(10) |
True |
False |
False |
|||
|
|
ISN_ST_TERM_A |
int(10, 0) |
False |
False |
False |
|||
|
|
MAJOR_TERM |
varchar(1) |
True |
False |
False |
|||
|
|
ROLL_OVR_FLG |
varchar(1) |
True |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
|
|
TRM_TRNSCRPT_TTL |
varchar(6) |
True |
False |
False |
|||
|
|
TRM_TTL |
varchar(30) |
True |
False |
False |
|||
|
|
TRM_YR |
varchar(6) |
True |
False |
False |
|||
|
|
TRM_YR_9S_COMP |
varchar(6) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_ST_TERM_A |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.ST_TERM_A depends on)
| Name | Type |
View |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
|
StoredProcedure |
Child Dependencies (objects that depend on dbo.ST_TERM_A)
| Name | Type |
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
STOREDPROCEDURE |
|
VIEW |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[ST_TERM_A] Script Date: 03/09/2017 16:46:31 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ST_TERM_A]( [ISN_ST_TERM_A] [int] NOT NULL, [TRM_YR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TRM_TTL] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ROLL_OVR_FLG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TRM_TRNSCRPT_TTL] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TRM_YR_9S_COMP] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAJOR_TERM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FASTER_TITLE] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| FASTER_TITLE | ISN_ST_TERM_A | MAJOR_TERM | ROLL_OVR_FLG | RowUpdatedOn | TRM_TRNSCRPT_TTL | TRM_TTL | TRM_YR | TRM_YR_9S_COMP |
| 1970-5 | 149 | Y | Y | 2017-02-06T11:27:30.408-05:00 | SMR 2 | FULL SUMMER TERM 1970 | 19705 | 802949 |
| 1953-1 | 181 | Y | Y | 2017-02-06T11:27:30.408-05:00 | FALL | FALL TERM 1952 | 19531 | 804689 |
| 2012-1 | 291 | Y | Y | 2017-02-06T11:27:30.424-05:00 | FALL | FALL TERM 2011 | 20121 | 798789 |
| 1944-1 | 178 | Y | Y | 2017-02-06T11:27:30.408-05:00 | FALL | FALL TERM 1943 | 19441 | 805589 |
| 2009-3 | 284 | Y | Y | 2017-02-06T11:27:30.424-05:00 | SUMMER | SUMMER TERM 2009 | 20093 | 799069 |
| 2002-2 | 252 | Y | Y | 2017-02-06T11:27:30.424-05:00 | SPRING | SPRING TERM 2002 | 20022 | 799779 |
| 1957-1 | 3 | Y | Y | 2017-02-06T11:27:30.408-05:00 | FALL | FALL TERM 1956 | 19571 | 804289 |
| 1954-1 | 138 | Y | Y | 2017-02-06T11:27:30.408-05:00 | FALL | FALL TERM 1953 | 19541 | 804589 |
| 1981-3 | 112 | Y | Y | 2017-02-06T11:27:30.408-05:00 | SPRING | SPRING TERM 1981 | 19813 | 801869 |
| 1968-4 | 88 | Y | Y | 2017-02-06T11:27:30.408-05:00 | SMR 1 | SUMMER TERM 1968 | 19684 | 803159 |
| Powered by BI Documenter |
