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

1 vote118 views1 answer
Regular expression in sql server
SQL
0 vote138 views1 answer
Nodejs sql get one to many relationship as array
SQL
0 vote129 views1 answer
Power bi union columns
SQL
0 vote130 views1 answer
Convert .mdf to .bak
SQL
1 vote124 views1 answer
Funzioni plsql
SQL
0 vote127 views1 answer
Sql alter table order by
SQL
1 vote118 views1 answer
T-sql find object by name
SQL
0 vote141 views1 answer
Arithmetic expression in sql
SQL
1 vote71 views1 answer
File /etc/init.d/mysql not exists
SQL
4 votes122 views2 answers
How to count items with same name in sql
SQL