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 vote328 views1 answer
Is numeric in sql
SQL
0 vote346 views1 answer
Make a socket server to detect changes in mysql
SQL
58 votes651 views6 answers
Create new user in postgres
SQL
13 votes407 views3 answers
Mysqldump structure only
SQL
2 votes346 views1 answer
Get first 2 letter in sql
SQL
0 vote362 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
8 votes337 views1 answer
Database backup in mysql server recovery
SQL
0 vote339 views1 answer
Mysql check datetime equals date
SQL
3 votes334 views2 answers
Sqlite show table definition
SQL
0 vote356 views1 answer
Mysql exception output
SQL