tbl_office_time_sheet_entry

854436 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
refid serial 10 √ nextval('tbl_office_time_sheet_entry_refid_seq'::regclass)
tbl_office_time_sheet_entry_details.officetimesheetentryrefid office_time_sheet_entry_details_officetimesheetentryrefid_fkeyC
invoicecoderefid varchar 30 √ null
tbl_invoice_code_lookup.invoicecode tbl_office_time_sheet_entry_invoicecoderefid_fkeyR
taskcoderefid varchar 30 √ null
tbl_task_code_lookup.taskcode tbl_office_time_sheet_entry_taskcoderefid_fkeyR
officetimesheetrefid int4 10 √ null
tbl_office_time_sheet.refid office_time_sheet_entry_officetimesheetrefid_fkeyC
authorized bool 1 √ true
colour varchar 20 √ null
note text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
office_time_sheet_entry_pkey Primary key Asc refid
idx_office_time_sheet_fk Performance Asc officetimesheetrefid

Relationships

Close relationships within degrees of separation