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

3 votes324 views1 answer
Mysql group_concat distinct
SQL
1 vote274 views1 answer
Select 2 rows in sql
SQL
3 votes271 views1 answer
Sql server check version
SQL
1 vote318 views1 answer
Opensuse restart MySQL
SQL
0 vote256 views1 answer
Mysql database is not starting in xampp
SQL
0 vote281 views1 answer
Drush run sql select
SQL
1 vote273 views1 answer
Sql convert month name to number
SQL
1 vote323 views1 answer
Create email address from first and last name in sql
SQL
0 vote266 views1 answer
Delete double on SQL with multiple primary keys
SQL
23 votes289 views2 answers
Query to delete a database in mysql
SQL