Tables : alf_prop_date_value


Columns

10

Keys

1

Triggers

0

Comment:

Description:

Indexes

1

Contraints

0


Columns :

Name Caption Primary Key type
date_value date_value true BIGINT
full_year full_year INTEGER
half_of_year half_of_year SMALLINT
quarter_of_year quarter_of_year SMALLINT
month_of_year month_of_year SMALLINT
week_of_year week_of_year SMALLINT
week_of_month week_of_month SMALLINT
day_of_year day_of_year INTEGER
day_of_month day_of_month SMALLINT
day_of_week day_of_week SMALLINT

Keys :

Name Primary Key Description
alf_prop_date_value_pkey true

Indexes

Name UNIQUE Type Description
idx_alf_propdt_dt Ascending

Columns Detail :

Name date_value
Table alf_prop_date_value
Type BIGINT
Domain
Primary Key true
Not null true

Name full_year
Table alf_prop_date_value
Type INTEGER
Domain
Not null true

Name half_of_year
Table alf_prop_date_value
Type SMALLINT
Domain
Not null true

Name quarter_of_year
Table alf_prop_date_value
Type SMALLINT
Domain
Not null true

Name month_of_year
Table alf_prop_date_value
Type SMALLINT
Domain
Not null true

Name week_of_year
Table alf_prop_date_value
Type SMALLINT
Domain
Not null true

Name week_of_month
Table alf_prop_date_value
Type SMALLINT
Domain
Not null true

Name day_of_year
Table alf_prop_date_value
Type INTEGER
Domain
Not null true

Name day_of_month
Table alf_prop_date_value
Type SMALLINT
Domain
Not null true

Name day_of_week
Table alf_prop_date_value
Type SMALLINT
Domain
Not null true

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description