Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table work_expenses
(
  work_expensesid     integer   not null generated always as identity primary key,
  workid              integer,
  employeeid          integer,
  date_linkid         integer,
  expense_categoryid  integer,
  cost_incl_gst       numeric,
  note                text   
)       

CREATE TABLE


INSERT INTO work_expenses 
  (workid,employeeid,date_linkid,expense_categoryid,cost_incl_gst,note)
VALUES
  (NULL, 1,220,4,5.00,NULL),
  (NULL, 1,220,5,33.75,NULL),
  (631, 1,218,13,21.50,'trailer load of tree branches');

INSERT 0 3


select *
from work_expenses;


work_expensesid
workid
employeeid
date_linkid
expense_categoryid
cost_incl_gst
note


1
null
1
220
4
5.00
null

2
null
1
220
5
33.75
null

3
631
1
218
13
21.50
trailer load of tree branches



SELECT 3

work_expensesid	workid	employeeid	date_linkid	expense_categoryid	cost_incl_gst	note
1	null	1	220	4	5.00	null
2	null	1	220	5	33.75	null
3	631	1	218	13	21.50	trailer load of tree branches