department

58 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
outlet.dept_id outlet_dept_id_fkey R
charge_schedule.charge_dept fk_charge_schedule_charge_dept R
deposit.payment_id fk_deposit_payment_type R
folio_details.dept_id fk_folio_details_dept_id C
folio_pattern_details.dept_id fk_folio_pattern_details_dept_id C
guest_request.charge_dept fk_guest_request_charge_dept R
inclusion.charge_dept inclusion_department_fk R
itemizer_summary.dept_id fk_itemizer_summary_dept_id R
rate_inclusion.charge_dept rate_inclusion_dept_id_fk R
registration_rates.room_charge_dept fk_registration_rates_room_charge_dept N
transaction_summary.dept_id fk_transaction_summary_dept_id R
transactions.dept_id fk_transactions_dept_id R
code text 2147483647 √ null
name text 2147483647 null
group_id int4 10 √ null
department_group.id department_group_id_fkey R
post_type bpchar 1 null

P = Post S = Settle
dept_type bpchar 1 'D'::bpchar

D = Debit C = Credit
require_info bool 1 √ false
taxes _varchar 2147483647 √ null
enabled bool 1 √ true
tax_code text 2147483647 √ null
tax.code fk_department_tax_code N
itemizers _text 2147483647 √ null
vat_effect bool 1 true

Indexes

Constraint Name Type Sort Column(s)
department_pkey Primary key Asc id
department_code_unq Must be unique Asc code
department_dept_type_idx Performance Asc dept_type
department_group_id_idx Performance Asc group_id
department_post_type_idx Performance Asc post_type

Check Constraints

Constraint Name Constraint
department_post_type_check (post_type = ANY (ARRAY['P'::bpchar, 'S'::bpchar]))
department_dept_type_check (dept_type = ANY (ARRAY['D'::bpchar, 'C'::bpchar]))

Relationships

Close relationships within degrees of separation