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 vote227 views1 answer
Sql runnignsum
SQL
0 vote249 views1 answer
Bigquery declare
SQL
0 vote213 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote267 views2 answers
Sql query inner join 3 tables
SQL
6 votes253 views4 answers
Eloquent to sql with bindings
SQL
15 votes253 views4 answers
T-sql drop function if exists
SQL
5 votes255 views1 answer
Sql use database
SQL
2 votes205 views1 answer
Oracle current date without time
SQL
3 votes551 views1 answer
Postgresql cast
SQL
0 vote202 views1 answer
Oracle last user logon
SQL