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 vote339 views1 answer
Lpad function in sql oracle
SQL
8 votes364 views10 answers
Sql
SQL
0 vote354 views1 answer
Mysql root permission denied lost
SQL
0 vote356 views1 answer
Mysql loop through databases and execute query
SQL
0 vote345 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
3 votes355 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote343 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
1 vote354 views1 answer
Python escape mysql
SQL
1 vote376 views1 answer
Connect to mysql database ubuntu
SQL
0 vote360 views1 answer
How to select a row in sql
SQL