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

5 votes196 views2 answers
Sql server check port number
SQL
3 votes201 views2 answers
How to start postgresql on windows
SQL
0 vote327 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote213 views1 answer
Createdb with postgresql on ubuntu
SQL
4 votes213 views2 answers
Tables in sql
SQL
0 vote190 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote192 views1 answer
Csv to sqlite python
SQL
0 vote214 views1 answer
Sql put two columns into one
SQL
19 votes216 views6 answers
Sql server drop table if exists
SQL
0 vote227 views2 answers
While mysql
SQL