Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| tds_cycle_window_id | serial | 10 | √ | nextval('tbl_tds_cycle_window_tds_cycle_window_id_seq'::regclass) |
|
|
||
| tds_cycle_id | int4 | 10 | null |
|
|
|||
| tds_cycle_title | varchar | 50 | null |
|
|
|||
| tds_cycle_from | timestamp | 29,6 | null |
|
|
|||
| tds_cycle_to | timestamp | 29,6 | null |
|
|
|||
| tds_cycle_document_required | bool | 1 | null |
|
|
|||
| tds_cycle_remark | varchar | 500 | null |
|
|
|||
| tds_created_by | varchar | 50 | null |
|
|
|||
| tds_created_date | timestamp | 29,6 | null |
|
|
|||
| tds_is_deleted | bool | 1 | √ | null |
|
|
||
| tds_cycle_approval_required | bool | 1 | √ | true |
|
|
||
| tds_excel_file_name | varchar | 100 | √ | null |
|
|
||
| tds_sheet_year | varchar | 100 | √ | null |
|
|
||
| createdby | varchar | 50 | √ | null |
|
|
||
| createddate | timestamp | 29,6 | √ | null |
|
|
||
| modifiedby | varchar | 50 | √ | null |
|
|
||
| modifieddate | timestamp | 29,6 | √ | null |
|
|
||
| cycletype | varchar | 20 | √ | null |
|
|
||
| newemployeesdays | int4 | 10 | √ | null |
|
|
||
| tds_cycle_start_email_notification | bool | 1 | √ | null |
|
|
||
| tds_cycle_start_push_notification | bool | 1 | √ | null |
|
|
||
| tds_cycle_end_email_notification | bool | 1 | √ | null |
|
|
||
| tds_cycle_end_push_notification | bool | 1 | √ | null |
|
|
||
| tds_cycle_end_email_notification_no_ofdays | int4 | 10 | √ | null |
|
|
||
| tds_cycle_end_push_notification_no_ofdays | int4 | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tbl_tds_cycle_window_pk_tbl_tds_cycle_window | Primary key | Asc | tds_cycle_window_id |
Relationships
Close relationships within degrees of separation
