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 vote261 views1 answer
What is default mysql database password in linux
SQL
0 vote227 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote261 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote262 views1 answer
Pgadmin see indexes
SQL
0 vote280 views1 answer
Excel export from sql using python
SQL
0 vote272 views1 answer
Get rows from 1 table with other table empty mysql
SQL
-1 vote287 views1 answer
Add 10 to all numbers in a column sql
SQL
6 votes324 views2 answers
Oracle compile trigger
SQL
25 votes331 views5 answers
Mysql replace text
SQL
22 votes286 views4 answers
Date format mysql
SQL