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

7 votes193 views1 answer
Safe mode mysql
SQL
1 vote204 views1 answer
Sql list all procedures
SQL
0 vote197 views1 answer
How to find top 3 salary in sql
SQL
0 vote208 views1 answer
Top frequency in sql server
SQL
1 vote184 views1 answer
Sql myisam vs innodb
SQL
0 vote218 views1 answer
Select top values sql
SQL
3 votes216 views2 answers
How to delete git repo locally
SQL
23 votes195 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote223 views3 answers
Duplicate row mysql
SQL
2 votes236 views3 answers
Row number mysql
SQL