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 vote159 views2 answers
Test sqlsrv connection
SQL
0 vote194 views1 answer
Reindexing all tables sql server
SQL
10 votes241 views2 answers
Doublon sql
SQL
0 vote158 views1 answer
Mysql_union
SQL
2 votes150 views2 answers
Select multiple tables mysql
SQL
0 vote150 views1 answer
Oracle sql procedure return value
SQL
0 vote164 views1 answer
Sql server Cost Fifo query
SQL
2 votes166 views2 answers
Change mysql password from command line
SQL
2 votes148 views1 answer
Oracle number to percentage
SQL
1 vote174 views1 answer
Sql list all procedures
SQL