SH.TIMES (table) - Revision history

Bot at 05:16, 24 June 2010

2010-06-24T05:16:52Z

Show changes

Bot at 07:29, 11 February 2010

2010-02-11T07:29:51Z

Show changes

Bot at 19:01, 24 August 2009

2009-08-24T19:01:55Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | SH.TIMES |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-c...

2009-05-02T17:06:48Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | SH.TIMES |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-c...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| SH.TIMES
|-
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''PK
| '''Index

|-
| TIME_ID
| DATE
| not null
|
| TIMES_PK
|
|-
| DAY_NAME
| VARCHAR2
| not null
|
|
|
|-
| DAY_NUMBER_IN_WEEK
| NUMBER
| not null
|
|
|
|-
| DAY_NUMBER_IN_MONTH
| NUMBER
| not null
|
|
|
|-
| CALENDAR_WEEK_NUMBER
| NUMBER
| not null
|
|
|
|-
| FISCAL_WEEK_NUMBER
| NUMBER
| not null
|
|
|
|-
| WEEK_ENDING_DAY
| DATE
| not null
|
|
|
|-
| WEEK_ENDING_DAY_ID
| NUMBER
| not null
|
|
|
|-
| CALENDAR_MONTH_NUMBER
| NUMBER
| not null
|
|
|
|-
| FISCAL_MONTH_NUMBER
| NUMBER
| not null
|
|
|
|-
| CALENDAR_MONTH_DESC
| VARCHAR2
| not null
|
|
|
|-
| CALENDAR_MONTH_ID
| NUMBER
| not null
|
|
|
|-
| FISCAL_MONTH_DESC
| VARCHAR2
| not null
|
|
|
|-
| FISCAL_MONTH_ID
| NUMBER
| not null
|
|
|
|-
| DAYS_IN_CAL_MONTH
| NUMBER
| not null
|
|
|
|-
| DAYS_IN_FIS_MONTH
| NUMBER
| not null
|
|
|
|-
| END_OF_CAL_MONTH
| DATE
| not null
|
|
|
|-
| END_OF_FIS_MONTH
| DATE
| not null
|
|
|
|-
| CALENDAR_MONTH_NAME
| VARCHAR2
| not null
|
|
|
|-
| FISCAL_MONTH_NAME
| VARCHAR2
| not null
|
|
|
|-
| CALENDAR_QUARTER_DESC
| CHAR(7)
| not null
|
|
|
|-
| CALENDAR_QUARTER_ID
| NUMBER
| not null
|
|
|
|-
| FISCAL_QUARTER_DESC
| CHAR(7)
| not null
|
|
|
|-
| FISCAL_QUARTER_ID
| NUMBER
| not null
|
|
|
|-
| DAYS_IN_CAL_QUARTER
| NUMBER
| not null
|
|
|
|-
| DAYS_IN_FIS_QUARTER
| NUMBER
| not null
|
|
|
|-
| END_OF_CAL_QUARTER
| DATE
| not null
|
|
|
|-
| END_OF_FIS_QUARTER
| DATE
| not null
|
|
|
|-
| CALENDAR_QUARTER_NUMBER
| NUMBER
| not null
|
|
|
|-
| FISCAL_QUARTER_NUMBER
| NUMBER
| not null
|
|
|
|-
| CALENDAR_YEAR
| NUMBER
| not null
|
|
|
|-
| CALENDAR_YEAR_ID
| NUMBER
| not null
|
|
|
|-
| FISCAL_YEAR
| NUMBER
| not null
|
|
|
|-
| FISCAL_YEAR_ID
| NUMBER
| not null
|
|
|
|-
| DAYS_IN_CAL_YEAR
| NUMBER
| not null
|
|
|
|-
| DAYS_IN_FIS_YEAR
| NUMBER
| not null
|
|
|
|-
| END_OF_CAL_YEAR
| DATE
| not null
|
|
|
|-
| END_OF_FIS_YEAR
| DATE
| not null
|
|
|
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table
| '''Column
| '''Referencing Column

|-
| [[SH.COSTS_(table)|SH.COSTS]]
| TIME_ID
| TIME_ID
|-
| [[SH.SALES_(table)|SH.SALES]]
| TIME_ID
| TIME_ID
|}

@@ Line 20: / Line 20: @@
 |-
 | TIME_ID
-| DATE
+| DATE(7)
 | not null
+|
@@ Line 27: / Line 27: @@
 |-
 | DAY_NAME
-| VARCHAR2
+| VARCHAR2(9)
 | not null
+|
@@ Line 34: / Line 34: @@
 |-
 | DAY_NUMBER_IN_WEEK
-| NUMBER
+| NUMBER(1, 0)
 | not null
+|
@@ Line 41: / Line 41: @@
 |-
 | DAY_NUMBER_IN_MONTH
-| NUMBER
+| NUMBER(2, 0)
 | not null
+|
@@ Line 48: / Line 48: @@
 |-
 | CALENDAR_WEEK_NUMBER
-| NUMBER
+| NUMBER(2, 0)
 | not null
+|
@@ Line 55: / Line 55: @@
 |-
 | FISCAL_WEEK_NUMBER
-| NUMBER
+| NUMBER(2, 0)
 | not null
+|
@@ Line 62: / Line 62: @@
 |-
 | WEEK_ENDING_DAY
-| DATE
+| DATE(7)
 | not null
+|
@@ Line 76: / Line 76: @@
 |-
 | CALENDAR_MONTH_NUMBER
-| NUMBER
+| NUMBER(2, 0)
 | not null
+|
@@ Line 83: / Line 83: @@
 |-
 | FISCAL_MONTH_NUMBER
-| NUMBER
+| NUMBER(2, 0)
 | not null
+|
@@ Line 90: / Line 90: @@
 |-
 | CALENDAR_MONTH_DESC
-| VARCHAR2
+| VARCHAR2(8)
 | not null
+|
@@ Line 104: / Line 104: @@
 |-
 | FISCAL_MONTH_DESC
-| VARCHAR2
+| VARCHAR2(8)
 | not null
+|
@@ Line 132: / Line 132: @@
 |-
 | END_OF_CAL_MONTH
-| DATE
+| DATE(7)
 | not null
+|
@@ Line 139: / Line 139: @@
 |-
 | END_OF_FIS_MONTH
-| DATE
+| DATE(7)
 | not null
+|
@@ Line 146: / Line 146: @@
 |-
 | CALENDAR_MONTH_NAME
-| VARCHAR2
+| VARCHAR2(9)
 | not null
+|
@@ Line 153: / Line 153: @@
 |-
 | FISCAL_MONTH_NAME
-| VARCHAR2
+| VARCHAR2(9)
 | not null
+|
@@ Line 202: / Line 202: @@
 |-
 | END_OF_CAL_QUARTER
-| DATE
+| DATE(7)
 | not null
+|
@@ Line 209: / Line 209: @@
 |-
 | END_OF_FIS_QUARTER
-| DATE
+| DATE(7)
 | not null
+|
@@ Line 216: / Line 216: @@
 |-
 | CALENDAR_QUARTER_NUMBER
-| NUMBER
+| NUMBER(1, 0)
 | not null
+|
@@ Line 223: / Line 223: @@
 |-
 | FISCAL_QUARTER_NUMBER
-| NUMBER
+| NUMBER(1, 0)
 | not null
+|
@@ Line 230: / Line 230: @@
 |-
 | CALENDAR_YEAR
-| NUMBER
+| NUMBER(4, 0)
 | not null
+|
@@ Line 244: / Line 244: @@
 |-
 | FISCAL_YEAR
-| NUMBER
+| NUMBER(4, 0)
 | not null
+|
@@ Line 272: / Line 272: @@
 |-
 | END_OF_CAL_YEAR
-| DATE
+| DATE(7)
 | not null
+|
@@ Line 279: / Line 279: @@
 |-
 | END_OF_FIS_YEAR
-| DATE
+| DATE(7)
 | not null
+|