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 vote141 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote167 views3 answers
Mysql CAST(amount as float)
SQL
0 vote161 views1 answer
Insert output identity
SQL
0 vote124 views1 answer
Mariadb maximum left join
SQL
1 vote128 views1 answer
Mysql check table exists
SQL
1 vote125 views1 answer
Mysql history command
SQL
0 vote123 views1 answer
Is numeric in sql
SQL
2 votes125 views1 answer
While loop sql
SQL
0 vote136 views1 answer
Sql track modification
SQL
0 vote151 views1 answer
Openquery update linked server
SQL