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

1 vote222 views1 answer
Mysql backup skip table
SQL
5 votes233 views2 answers
Sql number columns
SQL
0 vote205 views1 answer
Mysql page segment
SQL
0 vote224 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
5 votes239 views3 answers
Show indexes mysql
SQL
5 votes241 views1 answer
Oracle add time to date
SQL
4 votes220 views2 answers
Mysql show indexes on table
SQL
0 vote248 views2 answers
Pl sql auto increment
SQL
-1 vote213 views1 answer
Mysql coalesce
SQL
15 votes225 views3 answers
Find duplicate keys in mysql
SQL