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 vote149 views1 answer
Mysql relationships between tables
SQL
0 vote125 views1 answer
Sp in sql server
SQL
0 vote123 views1 answer
How to add timestamp column in mysql
SQL
0 vote118 views1 answer
Get all employees if name ends with in sql
SQL
1 vote120 views1 answer
Mysql list bigger table
SQL
7 votes122 views1 answer
Alter sequence set current value oracle
SQL
1 vote115 views1 answer
Sql bitwise operators
SQL
0 vote140 views1 answer
Offset in postgresql example
SQL
0 vote118 views1 answer
Oracle service name view
SQL
0 vote114 views1 answer
Plpgsql if statement
SQL