tbl_invoice_code_lookup

14974 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
invoicecode varchar 30 null
tbl_invoice_group_matrix.invoicecoderefid tbl_invoice_group_matrix_invoicecoderefid_fkeyC
tbl_office_time_sheet_entry.invoicecoderefid tbl_office_time_sheet_entry_invoicecoderefid_fkeyR
projectname varchar 50 √ null
supervisor int4 10 √ null
tbl_staff_lookup.refid tbl_invoice_code_lookup_supervisor_fkeyR
projectmanager int4 10 √ null
tbl_staff_lookup.refid tbl_invoice_code_lookup_projectmanager_fkeyR
department varchar 20 √ null
requiresauthorization bool 1 √ false
taskneeded bool 1 √ true
completed varchar 10 √ 'ongoing'::character varying

Indexes

Constraint Name Type Sort Column(s)
invoice_code_lookup_pkey Primary key Asc invoicecode
ids_tbl_invoice_code_lookup Must be unique

Relationships

Close relationships within degrees of separation