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

10 votes145 views4 answers
How to alter table name in mysql
SQL
0 vote145 views1 answer
Mysql remove tabs from string
SQL
0 vote170 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote143 views1 answer
Sql select most frequent value in group
SQL
0 vote774 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote141 views1 answer
Select all tables linked server sql
SQL
1 vote477 views1 answer
Mysql event last execution
SQL
0 vote153 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote118 views1 answer
Create duplicate table postgres
SQL
0 vote148 views2 answers
Update all columns in one update
SQL