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

2 votes123 views2 answers
Function in sql
SQL
21 votes101 views7 answers
Table drop if exist sql server
SQL
2 votes132 views2 answers
Sqlalchemy filter or
SQL
22 votes134 views4 answers
Mysql reset auto increment id
SQL
0 vote129 views1 answer
Data directory postgresql
SQL
0 vote142 views1 answer
How to print sql query
SQL
2 votes130 views1 answer
Anonymous block plsql
SQL
1 vote128 views1 answer
Get all db sizes in mysql server
SQL
2 votes132 views1 answer
Sqlite show table indexes
SQL
0 vote130 views1 answer
Database xml sql
SQL