|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | AR_BILL_DET_A_STUDENT_COURSE_LINE |
| Schema | dbo |
| Row Count | 651168 |
| Data Size | 20888 KB |
| Index Size | 11032 KB |
| Create Date | 11/5/2012 3:48 PM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
CREDIT_HOURS |
numeric(17, 2) |
True |
False |
False |
|||
|
|
CRS_ITEM_ID |
varchar(10) |
True |
False |
False |
|||
|
|
FEE_AMOUNT |
numeric(17, 2) |
True |
False |
False |
|||
|
|
FEE_TYPE |
varchar(2) |
True |
False |
False |
|||
|
|
ISN_AR_BILL_DET_A |
int(10, 0) |
False |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
True |
False |
False |
|||
|
|
STUDENT_COURSE_LINE_COUNT |
smallint(5, 0) |
False |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_AR_BILL_DET_A, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.AR_BILL_DET_A_STUDENT_COURSE_LINE depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.AR_BILL_DET_A_STUDENT_COURSE_LINE)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[AR_BILL_DET_A_STUDENT_COURSE_LINE] Script Date: 03/09/2017 16:44:55 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[AR_BILL_DET_A_STUDENT_COURSE_LINE]( [ISN_AR_BILL_DET_A] [int] NOT NULL, [STUDENT_COURSE_LINE_COUNT] [smallint] NOT NULL, [CRS_ITEM_ID] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FEE_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FEE_AMOUNT] [numeric](17, 2) NULL, [CREDIT_HOURS] [numeric](17, 2) NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| cnxarraycolumn | CREDIT_HOURS | CRS_ITEM_ID | FEE_AMOUNT | FEE_TYPE | ISN_AR_BILL_DET_A | RowUpdatedOn | STUDENT_COURSE_LINE_COUNT |
| 4 | SYG2000 | 226.80 | 237564 | 2017-02-06T10:28:38.015-05:00 | 6 | ||
| 0 | HEV0804 | 33.36 | 438373 | 2017-02-06T10:28:54.723-05:00 | 2 | ||
| 0 | POO0164 | 172.80 | 233260 | 2017-02-06T10:28:37.625-05:00 | 1 | ||
| 3 | CCJ1010 | 268.14 | 358223 | 2017-02-06T10:28:48.156-05:00 | 4 | ||
| 1 | EMO0183 | 9.00 | 87966 | 2017-02-06T10:28:25.005-05:00 | 2 | ||
| 1 | 3.00 | OCE1001 | 153.00 | CA | 15316 | 2017-02-06T10:28:18.905-05:00 | 4 |
| 2 | PGY2445C | 226.80 | 221863 | 2017-02-06T10:28:36.705-05:00 | 4 | ||
| 1 | RTE2385 | 247.50 | 242094 | 2017-02-06T10:28:38.468-05:00 | 4 | ||
| 1 | 3.00 | ECO2023 | 194.85 | CA | 167398 | 2017-02-06T10:28:31.682-05:00 | 4 |
| 0 | MAT1033L | 60.50 | 403479 | 2017-02-06T10:28:51.884-05:00 | 2 |
| Powered by BI Documenter |
