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

0 vote244 views1 answer
Delete a record from a table sqlite3
SQL
0 vote227 views1 answer
Get foreign table names mysql
SQL
17 votes237 views2 answers
Mysql date to string
SQL
1 vote281 views2 answers
Laravel jwt generate token
SQL
1 vote251 views1 answer
Vagrant mysql downgrade version
SQL
0 vote218 views1 answer
Sort by last two number sql
SQL
4 votes227 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote261 views1 answer
Oracle session statistics
SQL
0 vote267 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote238 views2 answers
How to get last inserted id in sql server c#
SQL