tbl_charge_groups

19 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
groupid serial 10 √ nextval('tbl_charge_groups_groupid_seq'::regclass)
tbl_charge_group_project.groupid tbl_charge_group_project_groupid_fkeyC
tbl_charge_rates.groupid tbl_charge_rates_groupid_fkeyC
group_type varchar 10 √ null
cost_centre varchar 50 null
tbl_cost_centre.cost_centre tbl_charge_groups_cost_center_fkeyC
group_name varchar 10 null
group_year varchar 4 √ null
timestamp timestamp 29,6 √ now()
entered_by int4 10 √ null
tbl_staff_lookup.refid tbl_charge_rates_entered_by_fkeyR

Indexes

Constraint Name Type Sort Column(s)
tbl_charge_groups_pkey Primary key Asc groupid

Relationships

Close relationships within degrees of separation