Previous: business_meeting_detail | Unanet Data Model | Next: cash_return_detail |
Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
1. | PK | business_week_key | decimal(15) | |||
2. | name | varchar(25) | ||||
3. | hours | decimal(4,2) | ((8)) | |||
4. | sunday | char(1) | ('N') | |||
5. | monday | char(1) | ('Y') | |||
6. | tuesday | char(1) | ('Y') | |||
7. | wednesday | char(1) | ('Y') | |||
8. | thursday | char(1) | ('Y') | |||
9. | friday | char(1) | ('Y') | |||
10. | saturday | char(1) | ('N') |
Table | Column | Foreign Key Name |
person | business_week_key | fk_person11 |
Index Name | Unique | Column Name | Asc Or Desc |
pk_business_week | true | business_week_key | Asc |
idx_business_week1 | true | name | Asc |