Sql table to store status

CREATE TABLE status
(
  id integer PRIMARY KEY,
  name TEXT NOT NULL,
  next_status Integer references status
);

insert into status(id, name, next_status)
values 
(1,'init', 2),
(2,'waiting ror price approve', 3),
(3,'sent', 4),
(4,'accepted', 5),
(5,'finished', null);

Source: stackoverflow.com

Similar codes

23 votes330 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote321 views1 answer
How to add unique key constraint in mysql
SQL
5 votes313 views1 answer
Postgresql functions
SQL
4 votes325 views2 answers
Dbms output
SQL
1 vote321 views1 answer
Retrieve meaning
SQL
0 vote252 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
3 votes312 views1 answer
Oracle revoke grant
SQL
0 vote299 views2 answers
2nd max salary query in sql
SQL
0 vote309 views1 answer
Mysql docker image arjun
SQL
1 vote324 views3 answers
Nth highest salary
SQL