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

2 votes203 views1 answer
Check isolation level in mysql
SQL
6 votes225 views3 answers
What is where in sql
SQL
1 vote223 views1 answer
Postgresql round double precision
SQL
0 vote203 views1 answer
My sql data file extention
SQL
0 vote187 views1 answer
View acl table oracle
SQL
0 vote271 views1 answer
Mysql wsrep ls
SQL
0 vote207 views1 answer
Order by with where clause in mysql
SQL
0 vote201 views1 answer
Sql server check whether column has same equal values
SQL
0 vote202 views2 answers
Plsql regex match whole word
SQL
1 vote262 views1 answer
Is sql fast
SQL