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 vote199 views1 answer
Delete record by id sql
SQL
0 vote196 views1 answer
Oracle date winter time
SQL
0 vote178 views1 answer
Hive batch drop table
SQL
0 vote190 views1 answer
Oracle date summer time
SQL
0 vote188 views1 answer
Horizontal join sqlite
SQL
-1 vote198 views2 answers
First letter capital in mysql query
SQL
8 votes196 views2 answers
How to fetch data from database without last column
SQL
0 vote186 views1 answer
Show create table in postgresql
SQL
-1 vote210 views1 answer
Auto increment psql not primary key
SQL
5 votes193 views1 answer
Mysql last day of next month
SQL