Ruddr

Explore the interactive ERD

Column	Type	Keys
`id`	Unknown	PK
`client_id`	Unknown	FK
`practice_id`	Unknown	FK
`billing_type_id`	Unknown
`budget_billable_expense`	Unknown
`budget_billable_hour`	Unknown
`budget_mode`	Unknown
`budget_non_billable_expense`	Unknown
`budget_non_billable_hour`	Unknown
`budget_other_revenue`	Unknown
`budget_revenue`	Unknown
`budget_services_revenue`	Unknown
`code`	Unknown
`created_at`	Unknown
`currency`	Unknown
`ends`	Unknown
`fixed_fee`	Unknown
`fixed_recurring_end`	Unknown
`fixed_recurring_fee`	Unknown
`fixed_recurring_start`	Unknown
`is_billable`	Unknown
`is_productive`	Unknown
`key`	Unknown
`monthly_budget_billable_expense`	Unknown
`monthly_budget_billable_hour`	Unknown
`monthly_budget_mode`	Unknown
`monthly_budget_non_billable_expense`	Unknown
`monthly_budget_non_billable_hour`	Unknown
`monthly_budget_other_revenue`	Unknown
`monthly_budget_revenue`	Unknown
`monthly_budget_services_revenue`	Unknown
`name`	Unknown
`notes`	Unknown
`po_number`	Unknown
`project_type_id`	Unknown
`project_type_name`	Unknown
`record_status_id`	Unknown
`requires_notes`	Unknown
`requires_tasks`	Unknown
`revenue_recognition_method`	Unknown
`start`	Unknown
`status_id`	Unknown
`use_budget`	Unknown
`use_monthly_budget`	Unknown
`use_roles`	Unknown

Column	Type	Keys
`id`	Unknown	PK
`practice_id`	Unknown	FK
`code`	Unknown
`created_at`	Unknown
`currency`	Unknown
`invoice_notes`	Unknown
`is_internal`	Unknown
`key`	Unknown
`name`	Unknown
`notes`	Unknown
`owner_id`	Unknown
`owner_name`	Unknown
`payment_terms_id`	Unknown
`record_status_id`	Unknown
`street_address`	Unknown
`use_workspace_invoice_details`	Unknown

Column	Type	Keys
`index`	Unknown	PK
`member_availability_period_id`	Unknown	PKFK
`member_id`	Unknown	PKFK
`hour_per_day`	Unknown

Column	Type	Keys
`id`	Unknown	PK
`location_id`	Unknown	FK
`practice_id`	Unknown	FK
`active_end_date`	Unknown
`active_start_date`	Unknown
`cost_method_id`	Unknown
`created_at`	Unknown
`default_rate`	Unknown
`default_rate_currency`	Unknown
`discipline_id`	Unknown
`discipline_name`	Unknown
`email`	Unknown
`employment_type_id`	Unknown
`forbid_timesheet_submission_when_below_capacity`	Unknown
`holiday_schedule_id`	Unknown
`holiday_schedule_name`	Unknown
`internal_id`	Unknown
`internal_notes`	Unknown
`invitation_status_id`	Unknown
`is_active`	Unknown
`is_billable`	Unknown
`job_title_id`	Unknown
`job_title_name`	Unknown
`login_enabled`	Unknown
`manager_id`	Unknown
`manager_name`	Unknown
`name`	Unknown
`receive_missing_time_reminders`	Unknown
`security_role_id`	Unknown
`security_role_name`	Unknown
`time_off_allowed`	Unknown
`time_off_approval_mode`	Unknown
`time_off_approver_id`	Unknown
`time_off_approver_name`	Unknown
`unsubmitted_timesheet_reminders`	Unknown