ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
SH.TIMES_(table)
Print
RSS
Modified: 2009/08/29 21:04 by
wikibot
-
Uncategorized
»
public.qrtz_job_details_(table)
»
public.getoutagetimeinwindow_(function)
»
SH.TIMES_(table)
[X]
»
public.qrtz_job_details_(table)
»
public.getoutagetimeinwindow_(function)
»
SH.TIMES_(table)
Edit
wikibot
Table
SH.TIMES
Column
Data Type
Nullable
Default
PK
Index
TIME_ID
DATE(7)
not null
TIMES_PK
DAY_NAME
VARCHAR2(9)
not null
DAY_NUMBER_IN_WEEK
NUMBER(1, 0)
not null
DAY_NUMBER_IN_MONTH
NUMBER(2, 0)
not null
CALENDAR_WEEK_NUMBER
NUMBER(2, 0)
not null
FISCAL_WEEK_NUMBER
NUMBER(2, 0)
not null
WEEK_ENDING_DAY
DATE(7)
not null
WEEK_ENDING_DAY_ID
NUMBER
not null
CALENDAR_MONTH_NUMBER
NUMBER(2, 0)
not null
FISCAL_MONTH_NUMBER
NUMBER(2, 0)
not null
CALENDAR_MONTH_DESC
VARCHAR2(8)
not null
CALENDAR_MONTH_ID
NUMBER
not null
FISCAL_MONTH_DESC
VARCHAR2(8)
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(7)
not null
END_OF_FIS_MONTH
DATE(7)
not null
CALENDAR_MONTH_NAME
VARCHAR2(9)
not null
FISCAL_MONTH_NAME
VARCHAR2(9)
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(7)
not null
END_OF_FIS_QUARTER
DATE(7)
not null
CALENDAR_QUARTER_NUMBER
NUMBER(1, 0)
not null
FISCAL_QUARTER_NUMBER
NUMBER(1, 0)
not null
CALENDAR_YEAR
NUMBER(4, 0)
not null
CALENDAR_YEAR_ID
NUMBER
not null
FISCAL_YEAR
NUMBER(4, 0)
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(7)
not null
END_OF_FIS_YEAR
DATE(7)
not null
Detail Table
Column
Referencing Column
SH.COSTS
TIME_ID
TIME_ID
SH.SALES
TIME_ID
TIME_ID
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.